Convertinga character to a carriage return

[nsl]

I have a postal address field, the content is stored in one long string, each part of the address field is seperated with a small outline square character. I want to convert this to carriage return so that the address feild appears on 3 lines rather than 1 long line.

[Vaughan]

The Substitute() function is used for this kind of string manipulation. The tricky bit for you is specifying the <unprintable> character in the function.

Try the easy stuff first: copy the square and paste it into the function, see if it works.

[nsl]

I can edit/replace the square character to another character, but I cannot find the option to convert the square character to a carriage return.

I tried pasting the

[Lee Smith]

Hi nsl,

You will need to capture one of the square box characters, and use that in your searches. Sometimes it is easier to set up a global field for this purpose, paste your character in it, and then use the field for finds, scripts, etc.

BTW, I'm trying to figure out why this question was posted to this Topic area instead of [color:"blue"]"FileMaker Functions & Features >> Finding & Searching" which seems to fit the sprit of your question better.

HTH

Lee