I'm Emmanuel Katto from Dubai, I have a paragraph that contains various numbers in different sentences, and I want to extract those numbers and list them in a column in a new table. Here’s the text:
"The bags are weighed on a mobile scale at storage location. Each 5. bag is spear sampled. The primary sample of A: 10 kg, B: 20 kg, C: 30 kg, 40 kg and E: 50 kg was dried for 24 hours at 105 C. The sample was subject to repeated splitting, leaving some 800-1000 grams which was further milled to pass a 100-mesh test sieve. The crushed sample is blended in a V-blender for 20 minutes and transferred to 100 ml waterproof plastic bottle and sealed."
The number of different primary samples can vary from 1 to 20 or 30.
I’d really appreciate any guidance or a script to help me achieve this. I tried using Copilot, but I didn’t get the results I needed. Thanks a lot!
Regards
Emmanuel Katto
