We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extracting the Name in the Full Path

KamenRider
11 - Bolide

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

28 REPLIES 28
atcodedog05
22 - Nova
22 - Nova

Hi @KamenRider 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644840082660.png

 

Hope this helps : )

 

binuacs
21 - Polaris

@KamenRider Another method

Trim(Trim(SubString([FilePath],FindString([FilePath], '|')+3,Length([FilePath])),"'"),'$')

binuacs_0-1644840900949.png

 

KamenRider
11 - Bolide

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

atcodedog05
22 - Nova
22 - Nova

Hi @KamenRider 

 

It still seems to work. Can share some data in a yxdb file

 

atcodedog05_0-1644841292605.png

 

Hope this helps : )

 

KamenRider
11 - Bolide

Hi @binuacs  @atcodedog05 

 

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

binuacs
21 - Polaris

@KamenRider The formula is working for me 

binuacs_0-1644842276064.png

 

KamenRider
11 - Bolide

Hi @atcodedog05 @binuacs 

 

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

binuacs
21 - Polaris

@KamenRider Can you share your file full path not workflow

KamenRider
11 - Bolide

Hi @binuacs  @atcodedog05 

 

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

Labels
Top Solution Authors