split 1 column into 2 based on first appearance of character

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

edekker
Posts: 2
Joined: Fri Dec 06, 2013 6:06 am

split 1 column into 2 based on first appearance of character

Postby edekker » Fri Dec 06, 2013 6:20 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: split 1 column into 2 based on first appearance of chara

Postby DataMystic Support » Thu Dec 12, 2013 12:21 pm

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'
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 5 guests