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

user11651

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

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

 

https://www.w3resource.com/mysql/string-functions/mysql-instr-function.php

jaeW_at_Onyx

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

 

https://www.w3resource.com/mysql/string-functions/mysql-instr-function.php

jaeW_at_Onyx

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