mediumPayNet · textNew
Extract the failure reason from a DuitNow error message
PayNet logs every failed DuitNow transfer with an error_message like DN102: insufficient funds. For each failed transaction, extract just the reason text after the colon, trimmed of its leading space.
Return id, error_message, and failure_reason.
Schema
▸transactions
| id | INT |
| status | TEXT |
| error_message | TEXT |
Example input
▸transactions