Smartstaff
1,385
edits
Changes
→Syntax
where the separator used is a pipe delimiter
'' '''Case 1Case 4''': 4=,1''
'' ''If Column 1="123456" then Column 4 = "123456"
where there is no separator used
'' '''Case 5''': 10=-,1,2;;11=-,3,4''
'' ''The file will have two new columns: Column 10 and Column 11.
'' ''If Column 1="222" and column 2="111" then Column 10 = "222-111" AND
If Column 3="Value3" and column 4="Value4" then Column 11 = "Value3-Value4"
==Constant==