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
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
What about underscores ? Is there always one ?
Hi @AJ106
Why is the expected string FBRHealthMonitor_DEVPOC.qvw and not FBR_POC_appl_FBRHealthMonitor_DEVPOC.qvw
FBRHealthMonitor_DEVPOC.qvw this is the exact file name and 'FBR_POC_appl' is an application bundle where FBRHealthMonitor_DEVPOC.qvw is a file
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 : )
Thanks