My SQL Data FlowでのREGEXP_SUBSTR関数について

My SQL Data FlowでREGEXP_SUBSTR関数を使いたいのですが、「FUNCTION dataflow_schema.REGEXP_SUBSTRは存在していません」というエラーメッセージが出てしまいます。


Best Answer


  • Hi, jaeW

    Thank you for your comment.

    DOMO is MySQL v.5.6, isn't it?

    I resolved my issue using "Regex lookahead" and "Regex lookbehind" in MagicETL.

  • Yes, Domo is using MySQL v5.6 to process MySQL dataflows.

    Good job with Magic! Regex data cleansing will be much faster than any SQL implementation.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

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