How to count the length of a string and add @gmail.com based on the filter condition

[prabuj]

Hi Team, @nthampi @TRF

SOURCE: Column " NAME" ____> TARGET: COLUMN "EMAIL "

If the length of the name is less than 7 , then add NAME@gmail.com

If the length of the name is greater than 7 or equal to 7 , then add NAME@msn.com

Expected results:

NAME EMAIL

PRA PRA@gmail.com

DDKFJKD

DDKFJKD@msn.com

How to do it ? Please help ASAP

Thanks in advance.

[Anonymous · Accepted solution]

Hello,

You can the below expression:

column_name.length()<7 ? column_name+"@gmail.com": column_name+"@msn.com"