Parsing out account number from description text

[tiverson]

I have a statement that lists transactions by date, by account

I am trying to pull out the account number from the Payment details column and assign it to the amount listed right above it.

Thanks! 

[gabrielvilella · Accepted solution]

Hey @tiverson, this was a good challenge. Here it is how I did it.