Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Get text after a specific word

soncoku
9 - Comet

Hey everyone.

I have a bank statement from which I need to copy the currency: and Name of Account:

 

As you can see in the picture they are both in the same column.
I want to copy what's after Currency: EUR

and also what's after Name of Account : Company name.

 

Then add the currency value EUR to a new column called Currency
and Name of account value Company name to a new column called Account

 

soncoku_0-1592551848937.png

 

 

 

4 REPLIES 4
LordNeilLord
15 - Aurora

Hey @soncoku 

 

The easiest way would be to use text to columns and use : as the delimiter

 

Or you could do some regex like Currency:(.*) to parse everything after the colon 

 

Capture.JPG

soncoku
9 - Comet

@LordNeilLord 

I am stuck at this point:
Currency:(.*)

because I want it to go all the way down, till the end of the column.

Currency: EUR

      
Name of the account: The Company      
DateTransaction IDReceiverTranasction TypeAmountAccountCurrency
11/11/2011    The CompanyEUR
     The CompanyEUR
     The CompanyEUR
     The CompanyEUR

 

So Two new columns should be created and they should continue till the end of these rows.

danilang
19 - Altair
19 - Altair

Hi @soncoku 

 

To copy the values down, you can use a Multi-Row tool for each of the columns.  

 

Dan

echuong1
Alteryx Alumni (Retired)

Does the attached work for you?

 

Essentially, I used text to columns to parse out the currency and account values. From there, I used multirow formulas to drag down the currency and account values. A select tool finishes it to clean up the columns!

 

echuong1_0-1592574684441.png

 

Labels