Anaplan picking up double quotes instead of single quotes in a line item name

Hi all,

Just wanted to check if anyone else is also facing this issue. off late if a line item name is having single quote (') in it, then if that line item gets referenced, Anaplan replaces that single quote (') with double quotes (") in the target place.

I faced this issue while drafting a complex formula in notepad and copy pasting it in Anaplan. but i checked and found that this happens even if you reference a line item directly in Anaplan.

Attached is a screenshot showing the same.

Hope this can be investigated and corrected in future releases.

Manu Mathur

quotes_error_example_56772.png

Accepted answers

All comments

kavinkumar

HI @manu.mathur,

I think this is how Anaplan intended to work. If you have any special characters in the name then Anaplan will automatically add quotes to the front and back. It is not only for a line item but also for module names, list names, property names etc.

I hope this helps!!

Regards,
Kavin.

manu.mathur

Hi Kavin,
This is not the case here. The quote is not getting added to front and back to the special characters.
I have used other special character line (eg: €), and there the quotes were not added. In my scenario, the quotes got added only at the end (not at front), and a single quote gets appended only at the end.
The scenario that you have mentioned is agreed but is a different scenario.

Kind Regards
Manu Mathur

usman.zia

Hi @manu.mathur

I have never seen this before but I assumption is that having the single quote in the name is interfering with how Anaplan works and this is a very unique case. This may be something to raise with anaplan support and they can advise on whether this is a bug.

As @kavinkumar explains if you have a special character in a name it will always add quotes to the front and back of the whole name in a formula and not just the special character. From your screenshot it appears to be doing this but adding double quotes to end and it may to do this to differentiate the single quote you have in the line item.

Have you tried using a different special character like a ? / or - and seen if you have the same issue?

Thanks,

Usman

manu.mathur

Hi Usman,
I have tried other special characters, but this additional quote is appearing only when having a single quote special character ('). The single quote need not be at the end of the line name but could be anywhere in the name.
I have raised it in the 'Idea Exchange' portal.

Regards
Manu Mathur

JaredDolich

@manu.mathur thanks for sharing this. To be honest, I've never seen this before partly because, for my line items, I try to avoid special characters and emojis, @DavidSmith's Planual even suggest emojis be avoided - page 20.

But, the double quote you mentioned is actually two single quotes. I believe this is the escape character for Anaplan.

I replicated it and discovered you can get this to work if you use two single quotes.

Created a source module with line item and line item value using a single quote.

Displays correctly.

Using a formula I referenced the source but used two single quotes.

Works perfectly.

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…