Splitting Data on same line

[CalumS]

I'm doing a school project in school and my teacher does not even know how do to this.

I have data like the following:
Watwick,5
Welcombe Mouth,5
Wells - next - the - Sea,1
Wembury,1
Wemyss Bay,5
West Angle Bay,1
West-Bay,1
West Kirby,1
West Mersea,1
West Runton,5
West Sandwick Beach,1
West Voe Sands,1
West Wittering,1

I need anything before the first comma to go into an array/record structure called 'Name' than anything after the comma to go into an array/record structure into Rating

She has only taught us how to do for data like:

1
2
4
6
3

Now data that has to be split on the same line, any help would be great!

[Klaus]

Hi Calum,

welcome to the forum!

Déjà vue?
viewtopic.php?f=7&t=32138

Best

Klaus

P.S.
A little "Hello" or something will not hurt in a first posting!

[bogs]

In the dictionary, look up 'itemDelimiter'.

In LIvecode, you can set this to almost anything, but in your example, you'd likely want to set it to 'comma'.

I need anything before the first comma to go into an array/record structure called 'Name' than anything after the comma to go into an array/record structure into Rating

In this case, after setting the itemDelimiter, you can choose the parts of the record by 'Item', so the first item would be anything before the first comma.

Hope that helps you out some.

[CalumS]

Sorry, just in a rush to figure this out.
I figured out that the code was designed for having one set of data on each line.

Any idea how I could do it with the data I have?

Hello btw

[CalumS]

@bogs

Thanks!
So something like

set the itemdelimiter to comma

Where would I put this in my code?

[Klaus]

Any idea how I could do it with the data I have?

If I understand the task correctly, you need something like this:

Code: Select all

...
## The default item delimiter = COMMA, so need to set it here!
## tData is the list with the "city,number" pairs
repeat with i = 1 to the num of lines of tData
  put item 1 of line i of tData into tNameArray[i]
  put item 2 of line i of tData into tRatingArray[i]
end repeat
...

Et voila, two arrays with the appropriate content (hopefully).

Hello btw

Too late, mate, I wrote "... in a first posting".

Best

Klaus

[CalumS]

That is correct, something like that would be ideal

[bogs]

Somewhere before you start manipulating the data in the handler your using (sorry I can't be a lot more detailed, almost all of this really depends on personal preference).

Psuedo-code would look something like -

Code: Select all

/* assuming for a moment your using a button to put the data into  a variable or field
    you might use the 'on mouseUp' handler... */
on mouseUp
	set the itemDelimiter to comma
	repeat for each line x in {theData_Container}
		put item 1 of x into {yourArray, yourKey}
	end repeat
	// any other operations you need done...
end mouseUp

The above isn't tested nor even very specific, and there are LOTS of other ways to handle something like this, but it should give you a start.

Heh, I see Klaus beat me to it with a much more specific answer

[Klaus]

That is correct, something like that would be ideal

Well, then just take it, it's free!

[FourthWorld]

Why does the structure need to be an array, specifically?

[CalumS]

Any idea how I could do it with the data I have?

If I understand the task correctly, you need something like this:

Code: Select all

...
## The default item delimiter = COMMA, so need to set it here!
## tData is the list with the "city,number" pairs
repeat with i = 1 to the num of lines of tData
  put item 1 of line i of tData into tNameArray[i]
  put item 2 of line i of tData into tRatingArray[i]
end repeat
...

Et voila, two arrays with the appropriate content (hopefully).

Hello btw

Too late, mate, I wrote "... in a first posting".

Best

Klaus

Thanks so much the code worked, Now I just need a litte bit of help with posting to output.

repeat with i = 1 to number of lines in tNameArray
Put tRatingArray into line i of field "output"
end repeat

That is the code I am using, do you see anything wrong with it?

[CalumS]

Actually, I got it working.
Everyone thank you so much for the help!