How to extract from Vertical Text data to horizontal data

[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

[DataMystic Support]

Is the number of phone number digits constant?

[mfauzim]

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

[DataMystic Support]

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

[mfauzim]

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

[DataMystic Support]

Find

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

Replace with

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

[mfauzim]

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

tia

[DataMystic Support]

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