remove part of line

cisco779k

i have

"trim:track:47EiUVwUp4C9fGccaPuUCS","text001",
"trim:track:59qrUpoplZxbIZxk6X0Bm3","text002",
"trim:track:70rFIfYN7lU6iTgUIVP42w","text003",

and i want delete first part of each line “trim…”,

"text001",
"text002",
"text003",

how to?

cisco779k

or better, how to remove part of txt with recursive text but different value? example:

"trim:track:47EiUVwUp4C9fGccaPuUCS"
"trim:track:59qrUpoplZxbIZxk6X0Bm3"
"trim:track:70rFIfYN7lU6iTgUIVP42w"

this is in case, unlike the previous post, the text to be deleted is not at the beginning of the line, but after other text, always on the same line, example:

"some text","adc:artist:1bqxdqvUtPWZri43cKHac8, ddd:artist:41X1TR6hrK8Q2ZCpp2EqCz","text2","trim:track:70rFIfYN7lU6iTgUIVP42w",

astrosofista

Hi @cisco779k

This regex may work in the examples you provided:

Search: (?-s)"trim:.+?",
Replace: [Leave empty]

Please don’t forget to take a look to the regex FAQ I suggested you before. Thank you

Have fun!

cisco779k

many tanxs for your reply!

Alan Kilborn

@cisco779k

You have asked several regex data transformation questions on the forum. Give us all some “tanxs” by putting in the effort to learn why @astrosofista 's technique worked on your data, so that in the future you can maybe solve this type of problem (a fairly simple one) without coming here for help.

Some nice resources are found HERE.