Quote:
Originally Posted by theducks
NOT Tested: Copy to new
\,\s(weight:.+?)\,*
Replace: \1
Destination field : <your other column> <<<this is important or you will lose the rest of the tags
Search for a comma Space
Capture weight an up, but not including a comma (optional)
The cleanup is a whole lot trickier
AND SERIOUSLY NOT TESTED Make a Backup, there is no Undo
I would do as 2 steps
First is where Weigh is the last item (this should just truncate it away)
(.+)\,\sweight:.+?
Replace:\1
Second is similar, but carves out weight and puts the 2 chunks together with a comma space
(.+)\,\sweight:.+?\,\s(.+)
Replace:\1, \2
|
I've tried all three but it captures the whole tag line. I have regular expression in search mode.
\,\s(weight:.+?)\,*
Replace: \1
test case "case:AR5steel, group:Fractal-group, heavy, T*m5%, weight:@eightySix'Kilos"
test result "case:AR5steel, group:Fractal-group, heavy, T*m5%weight:@eightySix'Kilos"