rik1 0 Posted November 6, 2001 I'm exporting data from filemaker into MYOB but where an employee has entered a return/linefeed in one of the fields MYOB rejects that field. Is there a way to search for a return such as "/p" or something similar? Quote Share this post Link to post Share on other sites
FUBAR 0 Posted November 6, 2001 Using scripts, you can find the character symbol that denotes a carriage return (i.e. Set Field: Specify)The sympol looks like a backwards P with two lines and the top part filled in.Hope this helps Quote Share this post Link to post Share on other sites
FUBAR 0 Posted November 6, 2001 symbol, symbol, not sympol...I hates it when I gets mah p's and b's mixed up! Quote Share this post Link to post Share on other sites
rik1 0 Posted November 6, 2001 Cheers Fubar - Have sorted it by creating a new field (Description 2) with the calculation:Substitute(Description, " Quote Share this post Link to post Share on other sites
Vaughan 103 Posted November 7, 2001 If you want to "permanently" change the original field, do a replace on it using a calculated result, the calculation being what you worked out already. Back up the database before doing it though! Quote Share this post Link to post Share on other sites