Trailing spaces in a cell
- 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
I'm working with a really small toy example.
The dataset has 3 rows. However, when I just run this dataset, I get a red mark in one of the column's cells that says - "This cell has trailing spaces". Although I don't see where the trailing spaces are.
Can anyone provide a brief reason for me seeing this warning?
Here's my workflow attached -
Solved! Go to Solution.
- Labels:
- Data Investigation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @prateer
Your "Smith Lane" value has an extra space after it. If you look at the data in your Text Input you can actually scroll right one space after the quote. Also, why are your names in quotes? Is this the way they are in your input?
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In your screen shot, click the cell for Name in record 3, then click the button for Cell Viewer. You'll see a "dot" or "bullet point" where spaces exist.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is part of an exercise in a course I'm currently taking, that's why the quotes were present.
