wildmatch

[#1]

Hello,

I have a text field in my data source and for some of the records, the text field starts with a '*'.

I want to load only those records.

Tried :

Wildmatch (Text,'*')

Wildmatch(Text, chr(042))

This is not working properly, any help ?

Thanks

[lironbaram]

you can try

left(Text,1) ='*'

[sunny_talwar · Accepted solution]

May be try this:

WildMatch(Replace(Text, '*', '|'), '|*')

[MayilVahanan]

Hi

Try like this

If(Left(Text, 1) ='*', Text) as Text

Or

Load * from datasource where Left(Text, 1) ='*';