Page 1 of 1
How to extract from Vertical Text data to horizontal data
Posted: Mon Jun 28, 2004 2:04 pm
by mfauzi
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
Posted: Tue Jun 29, 2004 9:25 am
by DataMystic Support
Is the number of phone number digits constant?
Posted: Tue Jun 29, 2004 5:26 pm
by mfauzim
Phone number isnot constant, but the column is constant.. Phone number is always 8 digit
Posted: Tue Jun 29, 2004 5:58 pm
by DataMystic Support
Why not remove columns 1-7, and then columns 2..end of line?
How to combine all the column data into single line
Posted: Wed Jun 30, 2004 8:25 pm
by mfauzim
Then which filter/steps od I need to use in order to combine all the phone # ( in column ) into horizontal output.
tia
Posted: Wed Jun 30, 2004 9:11 pm
by DataMystic Support
Find
(\d)
(\d)
(\d)
(\d)
(\d)
(\d)
(\d)
(\d)
Replace with
$1$2$3$4$5$6$7$8\r\n
WHat is (\d) and $
Posted: Thu Jul 01, 2004 6:25 pm
by mfauzim
I'm sorry, but I am evaluating textpipe pro not sure what is (\d) and $. Maybe you can explain a little bit.
tia
Posted: Fri Jul 02, 2004 6:18 pm
by DataMystic Support
Just follow the instructions word-for-word. We'll be happy to explain when you purchase.