topic Re: Renaming File Names in QlikView

Renaming File Names

Anonymous — Fri, 22 Mar 2013 20:25:59 GMT

I need to remove (or ignore) underscores from image files (jpeg & gif) so they can be matched with one of the fields in QVD (and finally show images inside a straight chart). Code is working fine but the way image files are sent, they have underscores and that does not match filed values in QVD.

Re: Renaming File Names

MayilVahanan — Fri, 22 Mar 2013 20:34:22 GMT

If you need to remove the underscore in the file name, please use replace() function like this

Replace(Filename,'_','') As FileName

Hope it helps

Re: Renaming File Names

Anonymous — Fri, 22 Mar 2013 21:11:22 GMT

Above option doesn't seem to work.

I'm doing:

MainTable:

Load * From \..\Data.qvd;

Img:

Bundle Info LOAD

[P ID],

'\..\ImgFiles\'&[P ID]&'.jpg' as PIDImg

Resident MainTable;

I tried:

Replace('\..\ImgFiles\'&[P ID]&'.jpg','_','') as PIDImg

but no success.

Re: Renaming File Names

MayilVahanan — Fri, 22 Mar 2013 21:24:35 GMT

[P ID] contians underscore?

if so, '\..\ImgFiles\'&replace([P ID],'_','')&'.jpg'

hope it helps

Re: Renaming File Names

Anonymous — Fri, 22 Mar 2013 21:28:02 GMT

Hi,

[P ID] does not have underscores.

Re: Renaming File Names

MayilVahanan — Fri, 22 Mar 2013 21:40:26 GMT

Can you say where underscore contain? can you please give some example to solve it?

Re: Renaming File Names

Anonymous — Fri, 22 Mar 2013 21:41:58 GMT

[P ID] contains spaces, I did the reverse:

Replace([P ID],' ','_')

and it worked.

Thank you.