split 1 column into 2 based on first appearance of character

[edekker]

Suppose you have this layout

5 figures<tab>word word word, word, word, word,word<tab>word<tab>

Now I want to split the second column into 2 columns. The seperator is left most comma in the second column.

So far I would do this in Excel (to get the columns right) and Word (to split 1 selected column, but textpipe should be able to do this too.

in plain text:
Look for the first <tab>
then replace the first comma with a <tab>

I don't know how to do this in textpipe

[DataMystic Support]

Use a restrict to Tab-delimited field filter.
Set it to restrict to field 2 only.
Inside this, add a search/replace of comma with Tab (\t), and check 'First Match Only'