I have a raw data file which is importing some text columns with tags on either side of the data. The tags are not exactly the same on the left side for each case, and include no space. An example would be this:
<a href="a213w9245992999Vrh" target="_blank">PROPER DATA</a>
I want to extract from that PROPER DATA.
The alphanumeric portion after href= on the left side can vary from row to row.
I've tried this, but it does nothing.
pos1=findc(StringVar, '>');
pos2=findc(StringVar, '</a>');
NewVar = substr(StringVar, nos1+1, nos2-1-nos2);
I've tried this and had some result. No change.
pos1=findc(StringVar, '_blank">');
pos2=findc(StringVar, '</a>');
NewVar = substr(StringVar, nos1+1, nos2-1-nos2);
How can I extract that text?
... View more