Writing a , - delimited, or ; - delimited string to an array
Hi, I have shapesheet cells with data strings like this:
1,234,34,236,45,863,5,1,89
(the type of delimiter is not constrained; white space can be added; the data is integer).
I want to compare strings and identify those with AT LEAST ONE integer in common. The relative positions of integers within the strings are irrelevant.
- Should I should first convert the shapesheet data strings to arrays, and then compare them?
- If so, what is the simplest way of converting a string from a shapesheet cell into a VBA array?
- Are there comparision functions that are useful for this task?
(My home made string parser enumerate integers individually, but it has given me problems when I seek to output the enumerated data in the form of an array. I suspect a ReDim problem, but want to ask about best approaches before further attempts to pep-up my code..)
I use vba, not VB.
Thanks,
Kelvin
1,234,34,236,45,863,5,1,89
(the type of delimiter is not constrained; white space can be added; the data is integer).
I want to compare strings and identify those with AT LEAST ONE integer in common. The relative positions of integers within the strings are irrelevant.
- Should I should first convert the shapesheet data strings to arrays, and then compare them?
- If so, what is the simplest way of converting a string from a shapesheet cell into a VBA array?
- Are there comparision functions that are useful for this task?
(My home made string parser enumerate integers individually, but it has given me problems when I seek to output the enumerated data in the form of an array. I suspect a ReDim problem, but want to ask about best approaches before further attempts to pep-up my code..)
I use vba, not VB.
Thanks,
Kelvin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
excellent !
ASKER
Many thanks for the instant response: it worked first time.
Best regards
Kelvin