Can I convert a table in a text file to Excel using RM?

kimjk3559

For example,

   name              age               job                                          

--------------- ---------------- --------------- 
   aaaa               bbbb             ccc        

   des1               des2             des3        

--------------- ---------------- --------------- 

      1                    2                3

                                      

   dddd               eeee             fff        

   des1               des2             des3        

--------------- ---------------- --------------- 

      4                    5                6

There is a text file with many tables of this type, and these to..



   name              age               job            des1               des2             des3
   aaaa               bbbb             ccc              1                    2                3
   dddd               eeee             fff               4                    5                6 

I want to convert it to an Excel file of this type.

I tried filter with regular expression but I can't get the idea out.

Any help or even a little hint is appreciated.

Tks

BalazsBaranyRM

Hi!

Your tables are formatted for viewing, not processing. But you can still import them.

I would try Read CSV with a weird separator character that is not in the tables, like § or *. This gives you the entire rows in one column.
Then apply Trim to remove spaces in the beginning and the end of the rows. Then Split with a regular expression like "[\t ]+", this will split up the column on the variable number of spaces (or tabulators if they are in the data) . If the Name or some other attribute have (single) spaces in the contents, try a regular expression with a quantifier:  {2,}|\t

Then you can rename the columns as you need. 

When you're done, you can use Write Excel to export the results.

Regards,
Balázs