Parse a word from string

[AJ106]

Hi I am trying to parse an exact word from a string. there might not be a specific pattern

can some one please help 

thanks

Word : FBRHealthMonitor_DEVPOC.qvw

string : \\phy010118.prod.f01.dc1.abc.com\publisher$\1\Log\20210726\220001 - FBR_POC_appl_FBRHealthMonitor_DEVPOC.qvw\DocumentLog.txt

[atcodedog05]

Hi @AJ106 

Can you provide more examples to understand/come up with pattern.

[AJ106]

the string length and values might differ but, i am interested in extracting  a part of string where ".qvw" is common and the word that comes before .qvw  in this case  "FBRHealthMonitor_DEVPOC" or may be abcd.qvw so on 

Hope i am clear 

[Jean-Balteryx]

What about underscores ? Is there always one ? 

[atcodedog05]

Hi @AJ106 

Why is the expected string FBRHealthMonitor_DEVPOC.qvw and not FBR_POC_appl_FBRHealthMonitor_DEVPOC.qvw

[AJ106]

FBRHealthMonitor_DEVPOC.qvw this is the exact file name and 'FBR_POC_appl' is an application bundle where FBRHealthMonitor_DEVPOC.qvw is a file 

[Jean-Balteryx]

Here is a workflow that takes everything after "appl_" up to ".qvw" using the following REGEX :

appl_(.*\.qvw)

[atcodedog05]

Hi @AJ106 

Here is an example where i am considering the filename starts with appl and end with qvw

appl_(.+\.qvw)

Workflow:

Hope this helps : )

[Jean-Balteryx]

Inspired by @atcodedog05's solution, i simplified my regex :

appl_(.*qvw)

[AJ106]

Thanks