Renaming File Names

[Anonymous]

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.

[MayilVahanan]

Hi

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

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

Hope it helps

[Anonymous]

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.

[MayilVahanan · Accepted solution]

Hi

[P ID] contians underscore?

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

hope it helps

[Anonymous]

Hi,

[P ID] does not have underscores.

[MayilVahanan]

Hi

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

[Anonymous]

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

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

and it worked.

Thank you.