Trailing spaces in a cell

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 -

ExtraCharacters.yxmd

Workflow

Data Investigation

Accepted answers

ChrisTX

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.

All comments

Kirti1

Hey

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

ExtraCharacters.yxmd

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703