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

kimjk

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

BalazsBarany

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

kimjk

谢谢!我使用了30多个运营商,but it worked anyway.