extracting table from text files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

rickmac

extracting table from text files

Postby rickmac » Wed Jun 15, 2005 12:07 am

I have tables embedded in pure text files. I am trying to extract these tables of data and generate structured tables. the test files i am using do not embed tags or special delimiters, just uneven space.

text file example:
---------------------------------------------------------
X is the x axis defined as ............
Y is the iiiii
the area XY is the integral of ......
several points on line are as follows
X Y Z
------ ----- ------
a 1.2 3 2
b 3 2.2 11
c 4 1.2 2.1

a and b represent the base
however c may represent ..........
---------------------------------------------------------

how would i be able just to extract

X Y Z
------ ----- ------
a 1.2 3 2
b 3 2.2 11
c 4 1.2 2.1


from the text file?


any suggestions?

Thanks

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

Postby DataMystic Support » Mon Aug 22, 2005 12:53 pm

Easy, just use EasyPatterns:

Search for:

[ capture( 1+ not space ), ' ',
capture( 1+ not space ), ' ',
capture( 1+ not space ), ' ',
....etc...
]

Replace with:

$1,$2,$3,$3
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 2 guests