I need to extract from a memo style just the shipping information in US pounds.
Shipping (Package) Weight: 0.28 kg [0.62 lb]
One of my attempts was to use this query:
Shipping (Package) Weight: Mid([Technical],InStr(1,[Technical],"]",1)+1,Len([Technical])-(InStr(1,[Technical],"lb ] ",1)+1))
However, this does not seems to work. Can anyone help me to select just the information between [ lb ]. I do not need the brackets before or after.
Thanks