Spreadsheet: 786284d1657094487-extracting-a-value-from-a-long-string-using-left-right-mid-voorbeeldblad
Sheet: Blad1

 |  |  | Column1 | NewColumn.Merged
Jun 26, 2022 9:42:52 AM 55 LOAN DEPOSIT 20.70 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 9:42:52 AM 55 LOAN DEPOSIT 20.70 EUR SUCCESS_USER_O | 20.70 EUR |  |  |  | <- Need this to show €20,70
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:4:8 |  |  | Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O | 0.00 EUR
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  | REDACTED c1010-1 REDACTED:4:8 | value |  |  |  | <- Need this to show €0,00
PERATION |  |  | Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O | 0.00 EUR
REDACTED appos-1 REDACTED:22:62 |  |  | Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 50.00 EUR SUCCESS_USER_O | 50.00 EUR
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  | PERATION | value |  |  |  | <- Need this to show €0,00
PERATION |  |  | Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O | 0.00 EUR
REDACTED c1010-1 REDACTED:22:62 |  |  | REDACTED appos-1 REDACTED:22:62 | value
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 50.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:01:35 AM 55 PAYMENT DISPENSE -5.00 EUR SUCCESS_USER_O | -5.00 EUR |  |  |  | <- Need this to show €50,00
PERATION |  |  | Jun 26, 2022 11:01:35 AM 55 PAYMENT DISPENSE -3.10 EUR SUCCESS_USER_O | -3.10 EUR
REDACTED appos-1 REDACTED:22:62 |  |  | PERATION | value
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  | REDACTED c1010-1 REDACTED:22:62 | value |  |  |  | <- Need this to show €0,00
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:22:62 |  |  | REDACTED appos-1 REDACTED:22:62 | value
Jun 26, 2022 11:01:35 AM 55 PAYMENT DISPENSE -5.00 EUR SUCCESS_USER_O |  |  | PERATION | value |  |  |  | <- Need this to show -€5,00
PERATION |  |  | REDACTED c1010-1 REDACTED:22:62 | value
REDACTED appos-1 REDACTED:22:62 |  |  | PERATION | value
Jun 26, 2022 11:01:35 AM 55 PAYMENT DISPENSE -3.10 EUR SUCCESS_USER_O |  |  | REDACTED appos-1 REDACTED:22:62 | value
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:22:62 |  |  | REDACTED c1010-1 REDACTED:22:62 | value
Jun 26, 2022 11:10:22 AM 55 PAYMENT DEPOSIT 1,760.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:10:22 AM 55 PAYMENT DEPOSIT 1,760.00 EUR SUCCESS_USER_O | 1,760.00 EUR
PERATION |  |  | PERATION | value
REDACTED appos-1 REDACTED:26:147 |  |  | REDACTED appos-1 REDACTED:26:147 | value
Jun 26, 2022 11:10:22 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:10:22 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O | 0.00 EUR
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:26:147 |  |  | REDACTED c1010-1 REDACTED:26:147 | value
Jun 26, 2022 11:15:52 AM 55 PAYMENT DEPOSIT 70.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:15:52 AM 55 PAYMENT DEPOSIT 70.00 EUR SUCCESS_USER_O | 70.00 EUR
PERATION |  |  | PERATION | value
REDACTED appos-1 REDACTED:27:38 |  |  | REDACTED appos-1 REDACTED:27:38 | value
Jun 26, 2022 11:15:52 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:15:52 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O | 0.00 EUR
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:27:38 |  |  | REDACTED c1010-1 REDACTED:27:38 | value
Jun 26, 2022 11:15:52 AM 55 PAYMENT DISPENSE -10.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:15:52 AM 55 PAYMENT DISPENSE -10.00 EUR SUCCESS_USER_O | -10.00 EUR
PERATION |  |  | PERATION | value
REDACTED appos-1 REDACTED:27:38 |  |  | REDACTED appos-1 REDACTED:27:38 | value
Jun 26, 2022 11:15:52 AM 55 PAYMENT DISPENSE -1.55 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:15:52 AM 55 PAYMENT DISPENSE -1.55 EUR SUCCESS_USER_O | -1.55 EUR
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:27:38 |  |  | REDACTED c1010-1 REDACTED:27:38 | value
Jun 26, 2022 11:59:36 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:59:36 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O | 0.00 EUR
PERATION |  |  | PERATION | value
REDACTED appos-1 REDACTED:43:18 |  |  | REDACTED appos-1 REDACTED:43:18 | value
Jun 26, 2022 11:59:36 AM 55 PAYMENT DEPOSIT 1.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:59:36 AM 55 PAYMENT DEPOSIT 1.00 EUR SUCCESS_USER_O | 1.00 EUR
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:43:18 |  |  | REDACTED c1010-1 REDACTED:43:18 | value
Jun 26, 2022 11:59:36 AM 55 PAYMENT DISPENSE -0.50 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 11:59:36 AM 55 PAYMENT DISPENSE -0.50 EUR SUCCESS_USER_O | -0.50 EUR
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:43:18 |  |  | REDACTED c1010-1 REDACTED:43:18 | value
Jun 26, 2022 12:07:45 PM 55 PAYMENT DEPOSIT 50.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 12:07:45 PM 55 PAYMENT DEPOSIT 50.00 EUR SUCCESS_USER_O | 50.00 EUR
PERATION |  |  | PERATION | value
REDACTED appos-1 REDACTED:45:24 |  |  | REDACTED appos-1 REDACTED:45:24 | value
Jun 26, 2022 12:07:45 PM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 12:07:45 PM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O | 0.00 EUR
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:45:24 |  |  | REDACTED c1010-1 REDACTED:45:24 | value
Jun 26, 2022 12:07:45 PM 55 PAYMENT DISPENSE -10.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 12:07:45 PM 55 PAYMENT DISPENSE -10.00 EUR SUCCESS_USER_O | -10.00 EUR
PERATION |  |  | PERATION | value
REDACTED appos-1 REDACTED:45:24 |  |  | REDACTED appos-1 REDACTED:45:24 | value
Jun 26, 2022 12:07:45 PM 55 PAYMENT DISPENSE -1.00 EUR SUCCESS_USER_O |  |  | Jun 26, 2022 12:07:45 PM 55 PAYMENT DISPENSE -1.00 EUR SUCCESS_USER_O | -1.00 EUR
PERATION |  |  | PERATION | value
REDACTED c1010-1 REDACTED:45:24 |  |  | REDACTED c1010-1 REDACTED:45:24 | value