Search found 2 matches

by edekker
Fri Dec 06, 2013 6:35 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: split full name into first and last name
Replies: 1
Views: 4416

split full name into first and last name

With a full name consisting of 2 words, it is not very difficult to split a name in first and last name. It get difficult with three or more words, because you need to understand the words. if there is a hyphen (Mary-Ellen, Johnson-Leboeff), the 2 connected words should be considered one. if there i...
by edekker
Fri Dec 06, 2013 6:20 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: split 1 column into 2 based on first appearance of character
Replies: 1
Views: 5936

split 1 column into 2 based on first appearance of character

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,...