iif condition help

[ushakishore]

I want to perform a comparison
i want to validate email address,
so if the column email has adfa@23 then it should return 'False' if it is like adf@adf.com like a regular url
then it should return 'true'

In sql u can compare like [ where email like '%@%.com') how do you right that in informatica express trans using iif
i was trying
iif(email='%@%.com','y','n')
plz tell the correct one. If any one knows wat i mean

 

[PHV]

IIf( Like '*@*.com', 'y', 'n')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

It is validating only ".com" extensions. What if they enter something else like .net, .co.in, .tv, .jp etc..

see it here

http://www.developerfusion.co.uk/show/3350/

Not opposing anyone but to show an example


________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ushakishore]

it didnt help . When i pasted it
IIf( Like '*@*.com', 'y', 'n') its giving parsing errors