Hi all... I'm attempting to clean up some rather ugly strings, and would like to automate a process to clear out all the data with the exception of what's between quotations.
The strings are variable length, and could have anywhere from 0 to 6 sets of quotations.
For example
From this
aliasid:6558 enabled:0 yk:2 aclass:1 ticker:"SHE US" aliastext:"SHENGKAI" strength:1003 chgid:1826630 usage:2
I want to be left with
Because this will sit in the middle of a larger macro, I'd much prefer to do this with vba code than a formula, but if the formula is the way to go, I can work with it.
Thank you so much for any help!
Bookmarks