Extract String after Last "/"

[former_member188073]

Hi Gurus:

I have document path recorded from log files, which I need to feed to Lumira for Data Analysis.
What we want is just the document name and not the entire path. I was able to extract/extrapolate that in excel as "=RIGHT(A1,LEN(A1)-(FIND("@",SUBSTITUTE(A1,"/","@",(LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))/LEN("/")))))".

Wonder if this is even possible in Lumira Dimensions? Extract the Strings after the last "/".

Regards,

Varun Biswas

[Former Member]

Have you tried using LastWord()

LastWord({Column_0}, "\\")

C:\Program Files\SAP Lumira\Desktop\file1

C:\Program Files\SAP Lumira\Desktop\file2

C:\Program Files\SAP Lumira\Desktop\file3

C:\Program Files\SAP Lumira\Desktop\file4

C:\Program Files\SAP Lumira\Desktop\file5

yields

file1       

file2       

file3    etc.