How to fetch file name?

[soha1902]

Hello everyone,

I want to load file name in my QV app.

for example: I am having below URL list in excel.

URL

\\abc.com\project\docs\cs\one.xlsx

\\abc.com\prjocts\docs\cs\it\two.xlsx

\\abc.com\prjocts\cs\it\three.xlsx

Now I want to load only last name in my app like below

URL

one.xlsx

two.xlsx

three.xlsx

Please help.

[its_anandrjs]

Use subfield function

[its_anandrjs · Accepted solution]

Try Like

LOAD URL, SubField(URL,'\',-1) AS NewUrl

LOAD * Inline

[

URL

\\abc.com\project\docs\cs\one.xlsx

\\abc.com\prjocts\docs\cs\it\two.xlsx

\\abc.com\prjocts\cs\it\three.xlsx

];

[#4]

Hi soha,

You need to use FileBaseName() for this in script level like,

FileBaseName() as BaseName

[amit_saini]

Hi Soha,

Like this??? Please see the attachment.

Thanks,

AS