Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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:
@arusiva89 subfield can be used here as below
=subfield(URL,'/',-1)