How to handle data from a column is coming to another column ( mismatch arrangement ) ?

[prabuj]

Dear Team, @Shicong Hong @Fred Trebuchet @Xiaodi Shi,

The data in column B is coming to column C by mistake. What would be the issue ? The input file is csv.

Is it due to delimiter the data is skipped (or) row generator .. what would be the problem. I check the delimiter in data, it's not there.

Source Target

column b ----> column B

column c -----> column B ( Wrong )

Thanks in advance.

[Anonymous]

Possible cause is the data itself contains delimiter, for example,

A;B;C

valueA;valueB start; value B ends; valueC

valueB start; value B ends is the value of column B, it contains the delimiter.