Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter doesn't register same values as 1 after column split

I have a file with a Name column delimiited by a comma:   Abby Brandon, Abby Charles Charles, Brandon   After I column split them into different rows based on comma delimiter, I get this:   ...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    Anonymous 

    Try applying trim function, also share sample data to check from my end,

    Thanks,
    NG

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Sorry there are no spaces between the values. I just added it with space for clarity sake.
There is linebreak between them. Would that affect the value?
I've checked the values themselves and there are no space and linebreaks before them.

NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago

Anonymous 

Try applying trim function, also share sample data to check from my end,

Thanks,
NG