trying to determine if a field caontains a certain string value

[#1]

There is a field called 'Price'that contains values such as FOB/collect, FOB/prepaid, COD/prepaid, DEST/prepaid & collect, amongst others

I am needing set a flag if any of the values contain a certain string, such as 'prepaid'.  Currently I have tried match and mixmax in my load script to load a new field as either 0 or 1, depending if there is a match

MixMatch('prepaid',[Price]) as .Prepaid

[sunny_talwar · Accepted solution]

Try this may be:

If(WildMatch(Price, '*Prepaid*'), 1, 0) as PrepaidFlag

[#3]

I also just figured out my issue, which is similar to yours

WildMatch([Price ],'*prepaid*') as Prepaid

I am getting a 1 in Prepad when true and 0 if False

Thanks for your 1uick response