Jump to content
Sign in to follow this  
rik1

Finding Carriage Returns

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Cheers Fubar -

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

Substitute(Description, "

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.