Import spreadsheet getting changed

[pache76]

My student has been importing a spreadsheet into snap with data for her create task (its lists within lists). However when she uses (list) contains (string) to find items in each list, it reports as false. When we check the items in the list in snap (list view) we find that a space has been added to some of the items (but not all) when the spreadsheet was imported. (ex searching "eggs" came up false due to the item in the list being "eggs*"

We went back and triple checked the google sheet to see that the cell items didnt have a space at the end.

We are at a loss, does anyone have any ideas about what might be going on?

Thanks

[ego-lay_atman-bay]

Can you send us the csv file?

[coder_07]

worst case scenario you can do something like this

[wowwies]

I created a custom block which deletes unnecessary spaces in text.

It should help with your unnecessary spaces.

[sathvikrias]