Currently I'm using data cleansing tool to remove the punctuations from a field. however the requirement is to remove everything except for hyphen – and the ampersand & symbols. How can I accomplish this? Thanks in advance for your help!
¡Resuelto! Ir a solución.
The issue with this one is that it also truncating the valid spaces in between
Hello.
DO you know what this formula is doing? IIF(isNull([Row-1:1]),1,[Row-1:New Column]+1)
It looks like the formula you are referencing is in a Multi-Row formula tool.
Translation:
If column "1" is null in the row above the current row, then the value of 1 is returned. Otherwise, "New Column" plus 1 from the row above the current row is returned.
Sounds like the new column is creating a RecordID. Is it working for you? Looks odd to me.
If you need help with this formula, I recommend opening a new topic.