How to extract from Vertical Text data to horizontal data

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
mfauzi
Posts: 1
Joined: Mon Jun 28, 2004 1:57 pm

How to extract from Vertical Text data to horizontal data

Post 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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Is the number of phone number digits constant?
Regards,

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
mfauzim

Post by mfauzim »

Phone number isnot constant, but the column is constant.. Phone number is always 8 digit
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

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

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
mfauzim

How to combine all the column data into single line

Post by mfauzim »

Then which filter/steps od I need to use in order to combine all the phone # ( in column ) into horizontal output.
tia
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Find

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

Replace with

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

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
mfauzim

WHat is (\d) and $

Post 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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

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

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
Post Reply