How to find first non-zero number in TEXT data type in DoMo ETL (Not Beast Mode)
I have a business requirement where i need to find first non-zero number in a TEXT column which has leading zeros. The position of non-zero number is not fixed in text column.
Can Anyone help me to find logic for the same in Domo ETL?
Below is the example where i need to find whether the text begins with number 2 by ignoring leading zero's .
( Please Note - The data type is Text for below data )
Please assist me with the same.
All your help is appreciated.