Get text after a specific word

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

Workflow

Regex

Expression

Accepted answers

echuong1

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!

New Workflow5.yxmd

All comments

LordNeilLord

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

soncoku

@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
Date	Transaction ID	Receiver	Tranasction Type	Amount	Account	Currency
11/11/2011					The Company	EUR
					The Company	EUR
					The Company	EUR
					The Company	EUR

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

echuong1

Does the attached work for you?

New Workflow5.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703