Split character column based on regular expression or delimiter

[KristinaGomoryova]

It would be nice to have a tool allowing to split a character column into (multiple) new columns based on a separator or regex.

An example would be I have dataframe like this:

var	value
Ubi4_1	26.17
Ubi4_2	26.30
Ubi4_3	22.88

I would like to split var column by "_" into condition and replicate columns, so the final result would be:

cond	rep 	value
Ubi4	1	26.17
Ubi4	2	26.30
Ubi4	3	22.88

In R, this can be achieved using e.g. the separate function from tidyr package or its modifications.

Thanks for considering!

[KristinaGomoryova]

@hechth

[bernt-matthias]

https://usegalaxy.eu/root?tool_id=toolshed.g2.bx.psu.edu/repos/galaxyp/regex_find_replace/regexColumn1/1.0.3

Something like the following should work:

• use column 1
• regex would be (.+)_(.+)
• replacement \1\t\2

For the header column you need a second rule:

• regex: cond
• replacement cond\trep

Feel free to reopen if you have further questions

Maybe https://help.galaxyproject.org/ is also a good place for questions of this kind.