Hi, can anyone explain how to use custom transform for the substitute function? I have a column variable “TREAT” and I want to substitute the element in the TREAT columns e.g. swap “D” with “D4”. the instructions suggest the syntax is: substitute(text, target text, replacement text) but I don’t know what text, target text and replacement text entail. thanks elliot
I would use a filter within the Data Wizard and then use the “replace” option. You would look for D and replace with D4. Then select only the “TREAT” column. That should replace all the D’s with D4. Hope that helps. Nathan Teuscher
Elliot, I would second Nathan’s suggestion; did it work OK for you? I have noted that the Column Transformation function Replace is not very clear and a request to enhance this is noted as QC_PHX14031. If you want to use Column transformation formula because the the text differs a little then I have used SEARCH and MID functions in the past. Simon
it did..perfectly. thanks again. I’m glad to know that I wasn’t the only one having difficulty with the custom transform function.