Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 10, 2017 at 02:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded