Split text string by underscore in Data Wizard - Transformation?

Phoenix Certara Forums Phoenix WNL basics
1

Have a column, Sample_Name, and want to split each name by the underscore, e.g. 12_brain, resulting in two columns - Subject = 12 and Matrix = brain. I’ve tried search in custom functions with DW and Transformation (i.e. search(“_”,Sample_Name,1), but it always returns -1. I would be okay even just taking the numbers to the left of the underscore, and ditching the rest. Any advice on this? Thanks,

2

Dear User,

There are several ways to accomplish this. See attached phoenix project. I can accomplish this with a data wizard with 4 steps. Do not forget to map your variables if the names are not the same.

Hope this helps,

Ana Henry

DW.phxproj (164 KB)

3

Thanks Ana, this helps. I also had the syntax wrong. Best, Burgess