handling case sensitive characters

[former_member232455]

Hi All,

i need to handle some case sensitive letters in mapping,requirement like below

source fields target

name name

value

when name field starts with or contains Janardhan then value filed should pass to the target field.but some times the name fileld value may receive like JANARDHAN(all in caps) or in different formats.the name is same which will come from sender but there is no case sensitive. i need to pass this name if it come any format(like caps,small letters or few caps or few small letters).

could you please provide if there is any UDF to handle this?

Regards,

Janardhan

[manoj_khavatkopp · Accepted solution]

Janardhan,

Use toUpperCase and toLowercase functions .

Br,
Manoj

[former_member232455]

Thank you Manoj,it's working..

Regards,

Janardhan