Hi,
As noted I am looking to extract a unique ID from a string of data using a function to create a new column called "Transaction ID". Each transaction ID is embedded in the description column and contains the first letters of "id:trxn:" and then subsequent numbers/letters as shown below. What can I use to do this?
| Account | ChkRef | Debit | Credit | Balance | Date | Description |
| 1234567910 | | 1,200,000.00 | | -1,200,000.00 | 9/01/2024 | Outgoing Wire ABCD Peach id:trxn4pqPK792a90HGA901j3lPo9Ha1s |
| 1234567910 | | 2,343,997.00 | | -2,343,997.00 | 9/02/2024 | Outgoing Wire EFGH Pear id:trxn4pqzb1qqRy7fcghTQj5Qd1pFbWD |
| 1234567910 | | 1,231,829.00 | | -1,231,829.00 | 9/03/2024 | Outgoing Wire IJKL Apple id:trxn4pqGdXYAw2kJtlMd39aENjjlMI |
| 1234567910 | | 3,457,482.00 | | -3,457,482.00 | 9/04/2024 | Outgoing Wire MNOP Hen id:trxn4pqcUmWWgWZaBJXidPvlksHZmcx |
Note - data used in this is false for illustrative purposes only!
