Good Day Experts!
I am trying to figure out the best way to iterate through an Array, manipulate the data and then either save it in place or to a new Array.
I have parsed off the string of a Delete query after the Where. So, for example I would have "Customer = '123' And Order = 'abc'"
Then I run the following code to split it apart on the And:
Dim ValueArray() As String
ValueArray = qryString.Split(":")
The Array contains:
Customer = '123'
Order = 'abc'
I am intersted in stripping off all data before/including the = and getting rid of the single quotes leaving:
I would then need the data back in the original array or a new one.
What is the best way you all can suggest to achieve this?