How do I resolve embedded lines and truncated characters issues?

[SylviaK]

Hi, 

I used the Input tool to upload the attached data. However, I get an error message saying embedded lines and truncated characters. How do I resolve that? I want to see all words, so I can in a next step do a key word search. 

Many thanks, 

Sylvia

[messi007]

@SylviaK,

It's not an error message it's just saying that's truncated cell because you display more then 256 characters,the display cell:

However if you use a browse tool you will be able the see the full data

You can use search to search for key words.

Hope this helps,

Regards

[AngelosPachis · Accepted solution]

Hi @SylviaK,

I didn't receive an error message preventing the workflow to run, but indeed you get a message that there are embedded newlines and truncated characters.

What you can do is use a Text to columns tool to split to new rows every time a new line appears (\n stands for new line)

Then you can add a data cleansing tool to remove leading/trailing whitespaces, and your data will be in a cleaner format to do the key word search.

Hope that helps,

Angelos

[SylviaK]

Many thanks @AngelosPachis