# Custom Transform Substitute question

**URL:** <https://forum.certara.com/t/custom-transform-substitute-question/2721>\
**Category:** Phoenix WNL basics\
**Created:** [April 11, 2014, 6:30pm UTC](https://forum.certara.com/t/custom-transform-substitute-question/2721 "2014-04-11T18:30:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![elliot](https://avatars.discourse-cdn.com/v4/letter/e/858c86/32.png) [@elliot](https://forum.certara.com/u/elliot)\
**Post date:** [April 11, 2014, 6:30pm UTC](https://forum.certara.com/t/custom-transform-substitute-question/2721/1 "2014-04-11T18:30:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![chenminalk](https://avatars.discourse-cdn.com/v4/letter/c/82dd89/32.png) [@chenminalk](https://forum.certara.com/u/chenminalk)\
**Post date:** [April 11, 2014, 8:16pm UTC](https://forum.certara.com/t/custom-transform-substitute-question/2721/2 "2014-04-11T20:16:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![SimonDavis](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SimonDavis](https://forum.certara.com/u/SimonDavis)\
**Post date:** [April 17, 2014, 1:29pm UTC](https://forum.certara.com/t/custom-transform-substitute-question/2721/3 "2014-04-17T13:29:32Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![elliot](https://avatars.discourse-cdn.com/v4/letter/e/858c86/32.png) [@elliot](https://forum.certara.com/u/elliot)\
**Post date:** [April 17, 2014, 2:34pm UTC](https://forum.certara.com/t/custom-transform-substitute-question/2721/4 "2014-04-17T14:34:41Z")

</div>

it did..perfectly. thanks again. I’m glad to know that I wasn’t the only one having difficulty with the custom transform function.
