how to process a string into segments retrieved from an array

[spyrule]

Hello,

It's been awhile since I've done some VBA, so my brain is VBrusty...

I've got a 2 column array that consists of

Please Login or Register  to view this content.

I need a button that will process through a specific column and its values, compare the cell's value against the PATH_NAME in the array, if a match is found, apply the matching PATH_VALUE to a variable. (This part, I'm pretty sure I know how to do)

I than need to process that path_value, and then fill another variable with several variations of the original path_value.

Its this variations that I need help with.

Here is an example of a path (and they all follow this pattern pretty consistently).

Please Login or Register  to view this content.

What I need to do is have a text field that produces the following out of the above path:

(I inserted carriage returns to make it easier to read, but it should be just one long string)

Please Login or Register  to view this content.

Any help on this would be awesomly appreciated!

[Tinbendr]

If, in fact, your data is delimited by semicolons, you can use the split function.

Please Login or Register  to view this content.

Temp will be a multidimensional array that you can assign.

E.g.

Please Login or Register  to view this content.

If you wanted the third element.

[spyrule]

Ok, that seems like what I need (I'll need to test it)

However, it delimited by "/" not semicolons.

The issue is that each path do have a variable amount of /'s . So I guess I'll have to loop through the temp array based on its ubound, and then add in a semi-colon after each "result" and keep adding itself to the final output string.

[Tinbendr]

duplicate post

[Tinbendr]

I'm sure there's room for improvement.

Please Login or Register  to view this content.

[Tinbendr]

This ia a tad less convoluted

Please Login or Register  to view this content.

.

[spyrule]

Thanks TinBendr,

Thats exactly what I needed to iterate through this.