I'm using SAS regular expressions to read a large text file with numbers and characters, and may be up to 500 lines of text in the file. I would like to extract certain key words, specifically, weight quantaties and measures, i.e. kilos or lbs.
Each line of text is very long and may contain multiple occurences of the information I want. I want to capture one or more occurance depending on the substance of interest, and print out a table of the substances and weights to an output file.
"11/01 120 lbs of sugar was found in the room across the hall. The next day we also found a sizeable amount of 5000lbs of glue, and yesterday we may find even more lb 100X".
I need a detailed sas code, also if anyone knows VBS or Python, that would be very helpful.
Thanks in advance,