0

Expression to extract text in a string to the right after a dash character

I need to extract text in strings (product labels) after a dash character. An example string: Pavé Nameplate Necklace - "ADHD". Ideally, the result would be ADHD, but "ADHD" works as well, since I will use the extracted text to sort alphabetically. 

I'm avoiding extracting text between quote marks since many of the label-strings have inconsistent straight-quote marks and smart-quotes marks --but maybe an expression can account for the different quote mark styles.

Thanks in advance!

Bob

33 replies

null
      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr agoThu, March 21, 2024 at 7:19 PM UTC
      • Reported - view

      try:

      replace(substr(YourTextField, index('Text 2', "-") + 1), """", "")

        • Ninox partner
        • RoSoft_Steven.1
        • 1 yr agoFri, March 22, 2024 at 5:31 AM UTC
        • Reported - view

        https://docs.ninox.com/en/script/functions-overview/functions/replace

        • Fred
        • 1 yr agoFri, March 22, 2024 at 1:27 PM UTC
        • Reported - view

         Weird, I swear when I searched the docs for replace nothing showed up. Now it does.

      • bflack
      • 1 yr agoThu, March 21, 2024 at 9:24 PM UTC
      • Reported - view

      This works great when the labels have straight-quotes, but sometimes there are smart-quotes (curled marks). Is there a way to cover for both to avoid editing hundreds of labels?

        • bflack
        • 1 yr agoThu, March 21, 2024 at 9:36 PM UTC
        • Reported - view

         Here's a screen shot of the script applied to Trying or TRYING labels. The top one had straight quotes and came out right. The next two had leading curly quotes and ending straight quotes. I assume I'm correctly identifying the leading quotes as "curly". Please correct me if I'm wrong.

        • Ninox partner
        • RoSoft_Steven.1
        • 1 yr agoThu, March 21, 2024 at 9:40 PM UTC
        • Reported - view

         

        with an extra replace i guess:

        let txt := replace(substr(YourTextField, index(YourTextField, "-") + 1), """", "");
        txt := replace(txt,""","");
        txt

        where the middle one " of the """ is a curly quote. I can't type here one on my ipad right now....

      • bflack
      • 1 yr agoThu, March 21, 2024 at 9:51 PM UTC
      • Reported - view

      This is sooo close. Definitely solved the left curly quote, but there are also a few right curly quotes. 

        • bflack
        • 1 yr agoThu, March 21, 2024 at 9:55 PM UTC
        • Reported - view

         Nailed it! See below ...

        let txt := replace(substr(Item, index(Item, "-") + 1), """", "");
        txt := replace(txt, "“", "");
        txt := replace(txt, "”", "");
        txt

        Many thanks !!

        Bob

      • Sean
      • 1 yr agoFri, March 22, 2024 at 1:47 AM UTC
      • Reported - view

      This one-liner works with the example given.

      extractx(YourTextField, "(?:""|“)(\w+)(?:""|”)", "$1")
    Login to reply

    Content aside

    Categories

    View all topics
    • Status Answered
    • 1 yr agoFri, March 22, 2024 at 1:27 PM UTCLast active
    • 33Replies
    • 521Views
    • 5 Following