LiveCode Forums.

Posted: **Tue Jul 02, 2013 6:00 am**

Not sure on the best syntax here but what I'd like is something like this:

split variable {by|with|using} primaryDelimiter and secondaryDelimiter as table

I'm using item for secondaryDelimiter and line for primaryDelimiter in my discussion for clarity...

What this would do is take the first line and use its items as keys in the second dimension of the array and for then each subsequent line would have an array index starting from 1. So the data:

Code: Select all

Greeting,Planet
Hello,Earth
Hello,Saturn

once split would be accessible as:

Code: Select all

theVariable[2]["Planet"] = "Saturn"

A possibly better alternative might be:

Code: Select all

split variable {by|with|using} primaryDelimiter and secondaryDelimiter as table [with keys keyList]

Here if no keyList is supplied then the multi-dimensional array would have a numbered array as the second dimension...

Anyone have any thoughts in this?

Posted: **Tue Jul 02, 2013 6:06 am**

Thinking on this some more and I definitely think the keysList way is the way to go because that would cover key ordering in combine.

Posted: **Tue Jul 02, 2013 9:19 am**

If split by row as table gives

Code: Select all

theVariable[2]["Planet"] = "Saturn"

then split by column as table can give

Code: Select all

theVariable["Planet"][2] = "Saturn"

which could facilitate using Jan's MapReduce.

Posted: **Tue Jul 02, 2013 10:32 am**

Perhaps I missed something in the map reduce discussion? I'm not really sure how it's related.

LiveCode Forums.

split/combine as table

split/combine as table

Re: split/combine as table

Re: split/combine as table

Re: split/combine as table