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 ...
Search found 5 matches
- 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
- 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 ...
Ex. from - (extracting word tool ):
TextPipe provides a single...
...one tool, rather than
command line options, debugging schemes,
TextPipe provides a single ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
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 ...