Read one line text and pass it to an array

[jeyanthi]

Hi i need help on passing a line of strings to an array. i can get the line i need but i dont knw how to pass the line values to an array

for example ;

the line i get DT=CLS,DR=CLS,RT=OPN,.....

now how to pass it to an array?

Plz help

[MikeS81]

Hi jeyanthi,

do you want to split this string into an array?

Your line: DT=CLS,DR=CLS,RT=OPN,...

toArray: [DT=CLS, DR=CLS, RT=OPN,...]

If yes you can use the spreadsheet string to array function.

Mike

[jeyanthi]

hi. Yes the array should be like tht. Can i get some examples. Plz.

[jeyanthi]

I try to use the spreadsheet to array but i am confuse wit the array type (2D(dbl)) function . how to indicate it to 1D Array

[MikeS81]

Hi jeyanthi,

here is an example.

Mike

[GerdW]

Hi jeyanthi,

make the type constant a 1D array and you will get a 1D array of data. And btw. make it an array of strings as you want an array of strings! And use a comma as separator

Here's an example:


Hmm. Mike also starts to work at 9 - seems quite common in Germany

Message Edited by GerdW on 05-14-2008 09:16 AM

[jeyanthi]

thk u for your guides it really help me. Thk u again:womanhappy: