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

Reply
Highlighted
Yellow Belt

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 ----> Asx@par

Character who's position is required is @

Ans = 4

 

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

Thanks in Advance.

 

 


Accepted Solutions
Highlighted
Black Belt

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

 

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


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Highlighted
Black Belt

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

 

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


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Highlighted
Black Belt

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


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.