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

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 ----> [email protected]

Ans = 4

 

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

Thanks in Advance.

 

 

Best Answer

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

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