Jump to content

Finding carriage returns & replace


norcomm
 Share

This topic is 6767 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

cool.gif

Link to comment
Share on other sites

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

tongue.gif

Link to comment
Share on other sites

This topic is 6767 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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