Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

regex_substring

I have this in a calculation component:
REPLACE (
REGEXP_SUBSTR (
"system_info", 'Hostname: pixhd[0-9]{1,4}/i'
),
'Hostname: ', ''
)

How do I make that regex case insensitive? Any help is appreciated!

1 Community Answers

Matillion Agent  

Dan D'Orazio —

Hi Dan -

The Posix Operators AWS support page should provide some insights into this, I believe using the [[:upper:]] or [[:lower:]] operators in conjunction with a similar LOWER or UPPER function on your source column.

Best -
Dan

Post Your Community Answer

To add an answer please login