Hello All.
I'm looking for some algorithm to build a combination of strings from multiple arrays. Let me explain in detail.
- I'm working on VBA (excel). I have functions that accept one string and return a collection. These get listed in columns in excel (one column per call to the function).
- This results into arrays of strings in different columns. Unfortunately, the number of strings in an array is unknown at design time (these get retrieved from another sheet by other functions) and so are the number of columns / arrays (these depend on user interaction) and both are out of my control :-(.
- What I am supposed to do is build up a combination of all possible string values from each of these columns. I've been looking for something like an algorithm / flowchart for a headstart.
Any help towards this objective is welcome. Existing links to articles will also be fine.
Thanks in advance,
Parag
I'm looking for some algorithm to build a combination of strings from multiple arrays. Let me explain in detail.
- I'm working on VBA (excel). I have functions that accept one string and return a collection. These get listed in columns in excel (one column per call to the function).
- This results into arrays of strings in different columns. Unfortunately, the number of strings in an array is unknown at design time (these get retrieved from another sheet by other functions) and so are the number of columns / arrays (these depend on user interaction) and both are out of my control :-(.
- What I am supposed to do is build up a combination of all possible string values from each of these columns. I've been looking for something like an algorithm / flowchart for a headstart.
Any help towards this objective is welcome. Existing links to articles will also be fine.
Thanks in advance,
Parag
Comment