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.