How do I resolve embedded lines and truncated characters issues?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Many thanks @AngelosPachis