AnsweredAssumed Answered

Read CSV cell with multiple lines

Question asked by robin.zhang344808 on Sep 29, 2018
Latest reply on Oct 4, 2018 by ben_miller246102



I try to load CSV files into boomi. But some cell contain multiple lines. As a result, Boomi does not recognize it and read as multiple rows which will mess up rest of the data. 

For example, in highlighted cell Suite 10 and 80 Water Street are in multiple lines and within one cell. Boomi will read it as two sepearte rows. I wonder if there is a way to deal with it.