Finding carriage returns & replace

[norcomm]

How can I find carriage returns in a text field and replace them with a text string? Any Ideas?

[Lee Smith]

Yes you can.

First put your cursor in the field that you are making the change in:

If you are using version 6.x there is a new feature in the Edit Menu - Find Replace. You need to copy an actual return and paste it in the Find Box, and in the Replace put in your Text String.

If you using a version prior to 6, then you can do this using the Replace (Cmd = on a Mac), Menu - Records - Replace. Choose the option to Replace by Calculated Results and then Use the Substitute Function.

Your calculation would look something like this.

Substitute(YourField, "?", "your text string")

Note:

Put your cursor in the field First, and be sure to put Quotes around the Paragraph symbol "?" and the Text String.

[color:"red"]

Warning:

This is Not Reversible so test it first on a copy of your file, or make a sample file up.

HTH

Lee

[cjaeger]

it is reversible, provided the string is somewhat unique ...

Substitute(YourField, "your text string", "?", )

[Lee Smith]

Hi cj,

In this case it probably could be reversed. However, I think it is wise when using this function that you treat it as non-reversible to ensure that you don't lose data you thought you could retrieve by just hitting Cmd -Z (UNDO) to retrieve.

Better to be safe than sorry,

Lee