Importing data using keywords

[petekat03]

I'm trying to import data from a text file that contains no delimiters into Excel. The text file contains a number of reoccurring keywords with their own values.

- Text file example;
keyword1 101
{
keyword2 1343
keyword3 false
keyword4 2983
}

keyword1 102
{
keyword2
keyword3 true
keyword4 234995
keyword5 3456
}


- Import into Excel to look as follows; (*ignore the full stop characters)

keyword1...keyword2...keyword3...keyword4...keyword5
101...........1343.........false..........2983
102..........................true...........234995......3456


Any help would be very much appreciated,

Pete

[Alf]

I would suggest you upload one of your text files.

Alf