SUBSTRING Query (9 day n00b question)

_DanielB_

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

ColemenWilson

SUBSTRING_INDEX(ID, '_', -1)

ColemenWilson

SUBSTRING_INDEX(ID, '_', -1)

_DanielB_

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

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