Reading a string left to right

Hi,

I have a field titled "File Path Name" with values in the following format:

map/file/Delta Hospital

map/file/HSC/Alpha Hospital

screen/file/HSC/Omega Hospital

map/Sigma Hospital

I want to pull all characters (Hospital Names) to the right of the last "/" or essentially all characters from the end of the string up until the last "/". The problem is there are a different amount of "/" in every record, but the Hospital Name is always at the end of the string. Is there a way to read the string from right to left and find that first "/" and pull those characters?

Thank you for your help!

Regex

Transformation

Accepted answers

DavidP

This will do it

extract hospital name.yxmd

All comments

DavidP

This will do it

extract hospital name.yxmd

fmvizcaino

Hi @mattpwc ,

I'm attaching an example where I use the regex tool to get that.

Take a look and let me know if this works for you.

Best,

Fernando Vizcaino

2020-02-19 Reading a string left to right.yxmd

RolandSchubert

Hi @mattpwc ,

a solution doing literally what you've written, would be to use the function ReverseString, which reverses a string, FindString to find the last "/" (which is the first in the reversed string) and Right to pull the characters after the separator. As (nearly) always, there are different ways to solve a problem using Alteryx. Hope, this is helpful.

Best,

Roland

LastPart.yxmd

mattpwc

Works great thank you for the help!

mattpwc

Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703