Thread: Extract numeric and char from string!

Hello...

I need some help here. I am doing data validation now to check the size and the unit of the size code.

Example: TB C10 GEL 125ml

I have the data as above. I wanted to extract the 125ml out. But for the function I created, I got the results of 10gm instead of 125ml. So I just wondering is there any solutions for that. I wanna extract the 125ml without the space exist. The function can be viewed under the attachment in alt+F11

Thanks for yr help! Hope to find a kind person to help me out here! Thanks!

hi..thanks for yr help!

It is great to c some of the problems is solved. But I found out got one error. The function does not extract unit and size as the following example:

C10 GEL E/HOLD S1.00 125M
S.STICK 24/7 GEL ICY SURGE LARGE CS SP
2in1 Liquid Gel LDT Outburst 120g X 72

Some of the example does not give me the expected results. When I try to extract the "120g" from the example above, it dun allow me to use the function and keep on saying my code got error. I just wondering is there any efficient way to modify the function to make it useful? I really need help on these. Thanks you! By the way, your code is great. Hehe! Thank alot!

For more info, pls refer the attachment. Thanks!!