Trailing spaces in a cell

[prateer]

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 - 

[Kirti1]

Hey

You can remove the trailing spaces using Data cleansing tool. Please find attached solution.

[danilang]

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   

[ChrisTX · Accepted solution]

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.

[danilang]

Hi @prateer 

@ChrisTX explained it much better than I did, but you need to press the Show Whitespace button to show the dots.

Dan

[prateer]

This is part of an exercise in a course I'm currently taking, that's why the quotes were present.