I have a string in Snowflake. I want to extract the numbers after this keyword: “SCHED-MIN-PYMT_AMT:”. The numbers are with 2 decimal points. I tried this and it returns null:
<code>select regexp_substr(column, 'SCHED-MIN-PYMT_AMT:s*(d+.d{2})', 1, 1, 'i', 1) AS MIN_DUE
from table;
</code>
<code>select regexp_substr(column, 'SCHED-MIN-PYMT_AMT:s*(d+.d{2})', 1, 1, 'i', 1) AS MIN_DUE
from table;
</code>
select regexp_substr(column, 'SCHED-MIN-PYMT_AMT:s*(d+.d{2})', 1, 1, 'i', 1) AS MIN_DUE
from table;
How can I fix this?
1