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!
Solved! Go to Solution.
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.