Parse string field - multiple columns with text and digits

[AdenJAlt]

Hi 

I would like to parse a string field obtained from transaction statement into various components. For example the following string: "Bought Woolworths Holdings Limited 14.9276 @ 6,699.00 With Price Limit <= 6,700.00"

Output should give me the following additional fields:

1) Stock

2) Number of shares

3) Price per a unit

Date	Description	Value	Stock	Number of shares	Price per unit
2022/11/18	Bought Woolworths Holdings Limited 14.9276 @ 6,699.00 With Price Limit <= 6,700.00	-1000	Woolworths Holdings Limited	14.9276	6,699.00

[Kakuffo]

hi @AdenJAlt  this is a perfect job for the regex tool.

[ShankerV]

Hi @AdenJAlt 

Will all the inputs for huge data set will follow the same format?

Many thanks

Shanker V

[AdenJAlt]

Yes, the data set would just be "Bought" transactions. The data set includes the following fields:

Date

Description

Value

The syntax of Description field will consistently follow as: "Bought [Stock xx] [Units bought xx] @ [Price]". There is often additional text after the price if a specific buy instruction was included, however I am not too interested in that.

[binuacs]

@AdenJAlt One way of doing this