Hello,
I am trying to figure out how to return multiple values that are adjacent to a series of the same substring. So here is the setup. Say in cell [A1] I have a very long string. Within this string, the following substring will occur an unknown number of times:
"@baseRate":"499.0"
This part, "@baseRate": will always be the same, but the "499.0" will vary (both the length of that string and the number of occurences of the string will vary). So I could have a string like this in [A1]:
....."@baseRate":"499.0"........."@baseRate":"399.0".........."@baseRate":"99.0" (the periods are other parts of the string that I am not concerned with)
What I would like to return in [B1]:[D1] would look like the following:
B1: 499.0 C1: 399.0 D1: 99.0
The problem I foresee is the actual rate data I am looking for will not have a fixed length and the "@baseRate" could occur one time or it could occur 30+ times.
Any help is very much appreciated.
Thank you,
learning_VBA
Bookmarks