Split text (last)

[Stef_99 (Mary)]

I have value D\yuyu\rtrt\df.xlsx I want get value after \ (last text) —> expect output df.xlsx
D\uyu\uiu\uiui\ui.pdf —> expect output ui.pdf

Please guide me for solve it.

[lrtetala (Lakshman Reddy)]

@Stef_99

D\yuyu\rtrt\df.xlsx

Hi @Stef_99

Try this

Path.GetFileName(Input.ToString)

Cheers!!

[pravallikapaluri]

Hi @Stef_99

fullPath.Substring(fullPath.LastIndexOf("\") + 1)

Hope it helps!!

[lrtetala (Lakshman Reddy)]

@Stef_99

D\uyu\uiu\uiui\ui.pdf

@Stef_99

Cheers!!

[mkankatala (Mahesh Kankatala)]

Hi @Stef_99

You can try the below expression by using the Data Manipulations Split Function,

- Assign -> Input = "D\yuyu\rtrt\df.xlsx"
- Assign -> Output = Input.Split("\").last.toString

The Output Variable stores the df.xlsx.

Hope it helps!!

[KevinE (Kevin)]

If you want to split text, have you tried the activity called “Split Text”? It splits text into a list of strings. Then you can get the last one like output(output.count-1)

Other approaches do work, but you should use the correct activities whenever possible.