17 апр. 2023 г. · I'm trying to use the REGEXP_SUBSTR method in Snowflake to extract a string after the period. I have the following possibilities:

20 сент. 2021 г. · I am trying to extract all of the ItemCodes as a new column. In this case it is "Platform" and it could be alphanumeric in other cases. I know I ...

13 нояб. 2020 г. · I have an long string with the syntax 'item_name (price + tax), item_name (price + tax), item_name (price +tax)' that I want to get into the rows.

I am currently using the following code to be able to do an intelligent text search between two tables, none of the tables have any relationship that joins ...

16 июн. 2023 г. · I have a Snowflake table with a column containing the values [6326.72, -548.99, -80.29]. I need to create three new columns, col1 with a value ...

8 мар. 2022 г. · I tried the following and not getting the results as the output is coming along with the parenthesis. select REGEXP_substr("/Date(-34905600000)/ ...

18 февр. 2021 г. · I have the following string: 'AAA|BBB||CCC|1.23' I would like to return: 'CCC|1.23' When using the regexp: \w+\|\d(.\d+|$) I am able to get

10 дек. 2021 г. · If regexp is not a must, then SPLIT_PART does the job: SELECT SPLIT_PART('98547279->ABCD->2554785->DEFT', '->', 1) AS result -- ABCD.

30 дек. 2022 г. · Can someone help me fetch "Client name" using regexp_substr from below path in Snowflake. The client names here can have spaces or underscores.

15 сент. 2020 г. · I'm looking for alternatives for position, occurrence and regex parameters which are supported by Snowflake's REGEXP_SUBSTR.