help with parse of CRLF list

[David Boomer]

I have populated a variable (Var->ImportConsultants) with a CRLF list via a checkbox dialog.
I want to parse the list into an array...
below is a copy of my interactive screen:

?var->ImportConsultants
= CDN
EURO
PHILMT

Result = *for_each(Source,"SourceArray[" + *counter() + "] = " + quote(Source),var->ImportConsultants)

?Result
= SourceArray[1] = "CDN"
SourceArray[2] = "EURO"
SourceArray[3] = "PHILMT"

?SourceArray[1]
ERROR: Not found
SourceArray[] not found.

The 'Result' is not what I want... I am trying to populate the SourceArray[] variable... not create a new CRLF variable.
How can I do this?

[Finian Lennon]

Re: help with parse of CRLF list

Why not

importConsultants = remove_blank_lines(ImportConsultants)
dim sourceArray[0] as c
SourceArray.initialize(ImportConsultants)

F.

[SNusa]

Re: help with parse of CRLF list

Here's a similar 3 liner that when modified might help:
(Loads the array directly from a table. Very cool and powerful.)

dim shared vp_ProgArray[0] as P 'pre-read program data into array for quick checking against/during points import below.....
vp_ProgArray.CLEAR() 'resets the array to empy
vp_ProgArray.initialize_from_table("rewards_tbl","ProgramID = '" + vc_ProgramID + "' .AND. MerchantID = '" + vc_MerchantID + "'","Ryear")
'Note:  First parm is table name, send parm is query filter.

And since arrays tend to hold different quantities of values which you might need to find without exactly knowing where they are, check this out:
(I'm using the code below as part of a calculated value on a form. That's why the "session_variables(this.sessionhandle()" is used instead of simply the session variable "vc_Year" as the lookup. ~ Now I'm wondering why/whether I even needed to do that. Performance maybe? It's the only variable vc_Year scoped/used.)

vp_ProgArray[vp_ProgArray.find(val([B]session_variables(this.sessionhandle()).[/B]vc_Year),"Ryear")].award8qual)
'Note:  You have to make sure that the table is initialized with unique values in the Ryear (example above)

[David Boomer]

Re: help with parse of CRLF list

Thanks Finian
That worked perfectly!

Thanks Robert... I will put your suggestion in my code library.

[martinwcole]

Re: help with parse of CRLF list

Finian loves his arrays - but when I have a crlf variable, I just parse thru the variable - much quicker than creating and reading an array!!!
If you have a really long variable - maybe a thousand lines, and you are looping thru the list as I do and doing something each time, it is allegedly faster to use an array, but I have not found it so, myself.

[David Boomer]

Re: help with parse of CRLF list

Thanks Martin... I will keep that in mind (although... at my age, one must be frugal with what one places in one's mind!... Le Chatillier's principle and all that... so... I will add a note to my documentation).