CSV Datasource

flo78 · Post by **flo78** » Mon Oct 31, 2011 6:56 am

Hello,

I am using a csv file as datasource. Delimiter symbol is semicolon. Could you tell me how to escape this symbol when it appears as part of a string value.
In your documentation you tell to frame it with double quotes. Doing so, the report recognizes that the semicolon is part of the string, but shows it as ";" and not only as ;

Another question:
One column in the csv file is a path to an image file. I have an Image control in the report whose hyperlink property is set to this value.
But the link always has to be written as an absolute path, which is a problem because I want to copy the report into various folders and don't want to adapt the path each time. Report, csv and images always are in the same folder. Is it possible to use a relative path (= only the name of the image file) ?

Thank you very much.

flo78 · Post by **flo78** » Mon Oct 31, 2011 11:03 am

OK, the thing with the path is nonsense. Of course a relative path refers to the location of the Designer.exe and not to the path of the mrt-file.
But still I don't know how to escape semicolons...

Post by **Ivan** » Tue Nov 01, 2011 2:35 am

Hello,

Please check the sample in attachment.

Thank you.

flo78 · Post by **flo78** » Wed Nov 02, 2011 2:59 am

OK, you have to put the whole string between double quotes, not only the semicolon itself.

Thank you!

Post by **Alex K.** » Wed Nov 02, 2011 3:50 am

Hello,

Let us know if you need any additional help.

Thank you.