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.
Igor
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.
2 Likes