Comments by Buddy Farrell

Buddy Farrell 15-May-13 20:57pm View

This got me in the right direction, and solved MANY of my out-standing's. I had to do some modifications: sometimes all are in (), sometimes there are spaces not expected, the degree symbol is completely not standard so I had to look for the strange ones, I found other extraneous ways of saying "to", such as through, and, --, etc. But I thank you VERY much.

Also, while 98 or so % give are C the F, some are F/C. So, if either is found, I would like to know which set of numbers I am dealing with!

I now am working on the ones that don't give a range and simply state "above", "below", etc. My main prob is I need the Negative numbers (I need that minus sign). I also need to know, if it was given, whether it was in C or F. Can you point me in the general direction of how to output variable/not required data? That way I can capture the C/F/- and work from there. This is all new to me, but I am competent in programming.

Buddy Farrell 15-May-13 2:21am View

Thanks Damian,
I did not notice the reply option so there are some comments and an excellent suggestion by another member!

Buddy Farrell 15-May-13 2:20am View

Thanks Prasad,
I've been commenting and did not notice the reply option. I will try this and see if it is a step forward for me!

Buddy Farrell 15-May-13 2:14am View

Also, @Prasad, I already have Expresso and that is how I will test before coding....

Buddy Farrell 15-May-13 2:12am View

To give you even more context, I THEN need to decide, based upon the number and temperature identifier, if it is "room temp" or "refrigeration". i.e., 2°C is refrigeration, but 30°C is not. I will tackle that After.

Buddy Farrell 15-May-13 2:10am View

I will certainly try that tomorrow!!! Thanks, I am not looking for lessons on data management, but the ability to parse this crappy data. Believe me, I've parsed and created decisions based on a lot of factors. It is only when certain keywords (freeze, refrigerate, room temperature, all varieties there-of, etc) are not included and I am left ONLY with a range or single number [but have been able to isolate the sentence based on other keywords] that I have been stumped, because it is in free-text and I see a huge variety of factors as described. I will let you know if that expression helps.

that said, anybody else can pipe in too!

Thanks Prasad!

Buddy Farrell 15-May-13 2:02am View

I see it as completely a regEx issue, if it can be tackled at all.

Buddy Farrell 15-May-13 1:56am View

Damian,
The data is coming from XML documents out of my control. This is not an issue of poor internal data management. I need to parse these documents and try to make sense of them. The source is the US government.

Comments by Buddy Farrell (Top 8 by date)