Parse string field - multiple columns with text and digits

Question

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

DateDescriptionValueStockNumber of sharesPrice per unit2022/11/18Bought Woolworths Holdings Limited 14.9276 @ 6,699.00 With Price Limit <= 6,700.00-1000Woolworths Holdings Limited14.92766,699.00

binu_acs · Answer

@AdenJAlt One way of doing this

Regex_1121.yxmd

AdenJAlt · Answer

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

DateDescriptionValue

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.

ShankerV · Answer

Hi @AdenJAlt

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

Many thanks

Shanker V