How do does one create this output from excel/numbers?

General (non-technical) Off-Topic
#1

Hi,
I need to write a lot of tables with the following format:

{  
plaatje="a.png",  
goed="a",  
fout={"b","c","d"}  
},

Typing the fields in something like excel would be much easier. Is there a way to have excel or numbers output a text file in this format?

[import]uid: 100901 topic_id: 35909 reply_id: 335909[/import]

#2

Put your plaatje values in column A, goed in column B, and the fout values in C, D & E.

In column F, put this formula:

[lua]
="{plaatje=’"&A2&"’,goed=’"&B2&"’,fout={’"&C2&"’,’"&D2&"’,’"&E2&"’}},"

[/lua]

Once you’ve finalised all your data, copy and paste AS VALUES the results in column F to column G, and then find and replace all the single quotes with double quotes. Finally paste column G into your Lua file.

It won’t set them out neatly but it gets the job done! [import]uid: 93133 topic_id: 35909 reply_id: 142725[/import]

#3

Thanks! will try. I don’t think I need neatly. Lua Glider can autoformat code for me. [import]uid: 100901 topic_id: 35909 reply_id: 142729[/import]

#4

Put your plaatje values in column A, goed in column B, and the fout values in C, D & E.

In column F, put this formula:

[lua]
="{plaatje=’"&A2&"’,goed=’"&B2&"’,fout={’"&C2&"’,’"&D2&"’,’"&E2&"’}},"

[/lua]

Once you’ve finalised all your data, copy and paste AS VALUES the results in column F to column G, and then find and replace all the single quotes with double quotes. Finally paste column G into your Lua file.

It won’t set them out neatly but it gets the job done! [import]uid: 93133 topic_id: 35909 reply_id: 142725[/import]

#5

Thanks! will try. I don’t think I need neatly. Lua Glider can autoformat code for me. [import]uid: 100901 topic_id: 35909 reply_id: 142729[/import]

#6

Put your plaatje values in column A, goed in column B, and the fout values in C, D & E.

In column F, put this formula:

[lua]
="{plaatje=’"&A2&"’,goed=’"&B2&"’,fout={’"&C2&"’,’"&D2&"’,’"&E2&"’}},"

[/lua]

Once you’ve finalised all your data, copy and paste AS VALUES the results in column F to column G, and then find and replace all the single quotes with double quotes. Finally paste column G into your Lua file.

It won’t set them out neatly but it gets the job done! [import]uid: 93133 topic_id: 35909 reply_id: 142725[/import]

#7

Thanks! will try. I don’t think I need neatly. Lua Glider can autoformat code for me. [import]uid: 100901 topic_id: 35909 reply_id: 142729[/import]

#8

Put your plaatje values in column A, goed in column B, and the fout values in C, D & E.

In column F, put this formula:

[lua]
="{plaatje=’"&A2&"’,goed=’"&B2&"’,fout={’"&C2&"’,’"&D2&"’,’"&E2&"’}},"

[/lua]

Once you’ve finalised all your data, copy and paste AS VALUES the results in column F to column G, and then find and replace all the single quotes with double quotes. Finally paste column G into your Lua file.

It won’t set them out neatly but it gets the job done! [import]uid: 93133 topic_id: 35909 reply_id: 142725[/import]

#9

Thanks! will try. I don’t think I need neatly. Lua Glider can autoformat code for me. [import]uid: 100901 topic_id: 35909 reply_id: 142729[/import]