Take last file/word of a URL

[saumyashah90]

I have 1000's of different URL's

example

Input:

Header1

http://abc.ed.aea/file1/file2/file3/abc.svc,

http://sf.asda.afas/file1/bdf.asmx,

http://af.saf.fw/xyz,

http://adas.dasd.dasd/file1/file2/file3/file4/file5/file6/pqr.svc,

etc

Output Needed:

abc.svc,

bdf.asmx,

xyz,

pqr.svc,

etc

Request you to help me in that.

Header1 is a column from excel.

[MarcoWedel · Accepted solution]

SubField(Header1,'/',-1)

[Anonymous]

Take a look on the attached file.

Regards,

Gabriel

[MarcoWedel]

Hi,

one solution might be:

LOAD *,
    SubField(Header1,'/',-1) as LastSubField
Inline [
Header1
http://abc.ed.aea/file1/file2/file3/abc.svc,
http://sf.asda.afas/file1/bdf.asmx,
http://af.saf.fw/xyz,
http://adas.dasd.dasd/file1/file2/file3/file4/file5/file6/pqr.svc,
];

hope this helps

regards

Marco

[its_anandrjs]

One possible solution will be

Input:

LOAD Header1, SubField(Header1,'/',-1) as NewField;

LOAD * Inline

[

Header1

http://abc.ed.aea/file1/file2/file3/abc.svc,

http://sf.asda.afas/file1/bdf.asmx,

http://af.saf.fw/xyz,

http://adas.dasd.dasd/file1/file2/file3/file4/file5/file6/pqr.svc,

];

And you get

Regards,

Anand

[#6]

Hi,

subfield(Fieldname,'/',-1)

[saumyashah90]

Hey Mac,

when i tried my self i got similar solution like:

=Subfield(Header1,'/', Substringcount(Header1,'/')+1)

But yours seems to be more optimal.Thanks....

[MarcoWedel]

You're welcome

regards

Marco