Imported special characters

[janet K]

Hi Everyone,

The datafile that I was given to work with has returns in it that are showing up in filemaker as ~}crlf} I know I can do a find and replace and take that data out but is there a symbol in filemaker that I can use that will put a return in so the data in this text field will show up properly.

This is what it looks like:

choral groups 9-12~}crlf}drama productions 9-12~}crlf}stu gov 9-12 class rep~}crlf}NHS 11, 12 VP~}crlf}special olympics 11, 12

This is what it should look like:

choral groups 9-12

drama productions 9-12

stu gov 9-12 class rep

NHS 11, 12 VP

special olympics 11, 12

Suggestions?

[comment]

Try:

Substitute ( ImportedField ; "~}crlf}" ; ¶ )

[janet K]

:tigger:

Thanks...that worked.

Janet

[Cabinetman]

Oh that everything was that easy....