ReportServer Forum

SteffenF

Member

Registered: 2015-06-19

How to use tab separator in csv list datasource

Hi,

in chapter 4.5 of Admin guide, you say that csv datasources can have a data record separator.

This works fine for normal characters like ;

But I have a tab separated csv list in some cases.

Any hint how to use tab as separator ?

(Remark: please do not suggest to convert from tab to another separator)

Thx and regards

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: How to use tab separator in csv list datasource

Hi SteffenF,

that is indeed a bit tricky but, in fact, all that is needed is that you input a tab into the separator text box. The easiest to achieve this is to go to a text editor insert a tab and then copy paste it into the separator text box of ReportServer. I agree that this is not really optimal but it should solve the problem.

Cheers
-Arno

SteffenF

Member

Registered: 2015-06-19

Re: How to use tab separator in csv list datasource

Thx ! Works perfectly fine !