Text from URL

[arusiva89]

I want to extract the last text from URL

Url will be like 

Google.com/ABC

Google.com/abc/123

Always last text in the URL should be returned..I can't use subfield function 

[Taoufiq_Zarra]

@arusiva89  like :

mid(URL,Index(URL,'/',-1)+1) as Text_From_URL

Example :

Input:

load *,mid(URL,Index(URL,'/',-1)+1) as Text_From_URL inline [
URL
Google.com/ABC
Google.com/abc/123

];

output:

[Kushal_Chawda · Accepted solution]

@arusiva89  subfield can be used here as below

=subfield(URL,'/',-1)