How to filter out field-string not containing # sign ?? 1

[petrovlis]

I have to filter out fields which contains sometimes
somewhere in the field the # sign.
like
Field 1: abc#fag
or
Field 1: a#hdgaf

etc

tried to find in help file but cannot find it so easily.
Thanks for help
William

 

[lupins46]

What do mean by 'filter out fields'?
Do you mean you only want to select RECORDS which do not have a # in a particular field?

 

[petrovlis]

YES I mean I want to select RECORDS which do not have a # in a particular field

Thnaks for further help
William

 

[lupins46]

Use the Select Expert and choose 'is not like' from the drop-down and put *#* in the value box.

 

[dgillz]

Write a record selection formula:

Instr({YourField},"#")=0

This will give you all the records tat do ot contain a # anywhere in the field.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz