How to find position of string in Simple Domo ETL ( NOT in Beast Mode)

user11651 · October 2020

Hi All,

I have requirement where i need to find a position of character in Domo ETL (Not Beast Mode).

Can anybody assist me on this?

Below is the example

String ----> Asx@par

Ans = 4

The symbol @ can come anywhere in input string so i need to find it's position.

Thanks in Advance.

jaeW_at_Onyx · October 2020

If you have a google, Instr() will be an easy MySQL equivalent.

jaeW_at_Onyx · October 2020

If you have a google, Instr() will be an easy MySQL equivalent.

jaeW_at_Onyx · October 2020

Also if you have Magic 2.0 (beta, talk to your CSM) you can use INSTR() in the Formula tile.

Best Answer