Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to force some value in a field to change into something else. This is what i am writing in my script,
if(DataAreaId='tgbr' or DataAreaId ='TGNL','tgnl') as DataAreaId
I want to make the value "tgbr" and "TGNL" to "tgnl". What i am doing wrong in my script?
Thanks,
Shan
if(match(lower(DataAreaId), 'tgbr', 'tgnl'), 'tgnl', DataAreaId) as DataAreaId
I guess you want this:
if(DataAreaId='tgbr' or DataAreaId ='TGNL','tgnl', DataAreaId) as DataAreaId
Hi Michael,
Thanks for your reply. TGNL changed to tgnl but tgbr didnt changed to tgnl.
Thanks,
Shan
if(match(lower(DataAreaId), 'tgbr', 'tgnl'), 'tgnl', DataAreaId) as DataAreaId
Try this:
if(wildmatch(DataAreaId,'*tgbr*','*TGNL*'), 'tgnl', DataAreaId) as DataAreaId
Massimo,
I got it fixed. Thank you so much.
Shan
Massimo,
Oops! Sorry, in the textbox its showing the tgbr is gone. But while i looked at the table i see the tgbr is replaced by ' - ' hyphen.
Thanks,
Shan
Have you tried the "wildmatch" expression? If it doesn't help, there is something in the data we can't guess, and need an example of your file...
Michael,
I am really sorry not to mention it before. I tried with the wildmatch but it didnt work either.
I dont know if anything wrong with the data. I have to check again and i will get back again later.
Thanks for all your replies.
Thanks,
Shan