Reform column

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

image

Thank !

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

image

input
image

output
image

Thank so much !

1 Like

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