Hi,
I have the full path output as field name. For example [path name... |||'Marimar$'. I would like to get only the name Marimar or Jeger which is found at the end of the path which corresponds to sheet name.
Please let me lend any of your assistance.
Thanks,
Mar
Solved! Go to Solution.
@KamenRider Another method
Trim(Trim(SubString([FilePath],FindString([FilePath], '|')+3,Length([FilePath])),"'"),'$')
Hi @atcodedog05
I'm not sure but it is giving me "NULL" results. The path starts with for example - \\gonzales.singapore/peter/pablo/....|||'Marimar$'. The path is very long about more than 260 characters.
Please advise.
Thanks,
Mar
The formula is good but I am receiving an error - Parse Error at Char (89) Malformed Function Call (Expression # 1). Do you know why?
Please advise.
Thanks,
Mar
I tried to repeat your formula - REGEX_REPLACE([field],".*\ /\ / \/'(.+)\$'","$1" but the results is the same as the full path - \\....|||'Marimar$'. I apology if can\t share the workflow since I don't have access on my personal desktop.
Hope you can still help me find the solution.
Thanks,
Mar
@KamenRider Can you share your file full path not workflow
The path is very long. Please see below. I changes some due to confidentiality.
\\NASOUTH.AD.CALIFORNIA.COM\AMERCFSMB SHARE25\BDTM_NML_bbQA\common\BDTM_NML_bbQA\1 BAKIMA INPEXING TEAM\PROKEY - ALL\2022 DIRECT PUTO\DA-FUNDING\CONTROL REPORT 2022\ALTERYX VERSION\BUYOFF LOG.xslx|||'JAYSON$'
The goal is to get or extract the sheet name from the input file. I welcome any ideas just to get sheet name.
Thanks and looking forward for your response.
Kamen