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.

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.

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