How to Substitute out Quotes

I am trying to write a substitute formula that simply deletes double-quote characters

Example:

Text1 Start: This is a "note" text field

Text2 After Formula: This is a note text field

Is this possible? It appears anytime I try and reference a " anaplan recognizes that as a syntax and not a character.

Tags

Accepted answers

There might be other ways to do this, but this idea should be easy to execute.

In a constants/selector module put a line with no dimensions formatted as a text and input your " into that cell as the data.

Then in the substitute formula in the text to replace section, just reference your line item that contains the text you want removed. Then finally just in the final replacement text variable put "" so that it replaces it with nothing.

https://help.anaplan.com/substitute-841babeb-4694-4761-91c1-18d920edb879

I hope this helps!

Jason

Hi @lhidden

Use the SUBSTITUTE Function

Create another line item where you want the final text to appear, let’s call it Text Without Quotes.
Set the format of this line item to Text.
Use the Formula: https://help.anaplan.com/substitute-841babeb-4694-4761-91c1-18d920edb879
SUBSTITUTE(Text Field, Quote Character, "")

Text Field should be replaced with the name of the line item that contains the original text.

All comments

There might be other ways to do this, but this idea should be easy to execute.

In a constants/selector module put a line with no dimensions formatted as a text and input your " into that cell as the data.

Then in the substitute formula in the text to replace section, just reference your line item that contains the text you want removed. Then finally just in the final replacement text variable put "" so that it replaces it with nothing.

https://help.anaplan.com/substitute-841babeb-4694-4761-91c1-18d920edb879

I hope this helps!

Jason

Hi @lhidden

Use the SUBSTITUTE Function

Create another line item where you want the final text to appear, let’s call it Text Without Quotes.
Set the format of this line item to Text.
Use the Formula: https://help.anaplan.com/substitute-841babeb-4694-4761-91c1-18d920edb879
SUBSTITUTE(Text Field, Quote Character, "")

Text Field should be replaced with the name of the line item that contains the original text.

Thanks guys, you are way more clever than myself.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
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…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…