Remove Special Characters?

[rellis32]

I have a field that is populated from the web off a form using GetLayoutObjectAttribute... This field is then included in a meeting request for use in Outlook, basically an .ical file. This is what I'm importing:

Case Summary: cust unable to browse*

Description:*SAT:hzn*

*TRANS:11 K

*Software Version:

*SERIAL_NUMBER: etc.....

I have used the "*" to illustrate where my problem lies, in filemaker it shows up as a "square", I'm assuming this is some sort of unicode character. I thought it was a carriage return, but using the substitute function am unable to get rid of it. In ultra edit this shows up as a carriage return, not sure why the substitute isn't replacing it. I have tried all different kinds of variations to try and get rid of this, as it is playing havoc with my ical file. Is there anyway of determining for sure what this character is so I can rid my field of this evil pest?

TIA

Bob

[BobWeaver]

You could use the filter function to exclude everything except printable characters.

Filter(importtext;"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ,./;'[]-=!@#$%^&*()_+{}<>"?|")

Can't remember if Filter is case sensitive, so you may need to include the lower case alphabet in there too.

[rellis32]

I'll give this a shot, thanks!

I used a CF that basically does what you were referring to, only replaces the non alphanumeric characters with whatever you would like, worked like a charm. Thank you again for the idea!

Edited October 18, 2006 by Guest