Hello gurus. I've never used PERL before, but I know it can help me doing this so I'm asking a very simple question.
There's a folder which contains many *.txt files.
Each file contains several tables inside. Each table has its header. Headers are same in all files but number of rows different.
Headers are separated from previous table with empty string symbol. There's no empty string between a header and a table below it.
1. I need to split each of these text files into multiple text files using empty strings in each file as delimiters and naming each file as the header is.
2. I need to combine several output text files into one table
For example:
SOURCE_FILE.txt:
HEADER_1
X Y Z
1 2 3
HEADER_2
X Y Z
4 5 6
AFTER STEP 1:
HEADER_1.txt
X Y Z
1 2 3
HEADER_2.txt
X Y Z
4 5 6
AFTER STEP 2:
OUTPUT.txt
X Y Z X Y Z
1 2 3 4 5 6
Thanks and regards!
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.