Skip to Content
0

How can i use a | as a delimiter in a webi report scheduled to output to a csv

Aug 10, 2017 at 02:11 PM

19

avatar image
Former Member

I need to run a scheduled webi report whose output will be used as input to another system (which is outside my control) and that needs to have pipe (|) separated input

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Aug 10, 2017 at 02:18 PM
0

follow these steps.

create single variable at report level.

Var_Main="|"+[Object1]+"|"+"|"+[Object2]+"|"+"|"+[Object3]+"|"

Drag Var_main in report.

Schedule the report and select format "text" and in destination uncheck the checkbox "Add extension" and manually add extension.csv.

Filename:report name.csv

Share
10 |10000 characters needed characters left characters exceeded