troubleshooting Question

Using Excel VBA to decode data.

Avatar of Zack
ZackFlag for Canada asked on
Microsoft ExcelProgramming
8 Comments1 Solution1590 ViewsLast Modified:
I need help decoding this data.  Unfortunately it isn't comma or tab delimited.  Each line is a new line and needs to be decoded.  I've been using inStr but there is a section of weather events I'm not sure what is the way to search through the string to find the various events...  Some of the trouble is the qualifier that has no sign (moderate).  There are some examples in the .xls file I included...
Sometimes its -SN, -SHSN, -VCSG

I'm gonna lose my mind lol...


QUALIFIER: Intensity or Proximity
"-" Light       "no sign" Moderate       "+" Heavy
VC Vicinity: but not at aerodrome. Between 5 and 10SM of the point(s) of observation
MI Shallow       BC Patches       PR Partial       TS Thunderstorm
BL Blowing       SH Showers       DR Drifting       FZ Freezing
DZ Drizzle       RA Rain       SN Snow       SG Snow grains
IC Ice crystals       PL Ice pellets       GR Hail       GS Small hail/snow pellets
UP Unknown precipitation in automated observations
BR Mist(>= 5/8SM)       FG Fog(< 5/8SM)       FU Smoke       VA Volcanic Ash
SA Sand       HZ Haze       PY Spray       DU Widespread dust
SQ Squall       SS Sandstorm       DS Duststorm       PO Well developed dust/sand whirls
FC Funnel cloud       +FC tornado/waterspout


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros