How to extract from Vertical Text data to horizontal data

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

How to extract from Vertical Text data to horizontal data

Postby 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

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Tue Jun 29, 2004 9:25 am

Is the number of phone number digits constant?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

mfauzim

Postby mfauzim » Tue Jun 29, 2004 5:26 pm

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

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Tue Jun 29, 2004 5:58 pm

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

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

mfauzim

How to combine all the column data into single line

Postby 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

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby 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
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

mfauzim

WHat is (\d) and $

Postby 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

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

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

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 4 guests