Some trickey but useful transformation rules

1. How to validate a Email Address

If
AlNum(
Left(inputcolumn,index(inputcolumn, '@', 1) -1 ):Right(inputcolumn,
index(inputcolumn, '@', 1) - 1)
)
Then "Valid" else "Not"

2. How to replace field separator if a string contain any?

Ereplace(EC_File_Nm.$CommandOutput, @FM,'')

it will replace any field separator if any from the command out put of execute command stage.
Lets say the command output is a file name and it contain any filed separator inside it it will be replaced by null.

3. How to get