Find the nth occurrence of a string and replace the Right of string with ""

Hi,

I have a User input path which will have a Folder_Name at the end of the path as shown below;

C:\Users\r628953\Desktop\09-25-2018_Sample_files

So, I need to find the last occurrence of "\" in the above path and replace the right of the string with "". So, that I will get the folder name out of the string; which will be 09-25-2018_Sample_files. I have researched about it, but could not able to get the exact answer I am looking for.

Can some one help me in achieving this?

Thanks!

Regex

Preparation

Accepted answers

jdunkerley79

How about:

FileGetFileName([FullPath])

All comments

Thableaus

Hi @aparanjith1

I'm not sure if I got what you meant, but if you need to extract the last part I'd recommend you to use a Regex Expression.

REGEX_Replace([Field1], ".*\\(.+)", "$1")

If you need to replace the last expression, you could change it to REGEX_Replace([Field1], "(.*\\)(.+)", "$1replacementstring"), replacement string being what you want to put it there..

Cheers,

jdunkerley79

How about:

FileGetFileName([FullPath])

aparanjith1

Awesome, good thing to know.

Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703