2 replies to this topic

[burgess.freeman@stjude.org]

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,

[Ana Henry]

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

Attached Files

•  DW.phxproj   163.55KB   382 downloads

Edited by Ana Henry, 09 February 2018 - 06:19 PM.

[burgess.freeman@stjude.org]

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