Ever try removing a single " (quote symbol) from a string of text? HELP! Monarch Classic

Amanda Hamm
Amanda Hamm Altair Community Member
edited February 2023 in Community Q&A

Using Monarch Classic

I am working with a dataset that randomly includes records with a single " (quote symbol) in the string of text of a single field.

The problem I've had replacing or stripping the " from the text string is that you need the " " to define the character.  Whenever I put the " inside the " " it prevents me from moving forward as it's expecting me to close the quote again with a fourth ".  

Simple same text:  

Bob"s Bike Store

This should be so simple but I keep hitting a wall.  I just want to remove all " (quote symbols) from the string.

Thank you!

 

 

Tagged:

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited February 2023

    If you are trying to remove the double quotes you can use the single quote instead.  For instance, there is a "Strip" function:

    strip(A,'"')

    image

    or the replace function

    replace(A, '"', "'")

    image

     

    Basically the single and double quotes are interchangeable.  You just need to make sure you match the enclosing characters.

     

     

     

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited February 2023
    Hi Amanda,

    Is this the Amanda Hamm from the Monarch case study for Public Service Credit Union (PSCU)? If so that is awesome! Nice to meet you.

    If Chris’s suggestion doesn’t work depending on your needs, I’d be delighted to help you take a look at that file together today or next week, whichever works for you. Let me know.

    Best Regards,

    Baba

  • Amanda Hamm
    Amanda Hamm Altair Community Member
    edited February 2023

    Hi Chris!  In all my years using Monarch, I did not know this.  Geez.  Thank you very much for your fast reply!

    Amanda

  • Amanda Hamm
    Amanda Hamm Altair Community Member
    edited February 2023
    Baba Majekodunmi_21731 said:

    Hi Amanda,

    Is this the Amanda Hamm from the Monarch case study for Public Service Credit Union (PSCU)? If so that is awesome! Nice to meet you.

    If Chris’s suggestion doesn’t work depending on your needs, I’d be delighted to help you take a look at that file together today or next week, whichever works for you. Let me know.

    Best Regards,

    Baba

    Hi Baba,

    LOL...yes, the same Amanda Hamm :-).  It is a pleasure to meet you as well!  

    Chris' suggestion should work great for me and I appreciate your offer to assist.

    Thank you for making me feel like a celebrity this morning...LOL!

    Have a great weekend,

    Amanda Hamm

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited February 2023
    Amanda Hamm said:

    Hi Baba,

    LOL...yes, the same Amanda Hamm :-).  It is a pleasure to meet you as well!  

    Chris' suggestion should work great for me and I appreciate your offer to assist.

    Thank you for making me feel like a celebrity this morning...LOL!

    Have a great weekend,

    Amanda Hamm

    Hi Amanda,

    You're very welcome. I've been looking forward to meeting yo for quite sometime now.

    Lets connect soon when you have a moment. We have a lot of complimentary resources that can specifically help you with your core systems; Fiserv DNA, Fiserv Optis/PSCU, Fiserv EFT, Visa DPS etc.

    Best Regards,

    Baba

Categories