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

ユーザー11852 · 5月 2021

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

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

jaeW_at_Onyx · 5月 2021

This is MySQL v 5.6 which didn't include many of the regex functions.

if you're trying to do regex replace, consider this article.

jaeW_at_Onyx · 5月 2021

This is MySQL v 5.6 which didn't include many of the regex functions.

if you're trying to do regex replace, consider this article.

ユーザー11852 · 5月 2021

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 · 5月 2021

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.

ベストアンサー