Skip to content

    • Best Of

    Re: Magic Replace Text REGex, remove anything outside of delimiters

    Hi @Domofied

    If you have Magic ETL 2.0 you can use the regex_replace function to pass in processing flags - this isn't possible with the ETL 1.0 Replace Text tile. By default regex101 as the g (global) and m (multiline) flags enabled whereas Domo does not. Passing in the 'm' as the third parameter should resolve your issue.

    REGEXP_REPLACE(`note`, '^(?!Numbers:).*', '$1', 'm')


    Re: Magic Replace Text REGex, remove anything outside of delimiters

    if i had to solve this problem, i would ask myself:

    1) can i find the position of thte text "Numbers: "

    2) can i find the first New line character after the position ofthe text Numbers:

    3) can i keep the stuff in between?


    https://www.youtube.com/watch?v=oYcpYE7DiV4


    Re: Some useful Regex statements

    Hi @Domofied

    If you have Magic ETL 2.0 you can use the regex_replace function to pass in processing flags - this isn't possible with the ETL 1.0 Replace Text tile. By default regex101 as the g (global) and m (multiline) flags enabled whereas Domo does not. Passing in the 'm' as the third parameter should resolve your issue.

    REGEXP_REPLACE(`note`, '^(?!Numbers:).*', '$1', 'm')


    Re: Remotely trigger a DataSet refresh?

    Mind. Blown. Jae, that was excellent. I'm not exaggerating when I say that you've just radically shifted my feelings about Domo. Thanks for organizing that session, and thanks for sharing the link.

    Domo's attitude about discoverable-but-undocumented APIs is outstanding. I had no idea...I'm so used to corporate attitudes being hostile to that sort of thing. Kudos Domo!

    That tip about the different authentication methods for "Public" and "public" APIs is pure gold.

    I just updated my JavaCLI, and spotted the call I was thinking of, dataset-run-now...it was in the version I had, I just didn't see it. The docs are a little thin, but there's just a ton in that tool:

    https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool

    I tried it out about 9 months ago, following along with some of your other videos. We're hitting a point where UPSERT would make sense for us, if we can get it working, or PARTITION. We're using REPLACE now...but, big...and the APPEND options aren't a great match for us.

    Re: SAML Authentication in the Mobile App

    Thank you so much, @amehdad21 and @Ashleigh!

    Your comments have been a big help for me to understand that SAML authentication is possible for the mobile app.

    I imagine the screen transition is web view > SAML auth > (deep link) > mobile app, I will check it out when our SSO setup is completed.