Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to find words like is, and, for, in a dimension and delete these words to create a cleaner dimension. Any suggestions?
Can you provide few values or string?
I find myself wanting to use mapsubstring() to convert common words to blanks, but it's not iterative. So instead I used subfield() to break the text into words, skipped the words we don't care about when loading that table, then concatenated them back together again. Seems to work, but would be more complicated with punctuation and capitalization.