Hello
I would like to retrieve/extract The Symbol from The following strings but unsure if possible.
Length and placement of symbol is always a bit different.
I have tried using MID LOOKUP LEN SEARCH but getting very bad results.
The symbol I would need is followed by the last "/" Sign and nothing more after the ":" of each string. (No :XCME)
I placed the desire result followed by the equal sign next to each string also Highlighted it.
Basically it will always be all that is written between the last "/" and last ":" of the string.
The data I need to extract from is over 5000 Rows.
SOLD -1 /ESM23:XCME 1/50 23 MAR 23 (Thursday) (Wk4) /E4DH23:XCME 4010 CALL @6.50 = /E4DH23
SOLD 4.0 /ESH22:XCME @4720.0 upon Assignment 4.0 /ESH22:XCME 1/50 31 DEC 21 (EOM) /EWZ21:XCME 4720 CALL = /EWZ21
SOLD -1 /ESM23:XCME 1/50 MAY 23 (Wk3) /EW3K23:XCME 4200 CALL @39.75 = /EW3K23
BOT +4 /ESM23:XCME 1/50 MAR 23 (Monday) (Wk5) /E4AH23:XCME 4035 CALL @7.00 = /E4AH23
SOLD -5 /ESM23:XCME 1/50 MAR 23 (Tuesday) (Wk5) /E4BH23:XCME 4015 CALL @15.00 = /E4BH23
SOLD -2 /ESM23:XCME 1/50 MAR 23 (Wednesday) (Wk5) /E5CH23:XCME 4030 PUT @10.50 = /E5CH23
BOT +1 /ESM23:XCME 1/50 JUN 23 (AM Settled) /ESM23:XCME 3500 PUT @25.00 = /ESM23
BOT +1 /ESM23:XCME 1/50 MAY 23 (Wk3) /EW3K23:XCME 3600 PUT @18.25 = /EW3K23
SOLD -1 /ESU23:XCME 1/50 JUL 23 (Wk3) /EW3N23:XCME 4200 PUT @225.75 = /EW3N2
SOLD -2 /ESM23:XCME 1/50 MAR 23 (Thursday) (Wk5) /E5DH23:XCME 4050 PUT @10.00 = /E5DH23
Using MS Office Excel 2019
Thank you for your help. It is greatly appreciated
Cheers
OP
I would like to retrieve/extract The Symbol from The following strings but unsure if possible.
Length and placement of symbol is always a bit different.
I have tried using MID LOOKUP LEN SEARCH but getting very bad results.
The symbol I would need is followed by the last "/" Sign and nothing more after the ":" of each string. (No :XCME)
I placed the desire result followed by the equal sign next to each string also Highlighted it.
Basically it will always be all that is written between the last "/" and last ":" of the string.
The data I need to extract from is over 5000 Rows.
SOLD -1 /ESM23:XCME 1/50 23 MAR 23 (Thursday) (Wk4) /E4DH23:XCME 4010 CALL @6.50 = /E4DH23
SOLD 4.0 /ESH22:XCME @4720.0 upon Assignment 4.0 /ESH22:XCME 1/50 31 DEC 21 (EOM) /EWZ21:XCME 4720 CALL = /EWZ21
SOLD -1 /ESM23:XCME 1/50 MAY 23 (Wk3) /EW3K23:XCME 4200 CALL @39.75 = /EW3K23
BOT +4 /ESM23:XCME 1/50 MAR 23 (Monday) (Wk5) /E4AH23:XCME 4035 CALL @7.00 = /E4AH23
SOLD -5 /ESM23:XCME 1/50 MAR 23 (Tuesday) (Wk5) /E4BH23:XCME 4015 CALL @15.00 = /E4BH23
SOLD -2 /ESM23:XCME 1/50 MAR 23 (Wednesday) (Wk5) /E5CH23:XCME 4030 PUT @10.50 = /E5CH23
BOT +1 /ESM23:XCME 1/50 JUN 23 (AM Settled) /ESM23:XCME 3500 PUT @25.00 = /ESM23
BOT +1 /ESM23:XCME 1/50 MAY 23 (Wk3) /EW3K23:XCME 3600 PUT @18.25 = /EW3K23
SOLD -1 /ESU23:XCME 1/50 JUL 23 (Wk3) /EW3N23:XCME 4200 PUT @225.75 = /EW3N2
SOLD -2 /ESM23:XCME 1/50 MAR 23 (Thursday) (Wk5) /E5DH23:XCME 4050 PUT @10.00 = /E5DH23
Using MS Office Excel 2019
Thank you for your help. It is greatly appreciated
Cheers
OP