How to Substitute out Quotes

lhidden
lhidden
in Modeling

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.

Best Answers

  • jasonblinn
    jasonblinn
    Answer ✓

    @lhidden

    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.

    image.png

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

    I hope this helps!

    Jason

  • Anurag0911
    Anurag0911
    edited July 2024 Answer ✓

    Hi @lhidden

    Use the SUBSTITUTE Function

    1. Create another line item where you want the final text to appear, let’s call it Text Without Quotes.
    2. Set the format of this line item to Text.
    3. 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.

Answers

Categories