Excel VBA: Split Method

[Converemon]

I have just recently discovered the "Split" function and found it very useful for a project I am working on. I am parsing a string in the form of "M71+L09+J82+K99..." with "+" as the delimiter. However, when I try to parse the string into an array it only grabs the strings after the "+" which results it skipping the first one ("M71"). I was wondering if anyone had to deal with this problem before? Here is my code:

opcArray() = Split(curoptlistcell.Value, "+")

 

[Joe4]

However, when I try to parse the string into an array it only grabs the strings after the "+" which results it skipping the first one ("M71").

How are you trying to return it?
Note, that by default, arrays are zero indexed, meaning that you would return the first item like this:

opcArray(0)

not like this:

opcArray(1)

(that would return the second member of the array)

 

[Rick Rothstein]

How are you trying to return it?
Note, that by default, arrays are zero indexed, meaning that you would return the first item like this:

opcArray(0)

not like this:

opcArray(1)

(that would return the second member of the array)

I already told the OP this here...

http://www.mrexcel.com/forum/excel-...ions-help-regular-expression.html#post3846256

and he seemed to understand it, at the time, according to his reply in the next message in that thread.

 

[Joe4]

Converemon,

Please take note not to double-post your questions. Any follow-ups or clarifications of a question should just be continued in that original thread and not posted to new questions (see rule #9 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).

Thanks

 

[Converemon]

I would like to apologize. I posted this thread before I asked on my other thread. I figured I'd ask since I had not yet received any answers. My apologies.

 

[Rick Rothstein]

I would like to apologize. I posted this thread before I asked on my other thread. I figured I'd ask since I had not yet received any answers. My apologies.

You should just "bump" your original thread instead of starting a new one, but if you do start a new thread, then you should go back to your original thread and post a message there saying you started a new thread and give the link to it, that way volunteers in this forum won't waste their time answering your old thread (assuming they stumble across it) when you already have your answer elsewhere.