search and replace "return"

[wobbie]

Can i perform a search and replace on the 'return' character' and replace it with for example

What is the wildcard for this character?

Thanks

[Zero Tolerence]

in your script editor there is a button:

¶

Just replace it with

[Lee Smith]

I'm assuming that you are NOT using a script, but instead using the Find/Replace under the Edit menu.

If so, Use the Key Combination of "Option + 7" which is the Pilcrow Sign aka Paragraph symbol "¶"

do your find for

¶

Replace

(or nothing or whatever the br stands for.

Lee

[wobbie]

works for me with option 6

thanks for the quick response !

[FileKat]

I tried to do a Find on ¶ but got "no records match..." I need to remove the "returns" at the end of field (i.e. First Name, Last Name,etc) as well as any spaces. "Trim" takes care of removing spaces but does nothing for "returns." I have a large database that I need to search for "returns" in multiple fields and then remove them. Any suggestions?

Thanks for your help.

[Lee Smith]

Use the Substitute Function for that part.

Trim(Substitute (YourField; "¶"; ""))

[FileKat]

Thank you so much. It worked and actually took care of both operations at once.