Hopefully an easy one:
I've come across a problem where column values are seemingly duplicated, I can't visibly see it in the cell, and have checked the source data (Excel), can't find it there either. However the images below should show the issue:
Topbar (shows duplicate separated by a tab or pipe break?):
Filter (shows duplicate, no visible separator):
Replace (not visibly duplicated?!):
Any ideas how to resolve? Thanks in advance
Hi @alistairhay,
Could you clarify how the input is being loaded? Is it imported from Excel directly or as CSV?
Would you be able to share a screenshot of the action configuration?
If possible, you may also send the data to support@easymorph.com, so we can try to reproduce the issue.
thanks, I've emailed
Ah, I see why it might look like a duplicate, but it actually isn't. This happens because the column has a format applied (as seen at the top), so the unformatted values appear on the left, while their formatted representation appears on the right. I agree that this is not presented clearly, and we will look into ways to improve it. Thank you for bringing this to our attention.
As a small tip - you can inspect individual values by right-clicking on a cell and selecting the Profiler option. It will display both the value and its length.
thank you, I've seen this applied to dates before and is really handy, but not to strings. thanks again!
