Split string starting at the end of the string

Help Studio
, ,
1

Hello, i want to take a string like the example below:

[EXTERNAL] Training Complete: BOSS Advanced Curriculum for employee - 012345

i want to start at the end and split at the employee id. Was trying to read through the forum before i posted but could not find out how to start at the end of the string to grab what i need. the reason for starting at the end is that the word “employee” here will actually have the employee’s name so the number of characters will always be different leading up to the employee id.

2

Hi @chris.dease

Your query is some what confusing, could you be more elaborate your query and provide the input and required output for our reference.

If you want to get the Employee ID only then you can use simple split function for this,

- Assign -> Input = "[EXTERNAL] Training Complete: BOSS Advanced Curriculum for employee - 012345"
- Assign -> Output = Input.toString.Split("-")(1).Trim

Hope it helps!!

3

Hi @chris.dease

Input.Substring(Input.LastIndexOf("- ") + 2)

image
image871×377 14.1 KB

4

@chris.dease

Str.Split("-"c).Last will give the last string after hyphen

Cheers

5

this was helpful. i just realized after posting i could split and the hyphen instead of starting at end of string. thanks!!

1 Like
6

It’s my pleasure… @chris.dease

Happy Automation!!

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.