Steven Hillion Posted October 9, 2019 Share Posted October 9, 2019 Question submitted on behalf of a customer... Let say I have Excel with a description column. And description column contains new line, its giving me error that columns are not consistent. You can have a look over the following attached .csv file for reference. I've reproduced this problem with a simple Excel file that looks like this... Text ID Some text 1 Some text with a newline 2 How do we work with columns that contain newlines And how do we work with Excel files Link to comment Share on other sites More sharing options...
Nico Rode Posted October 9, 2019 Share Posted October 9, 2019 Hey There! Great question, we have an Import Excel operator that is able to correctly handle excel files with carridge returns/ new lines. You can take a look at this video for more information on how to actually achieve this in Team Studio. Hope this helps! Nico Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now