export data (create export action) with data separator as pipe delimited

anildudam

Hi Experts,

I got a requirement to export data as .csv with data separator as pipe (|) delimited.

Please help me how to create an export action in Anaplan as data separator as pipe delimited.

Thanks in advance.

Regards,

Anil

Accepted answers

All comments

Misbah

@anildudam

To my knowledge I don't think that there is way to tweak the formatting of export files in Anaplan. However if you need the data in pipe format, then you could add one more column/line item in the export module and place all the data in this line item. Finally export this line item as csv.

Hope that helps,

Misbah

Miz Logix

ManjunathKN

Hi @anildudam

You cannot export in that way as there is no option for delimiter during export in anaplan like @Misbah mentioned. However, you can use SUBSTITUE logic to replace Spaces with Pipes in another line item and export it.

Edit: Replace Spaces with Pipes, Not Pipes with spaces

Thanks,
Manjunath

ManjunathKN

@anildudam

Can you show the export type you need. because when we say delimiter for CSV it is always "," because it is the format in Excel and after each comma it assigns to new cell.

Thanks

anildudam

Hi Manjunath,

Let me try this option and will revert back once able to do it.

Thanks & regards,

Anil

anildudam

Hi Misbah,

Thanks for your reply, let me try this option and will revert back once able to do it.

Thanks & regards,

Anil

anildudam

Hi Manjunath,

Thanks for your reply, I will share you soon.

Thanks & regards,

Anil

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…