Parse FileName from FullPath

[BautistaC888]

Hello,

I receive a list of FullPaths and i need to extract the FileName.

If anyone could help with a way to parse the name i will appreciate it (The last "\" will be the delimiter).

[atcodedog05 · Accepted solution]

Hi @BautistaC888 

You dont need regex you can directly use formula FileGetFileName([Field1])

Hope this helps : )

[ChrisTX]

Try this function in a Formula tool:

FileGetFileName(Path): Returns the name portion of the path, without the extension.

List of all functions:  https://help.alteryx.com/20213/designer/functions-quick-reference

Chris

[mceleavey]

Hi @BautistaC888 ,

You can do this in a formula:

M.

[atcodedog05]

Hi @BautistaC888 

Also adding a regex method. 

Hope this helps : )