Extracting Specific Text in a Filename

Hi,

My sample below are:

BPOPHASE_14PL1H1
BPOPHASE_14PL1P2
BPOPHASE_14PL1X

Results should be

As you can, we are to extract the text after "_14PL1". I have use the regex Regex_Replace([Field],".*_(.*)","$1") but it is not giving me the desired output

Hope to hear any ideas from anyone.

Kamen

Workflow

Regex

Accepted answers

Felipe_Ribeir0

Hi @KamenRider

One way of doing this:

regex_replace([Sample], '(.*\_\d+.*?\d+)(.*)', '$2')

Screenshot 2023-08-28 140225.png

extract.yxmd

All comments

apathetichell

Regex_Replace([Field],".*_(.*)","$1") from BPOPHASE_14PL1H1 should be "14PL1H1" - to extract just the last part you'd use

regex_replace([Field],".*_14PL1(.*)$","$1") - this would give you the one or two characters after _14PL1.

assuming it's only 1 or 2 characters you could swap .* for .{1,2}

KamenRider

Hi @apathetichell

Regex_Replace([Field],".*_14PL1(.*)$","$1") is giving me a solution of the entire filename. It doesn't give me the solution I wanted. Aside from that, it does not only "_14PL1, it can be _15XC2 so it varies. Most important is to get the last one or two characters after a numeric.

Please advise.

Kamen

apathetichell

Cool - thanks for the clarification 14PL1 won't work if that specific string isn't in the original field... if you are looking at numeric and then character try:

Regex_Replace([Field],".*\d(.{1,2})$","$1")

This would be the last one or two anything following a number.

dwstada

Regex_Replace([Field],".*?_.{5}(.+)","$1")

this formula will give you whatever is coming 5 characters after a "_"

extracting specific text in a filename.PNG

the problem with your original expression was the first ".*" being greedy and therefore being used for the whole file name and ignoring all the other characters in your expression - making it lazy ".*?" will allow the other parts of your expression to be used as well

try using regex101.com to test your expressions and get explanations what the different parts do, helps me a lot

Felipe_Ribeir0

Hi @KamenRider

One way of doing this:

regex_replace([Sample], '(.*\_\d+.*?\d+)(.*)', '$2')

Screenshot 2023-08-28 140225.png

extract.yxmd

KamenRider

Thank you guys. All of your ideas work.

Kamen

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335