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

ユーザー11852

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

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

jaeW_at_Onyx

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.

https://datacrew.circle.so/c/articles-and-knowledge-base/removing-non-alphanumeric-characters-from-strings-in-domo

jaeW_at_Onyx

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.

https://datacrew.circle.so/c/articles-and-knowledge-base/removing-non-alphanumeric-characters-from-strings-in-domo

ユーザー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

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.