Parsing tool Regex

[Tommy23]

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!!

[binuacs · Accepted solution]

@Tommy23 One way of doing this

[ed_hayter · Accepted solution]

With one regex tool that captures the desired outcome

Looks for the first two payment method description lines and returns them in two columns

[FinnCharlton · Accepted solution]

Hi @Tommy23 , here are some RegEx methods, using the Parse and the Tokenize options: