我正在尝试在Google Data Studio中删除日期字段周围的方括号，以便将其正确地视为正确的日期维度。
看起来像这样：
[2020-05-20 00:00:23]
and I am using the RegEx of REGEXP_REPLACE(Date, "/[\[\]']+/g", "") and I want it to look like this for the output:
2020-05-20 00:00:23
It keeps giving me error results and will not work. I can not figure out what I am doing wrong here, I've used https://www.regextester.com/ to verify that it should work
You need to use a plain regex pattern, not a regex literal notation (
/.../g).Note that
REGEXP_REPLACEremoves all occurrences found, thus, there is no need for agflag.采用
to remove all square brackets in
Date.Regarding Dates, it can be achieved with a single TODATE Calculated Field:
然后可以根据需要设置日期类型：
Google Data Studio Report and GIF to elaborate: