Load if contain... as

[shahafei2]

Hi all,

Im trying to rename a value IF it contains 'ABC'

for the example i have the following values 

1-ABC-2

2-ABC-3

ABC-4

5-ABC

bbbb

cccc7

 456456etda

And i would like that the marked values will be changed to '1' so instead i will receive

1

1

1

1

bbbb

cccc7

 456456etda

Im trying to use

Load 

If(Desc='*ABC*',1,Desc) AS Desc

FORM ....

but for some reason i cant find '1' under the list box of Desc field

[Anil_Babu_Samineni · Accepted solution]

Try this
If(wildmatch(Desc, '*ABC*'),1,Desc) AS Desc
Or
If(index(Desc, 'ABC'),1,Desc) AS Desc
Or
If(substring(Desc, 'ABC'),1,Desc) AS Desc

[shahafei2]

Thank you,

The index function worked great for me