How to extract from Vertical Text data to horizontal data

mfauzi · Post by **mfauzi** » Mon Jun 28, 2004 2:04 pm

Dear all, I have a input text file in which I need to extract specific telephone number shown in vertical format and output it into horizontal format. Example

input file:

bcd alsdj 0 testing only
sldkjds 3 sd;lfkd'sl
sdlewie 6dsfl';dlsf
kdsjfldfds 7 lsdkpoe dlk

o367 will repeat with some other number. Eg 9834

expected output file:

0367 ...
9834 ...

Appreciate any help on this matter. TIA

Post by **DataMystic Support** » Tue Jun 29, 2004 9:25 am

Is the number of phone number digits constant?

mfauzim · Post by **mfauzim** » Tue Jun 29, 2004 5:26 pm

Phone number isnot constant, but the column is constant.. Phone number is always 8 digit

Post by **DataMystic Support** » Tue Jun 29, 2004 5:58 pm

Why not remove columns 1-7, and then columns 2..end of line?

mfauzim · Post by **mfauzim** » Wed Jun 30, 2004 8:25 pm

Then which filter/steps od I need to use in order to combine all the phone # ( in column ) into horizontal output.
tia

Post by **DataMystic Support** » Wed Jun 30, 2004 9:11 pm

Find

(\d)
(\d)
(\d)
(\d)
(\d)
(\d)
(\d)
(\d)

Replace with

$1$2$3$4$5$6$7$8\r\n

mfauzim · Post by **mfauzim** » Thu Jul 01, 2004 6:25 pm

I'm sorry, but I am evaluating textpipe pro not sure what is (\d) and $. Maybe you can explain a little bit.

tia

Post by **DataMystic Support** » Fri Jul 02, 2004 6:18 pm

Just follow the instructions word-for-word. We'll be happy to explain when you purchase.

DataMystic

How to extract from Vertical Text data to horizontal data

How to extract from Vertical Text data to horizontal data

How to combine all the column data into single line

WHat is (\d) and $