Retain strings after the special character "/"

[jatienza]

Hi,

Need help in retaining strings after the special character "/" in the left-most portion, please data below.

Raw data:

http://fr.company.com/company/class-a-123

http://md.company.com/company/class-b-2356

Output:

class-a-123

class-b-2356

Thanks,

Jaime

[binu_acs · Accepted solution]

@jatienza One way of doing this

[ShankerV · Accepted solution]

Hi @jatienza 

Please find the below expected output.

Many thanks

Shanker V

[jatienza]

Thanks! @binu_acs @ShankerV 

[ShankerV]

Hi @jatienza 

Can be used only one tool also.

Many thanks

Shanker V

[jatienza]

By the way, how about if the raw data has "/" at the end? please see below

Raw data:

http://fr.company.com/company/class-a-123

http://md.company.com/company/class-b-2356/

Output:

class-a-123

class-b-2356

Thanks.

[ShankerV · Accepted solution]

Hi @jatienza 

Please find the expected output.

[binu_acs · Accepted solution]

@jatienza The TrimRight function will remove the extra \ at the end of the path before applying the regex