Search found 5 matches

by simicar
Thu Jun 12, 2008 8:01 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: XML to XLS - how to.
Replies: 1
Views: 3947

XML to XLS - how to.

Hi.

I've got two questions. I'm dealing with converting dosen of XML files
to one XLS performing a "Find pattern (perl)" function with simple code

<TAG dsK="sth" nrW="sth">(.*)</TAG>

replace to

$1;\r\n [x] extract matches (which covers only one column of data)

All I need is to get an Excel ...
by simicar
Fri Mar 02, 2007 9:42 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: CSV-like data merging
Replies: 5
Views: 11936

How about duplicates

Thanks. It really works - but only when key word appears once per file. The problem appears, when there are two or more of them.

Ex. from - (extracting word tool ):

TextPipe provides a single...
...one tool, rather than
command line options, debugging schemes,

TextPipe provides a single ...
by simicar
Fri Mar 02, 2007 12:53 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: CSV-like data merging
Replies: 5
Views: 11936

Not quite..

Unfortunately when I've used the suggested:
File input:..
Extract matching [*tool*] - ( here extraction of the 1 line before and after )
Replace ; with ,
Insert column 1 [;@inputFilename;]
Insert column 0 [;]
EasyPattern [... as given above ...]
Merge to file...
on the trial input:

TextPipe ...
by simicar
Wed Feb 28, 2007 7:39 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: CSV-like data merging
Replies: 5
Views: 11936

CSV-like data merging

Hi.

I encountered problems by using "extract matching lines" with context lines (1 line - before and after) selected, because I get this:
;Trial Input;noxious gases away from the users of the machine. ;
;Trial Input;Indoor generators and furnaces can quickly fill an enclosed s;
;Trial Input;pace ...
by simicar
Thu Feb 15, 2007 7:38 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Extracting regex from multiple pdfs and lines that surrounds
Replies: 1
Views: 6533

Extracting regex from multiple pdfs and lines that surrounds

Hello.

I've got a certain problem. I need to find a specific data using the regular expression and save everything that surround it,
from multiple pdfs to one file:

For exalmple I've got:

The California Gold Rush started in January 1848, when gold was
discovered at Sutter's Mill. As news of the ...