Retain strings after the special character "/"

Question

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 Answer

@jatienza One way of doing this

ShankerV · Accepted Answer

Hi @jatienza

Please find the below expected output.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @jatienza

Please find the expected output.

binu_acs · Accepted Answer

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