SUBSTRING Query (9 day n00b question)

_DanielB_
_DanielB_ Member
in Beast Mode

Hi

I've only been using Domo for about 9 days so still very new to this but I am trying to use the SUBSTRING function to return the values in my ID column to ignore everything before and including and underscore as this value varies in character size (example EN_, ENR_, ENO_)

How do I get the ID column to return the values after the _ ??

Thanks for any and all support

DanB

Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited January 17 Answer ✓

    SUBSTRING_INDEX(ID, '_', -1)

    Screen Shot 2025-01-17 at 12.46.26 PM.png

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited January 17 Answer ✓

    SUBSTRING_INDEX(ID, '_', -1)

    Screen Shot 2025-01-17 at 12.46.26 PM.png

    If I solved your problem, please select "yes" above

  • _DanielB_
    _DanielB_ Member

    Thank you @ColemenWilson - I'm currently undergoing a 'trial by fire which is on fire' and I'm still getting used to all the functions within Domo 😊

  • ColemenWilson
    ColemenWilson Coach

    Haha we all do! Let me know if I can help on anything else!

    If I solved your problem, please select "yes" above

Categories