Text string conversion.

[Vincent Koh]

Hi everybody,

I am trying to find a way to work this into my script.

I have a search field. (Text)

When I type "Test 1"(notice that there are many spaces), I am trying to convert my text string to just "Test 1". Or when I type "Test 1 2", I hope to convert the text string to "Test 12".

At first I though I could use the Trim function but apparently it didn't seem to work. Hope someone can help.

Thanks.

[comment]

TrimAll ( text ; 0 ; 0 )

will convert "Test 1" to "Test 1". I don't quite see the logic behind:

Or when I type "Test 1 2", I hope to convert the text string to "Test 12".

[Vincent Koh]

Thanks so much. Will give it a try. Actually what I am trying to do is I have set up a input field. I am trying to anticipate that the user when inputing the name of a company(which is the field the user may include extra space and when this happens company name "Test 1" will be different form company name "Test 1" when they are actually the same company and may cause duplicates in records. Maybe there could be a better method but I am still pretty new to FM and database. Hope my explanation make sense. :)