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

ユーザー11852
ユーザー11852 ⚪️
in 仲間に相談

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

この関数には対応していないのでしょうか？

Best Answer

Answers

  • ユーザー11852
    ユーザー11852 ⚪️

    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.

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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"

Categories