Hello,
I am trying to get some information inside the columne “ value” and put it in other column.
Source:
| transaction number | value |
| 4670 | Installment number : 1 => 1
Payment method : AEU => AEU
Payment method description : American Express US$ => American Express US$
Collected currency amount : 2220 => 2200
Counter - cash currency : USD => USD
Installment amount : 2220 => 2200
Due date : 3/20/2014 => 3/20/2014 New line
Installment number : 2
Payment method : ESD
Payment method description : Cash US$
Collected currency amount : 20
Counter - cash currency : USD
Installment amount : 20
Due date : 3/20/2014 |
| 4678 | Installment number : 1 => 1
Payment method : Visa => Visa
Payment method description :VISA US$ => VISA US$
Collected currency amount : 2220 => 2200
Counter - cash currency : USD => USD
Installment amount : 220 => 220
Due date : 3/20/2016 => 3/20/2016 New line
Installment number : 2
Payment method : ESD
Payment method description : Cash US$
Collected currency amount : 20
Counter - cash currency : USD
Installment amount : 20
Due date : 3/20/2016 |
I would like the output to be
| transaction number | Payment method description | Payment method description |
| 4670 | American Express US$ => American Express US$ | Cash US$ |
| 4678 | VISA US$ => VISA US$ | Cash US$ |
I am trying to use the regex parsing tool but when I do (.*)(Payment method description)(.*) it only take the last one of payment method description, but I want both of information that it is contain inside the cell. This table are just example my dataset have multiple row.
Thanks in advance!!
