Text reformatting

Replace the delimiter | with a tab \t to split the data into separate columns.

Hi @Muhammad_Tukur_Ameen
Are you after splitting text strings into separate tabs? sed might be a good option. For example, s/|/\t/ will replace the first pipe character in every line.
Hope this helps.

1 Like

Yes, this is simpler than an awk-based solution and in Galaxy the tool

Replace Text in entire line”

would let you do this.

You need to use \| as the Find pattern because | has special meaning in regular expressions, i.e. needs to be escaped (forced to be treated literally) with the backslash.
and you’d set Replace with to \t meaning TAB.