Search field that contains blank line...

[J.P.]

I was wondering if its possible to do a search some text field that starts with space or has blank line.

Example in a text field users are entering codes by pressing space first or pressing enter key after they enter information.

I need to find and eliminate all those information that contains space or blank line.

We have tons of records and it is impossible going line by line.

Thanks in advance.

[Matthew F]

To find fields which start with a space create a calculation field of type text which has the following formula: left(YourField, 1). Now perform a find on this field with "== " (no quotes).

To find fields which end with a return character then create a similar calculation field using the formula: right(YourField, 1). Now perform a find. Since you can't type "return" without executing the find you should instead copy and paste it from another field.

I hope this helps.

[jasonwood]

You can use the "Trim" function to remove leading and trailing spaces, but I don't think it will strip carriage returns.

Here's how it might work if you wanted to operate on the entire database:

Show all records

Loop

Set field, MYFIELD, Trim(MYFIELD)

Go to record, next (exit after last)

End Loop