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

ユーザー11852 · 2021-05-14T10:08:04+00:00

There was an error rendering this rich post.

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

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

タグが付けられた投稿をさらに検索

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.

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.

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.