We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parsing tool Regex

Tommy23
7 - Meteor

Hello,

 

I am trying to get some information inside the columne “ value” and put it in other column.

 

Source:

 

transaction numbervalue
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 numberPayment method descriptionPayment method description
4670American Express US$ => American Express US$Cash US$
4678VISA 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!!

3 REPLIES 3
binuacs
20 - Arcturus

@Tommy23 One way of doing this

image.png

ed_hayter
12 - Quasar

With one regex tool that captures the desired outcome

 

image.png

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

image.png

FinnCharlton
13 - Pulsar

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

 

image.png

Labels