Use wildcard find and place segment of field in another field?
I'm wondering if it's possible to take part of a field information and insert it into another field?
I have a column called "idata" and some of the fields contain a segment of html data involving width="*px". It doesn't really say *, it's actually a number, but not every field has the same number.
I'd like to be able to use a sort of wild card, and say find the 'width="*px"' in the idata column and then put just the number in another field called in the imgwidth column, and replace the former number in idata with ''?
Is this possible? Otherwise I have to go through 550 rows, one at a time.