Finding Carriage Returns

[rik1]

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?

[FUBAR]

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

[FUBAR]

symbol, symbol, not sympol...I hates it when I gets mah p's and b's mixed up!

[rik1]

Cheers Fubar -

Have sorted it by creating a new field (Description 2) with the calculation:

Substitute(Description, "

[Vaughan]

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!