MobileRead Forums - View Single Post

yamusing · 05-06-2020, 05:41 PM

I'm trying to capture and move certain text within the tag colums to another column for 100s of books but I find it too complex to do within regex. How can I do the following with the regex search and replace, within the tags column example:
"5-glass, apple, group:95#TR4, Hefine94, weight:140lbs (acc), Z97-A.5"
"case:AR5steel, group:Fractal-group, heavy, T*m5%, weight:@eightySix'Kilos"
"case:AR5steel, dark, group:R3.R4.R5, group:Fractal-group"

I want to capture the characters after "weight:" but not the comma or anything after that, then move that piece of text into another column. After that remove "weight:" and the captured text from the tags column. Is this possible?

05-06-2020, 05:41 PM	#1
yamusing Enthusiast Posts: 47 Karma: 10 Join Date: Jul 2019 Device: none	Regex search and replace I'm trying to capture and move certain text within the tag colums to another column for 100s of books but I find it too complex to do within regex. How can I do the following with the regex search and replace, within the tags column example: "5-glass, apple, group:95#TR4, Hefine94, weight:140lbs (acc), Z97-A.5" "case:AR5steel, group:Fractal-group, heavy, T*m5%, weight:@eightySix'Kilos" "case:AR5steel, dark, group:R3.R4.R5, group:Fractal-group" I want to capture the characters after "weight:" but not the comma or anything after that, then move that piece of text into another column. After that remove "weight:" and the captured text from the tags column. Is this possible?