Reform column

mateo.drouillard · May 12, 2022, 1:59pm

Hello everyone,

I would like to reform a column by keeping the characters before the first “’-”. If the line does not include “-” I do not change anything.

Can you help me ?

Look at the example

Thank !

jack.chan · May 12, 2022, 2:02pm

assign
CurrentRow("INPUT") = CurrentRow("INPUT").ToString.Split("-"c)(0)
in foreach row loop

input

output

mateo.drouillard · May 12, 2022, 2:15pm

Thank so much !

system · May 15, 2022, 2:16pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.