using System;

using System.Xml.Serialization;

using System.IO;

using System.Data;

using System.Linq;

using System.Data.DataSetExtensions;

public class Program

{

    public static void Main()

    {

                //Corrected Date Format in string

                string test = @"1,FARM PRODUCTS

11,   FIELD CROPS

112,      COTTON,RAW

1131,         BARLEY

1132,         CORN, EXCEPT POPCORN

1133,         OATS

1134,         RICE, ROUGH

1135,         RYE

1136,         SORGHUM GRAINS

1137,         WHEAT, EXCEPT BUCKWHEAT

1139,         GRAIN, NEC

114,      OIL SEEDS, NUTS & KERNELS

1144,         SOYBEANS

115,      FIELD SEEDS, EXC OIL SEEDS

119,      MISCELLANEOUS FIELD CROPS

1193,         LEAF TOBACCO

1195,         POTATOES, OTHER THAN SWEET

1197,         SUGAR BEETS

12,   FRESH FRUITS AND TREE NUTS

121,      CITRUS FRUITS

122,      DECIDUOUS FRUITS

1221,         APPLES

1224,         GRAPES

1226,         PEACHES

123,      TROPICAL FRUITS, EXC CITRUS

1232,         BANANAS

129,      MISC FRESH FRUITS AND NUTS

1295,         COFFEE, GREEN

13,   FRESH VEGETABLES

131,      BULBS, ROOTS & TUBERS

1318,         ONIONS, DRY

133,      LEAFY FRESH VEGETABLES

1334,         CELERY

1335,         LETTUCE

134,      DRY RIPE VEG SEEDS, ETC

1341,         BEANS, DRY RIPE

1342,         PEAS, DRY

139,      MISC. FRESH VEGETABLES

1392,         WATERMELONS

1394,         TOMATOES

1398,         MELONS, EXCEPT WATERMELONS

14,   LIVESTOCK AND LIVESTOCK PRD

141,      LIVESTOCK

1411,         CATTLE

1413,         SWINE, BOARS, HOGS

1414,         SHEEP AND LAMBS

142,      DAIRY FARM PRODUCTS

143,      ANIMAL FIBERS

1431,         WOOL

15,   POULTRY AND POULTRY PRODUCTS

151,      LIVE POULTRY

152,      POULTRY EGGS

19,   MISCELLANEOUS FARM PRODUCTS

191,      HORTICULTURAL SPECIALTIES

192,      ANIMAL SPECIALTIES

8,FOREST PRODUCTS

84,   GUMS AND BARKS, CRUDE

8423,         LATEX AND ALLIED GUMS

86,   MISCELLANEOUS FOREST PROD.

9,FRESH FISH & MARINE PRD

91,   FRESH FISH & MARINE PRD

912,      FISH & WHALE PRD INC FRZN

9131,         SHELLS (OYSTER,CRAB,ETC.)

98,   FISH HATCHERIES, FARMS

10,METALLIC ORES

101,   IRON ORES

10112,         BENEFICIATING GRADE ORE

102,   COPPER ORES

103,   LEAD AND ZINC ORES

1031,      LEAD ORES

1032,      ZINC ORES

104,   GOLD AND SILVER ORES

105,   BAUXITE AND ALUMINUM ORES

106,   MANGANESE ORES

107,   TUNGSTEN ORES

108,   CHROMIUM ORES

109,   MISCELLANEOUS METAL ORES

11,COAL

111,   ANTHRACITE

11111,         RAW ANTHRACITE

11112,         CLEANED OR PREP. ANTH.

112,   BITUMINOUS COAL AND LIGNITE

1121,      BITUMINOUS COAL

13,CRUDE PETRO, NAT GAS & GSLN

131,   CRUDE PETROLEUM AND NAT.GAS

132,   NAT.GASOLINE

14,NONMETALLIC MINERALS

141,   DIMENSION STONE, QUARRY

142,   CRUSHED AND BROKEN STONE

14211,         AGRICULTURAL LIMESTONE

14212,         FLUXING STONE OR LIMES

14219,         CRUSHED AND BROKEN STONE

144,   SAND AND GRAVEL

14411,         SAND (AGGREGATE AND BALLAST)

14412,         GRAVEL (AGGREGATE AND BALLAST)

14413,         INDUSTRIAL SAND, CRUDE

145,   CLAY, CERAMIC AND REFRACTORY

14511,         BENTONITE, CRUDE

14512,         FIRE CLAY, CRUDE

14514,         BALL AND KAOLIN CLAY, CRUDE

147,   CHEMICAL AND FERTILIZER MINERALS

14711,         BARITE (BARYTES), CRUDE

14713,         BORATE, POTASH AND SODA, CRUDE

14714,         APATITE AND PHOSPHATE ROCK

14715,         ROCK SALT, CRUDE

14716,         SULPHUR, CRUDE

149,   MISC NONMETALLIC MINERALS

14911,         ANHYDRITE AND GYPSUM, CRUDE

14913,         NATIVE ASPHALT AND BITUMENS

14914,         PUMICE AND PUMICITE, CRUDE

19,ORDNANCE AND ACCESSORIES

191,   GUNS, HOWITZERS, MORTARS

192,AMMUNITION, OVER 30 MM

193,   FULL TRACKED COMBAT VEHICLES

194,   SIGHTING AND FIRE CONTROL EQPT

195,SMALL ARMS, 30 MM AND UNDER

196,SM ARMS AMMUNITION, 30 MM, UNDER

199,   MISC ORDNANCE, ACCESS, PARTS

20,FOOD AND KINDRED PRODUCTS

201,   MEAT (INC POULTRY & SMALL GAME)

2011,      MEAT, FRESH OR CHILLED

2012,      MEAT, FRESH FROZEN

2013,      MEAT PRODUCTS

2014,      ANIMAL BY-PRODUCTS, INEDIBLE

20141,         HIDES, SKINS, NOT TANNED

2015,      DRSD POULTRY OR SML GAME, FRESH

2016,      DRSD POULTRY OR SML GAME, FRZN

2017,      PROCESSED POULTRY & SMALL GAME

202,   DAIRY PRODUCTS

2021,      CREAMERY BUTTER

2023,      CONDENSED, EVAPORATED, DRY MILK

2024,      ICE CREAM AND FROZEN DESSERTS

2025,      CHEESE & SPECIAL DAIRY PRODUCTS

2026,      PROCD WHOLE & SKIM MILK, CREAM

203,   CAN/PRSRVD FRUITS, VEG, SEA FD

2031,      CANNED AND CURED SEA FOODS

2032,      CANNED SPECIALTIES

2033,      CANNED FRUITS, VEGETABLES, JAMS

2034,      DRIED & DEHYD FRUITS & VEG

2035,      PKLD FRUITS & VEG, SAUCES

2036,      FRESH & FROZEN PACKAGED FISH

2037,      FRZN FRUITS, JUICES AND VEG

2038,      FROZEN SPECIALTIES

2039,      CANNED & PRESERVED FRUITS, VEG

204,   GRAIN MILL PRODUCTS

2041,      FLOUR AND OTHER GRAIN MILL PRD

20411,         WHEAT FLOUR, EXC BLENDED

20412,         WHEAT BRAN, MIDDLINGS OR SHORT

20421,         PREP ANIMAL FEED, EXC. PET

20423,         CANNED ANIMAL FEED EXC. PET

2043,      CEREAL PREPARATIONS

2044,      MILLED RICE, FLOUR AND MEAL

2045,      BLENDED AND PREPARED FLOUR

2046,      WET CORN MILLING PRD & BY-PRD

20461,         CORN SYRUP

20462,         CORN STARCH

20463,         CORN SUGAR

20471,         DOG, CAT & OTH PET FD EXC CAN

20472,         CANNED DOG, CAT & OTH PET FOOD

205,   BAKERY PRODUCTS

206,   SUGAR (BEET AND CANE)

2061,      SUGAR MILL PRODUCTS AND BY PRD

20611,         RAW CANE AND BEET SUGAR

20616,         SUGAR MOLASSES, EXC BLACKSTRAP

20617,         BLACKSTRAP MOLASSES

2062,      SUGAR, REFINED CANE AND BEETS

20625,         SUGAR REFINING BY-PRODUCTS

20626,         PULP, MOLASSES, BEET

207,   CONFECTIONERY AND RELATED PRD

208,   BEVERAGES AND FLAVORING EXTRACT

20821,         BEER, ALE, PORTER, STOUT

20823,         MALT EXTRACT AND BREWERS SPENT

2083,      MALT

2084,      WINES, BRANDY & BRANDY SPIRITS

20851,         DISTILLED & BLENDED LIQUORS

20859,         BY-PRD OF LIQUOR DISTILLING

2086,      BTLD & CANNED SOFT DRINKS, ETC.

2087,      MISC EXTRACTS EXC CHOCOLATE

209,   MISC FOOD PREPARATIONS

20911,         COTTONSEED OIL, CRUDE OR REF

20914,         COTTONSEED CAKE, MEAL & OTHER

20921,         SOYBEAN OIL, CRUDE OR REFINED

20923,         SOYBEAN CAKE, MEAL, FLR, GRITS

2093,      VEG & NUT OILS & BY-PRD

2094,      MARINE FATS AND OILS

2095,      ROASTED COFFEE, INC INSTANT

2096,      SHRNG, TABLE OILS, MRGN & OTH

2097,      ICE, NATURAL OR MANUFACTURED

2098,      MACARONI, SPAGHETTI, VERMICELLI

21,TOBACCO PRODUCTS

211,   CIGARETTES

212,   CIGARS

213,   CHEWING AND SMOKING TOBACCO

214,   STEMMED AND REDRIED TOBACCO

22,TEXTILE MILL PRODUCTS

221,   COTTON BROAD WOVEN FABRICS

222,   MAN MADE FIBER AND SILK

223,   WOOL BROAD WOVEN FABRICS

224,   NARROW FABRICS

225,   KNIT FABRICS

227,   FLOOR COVERINGS, TEXTILE

228,   YARN AND THREAD

229,   MISCELLANEOUS TEXTILE GOODS

2296,      TIRE CORD AND FABRICS

2297,      WOOL AND MOHAIR (SCRD ETC)

2298,      CORDAGE AND TWINE

23,APPAREL & OTHER FINISHED TEXTILE

231,   MENS AND BOYS CLOTHING

233,   WOMENS, GIRLS & INFANTS CLOTHING

235,   MILLINERY, HATS AND CAPS

237,   FUR GOODS

238,   MISC APPAREL & ACCESSORIES

239,   MISCELLANEOUS FABRICATED TEXTILE

24,LUMBER & WOOD PRODUCTS, EXC FURN

241,   PRIM FOREST PRD (PLPWD, PLNG)

24114,         PULPWOOD LOGS

24115,         PULPWOOD AND OTHER WOOD CHIPS

24116,         WOOD POSTS, POLES AND PILINGS

242,   SAWMILL AND PLANING MILL PRD

2421,      LUMBER AND DIMENSION STOCK

24212,         SAWED TIES (RAILROAD,MINE)

2429,      MISC SAWMILL & PLNG MILL PRD

243,   MILLWORK, VENEER, PLYWOOD

2431,      MILLWORK

2432,      VENEER AND PLYWOOD

244,   WOODEN CONTAINERS

249,   MISCELLANEOUS WOOD PRODUCTS

2491,      CREOSOTED OR OIL TREATED WOOD

25,FURNITURE AND FIXTURES

251,   HOUSEHOLD AND OFFICE FURNITURE

253,   PUBLIC BUILDING AND RLTD FURN

254,   PARTITIONS, SHELVING, LOCKERS

259,   MISCELLANEOUS FURNITURE AND FXTR

26,PULP, PAPER AND ALLIED PRODUCTS

261,   PULP AND PULP MILL PRODUCTS

26111,         PULP

262,   PAPER, EXCEPT BUILDING PAPER

26211,         NEWSPRINT

26212,         GROUND WOOD PAPER, UNCOATED

26213,         PRINTING PAPER

26214,         WRAPPING PAPER

26217,         SPECIAL INDUSTRIAL PAPER

26218,         SANITARY TISSUE STOCK

263,   PAPERBOARD, PULPBOARD & FIBERBRD

264,   CONVERTED PAPER & PAPERBRD PRD

2643,      PAPER BAGS

26471,         SANITARY TISSUES/HEALTH PRODS

265,   CONTAINERS & BOXES, PAPERBOARD

266,   BUILDING PAPER & BUILDING BOARD

26613,         WALLBOARD

27,PRINTED MATTER

271,   NEWSPAPERS

272,   PERIODICALS

273,   BOOKS

274,   MISCELLANEOUS PRINTED MATTER

276,   MANIFOLD BUSINESS FORMS

277,   GREETING CARDS, SEALS, LABELS

278,   BLANKBOOKS, LOOSELEAF BINDERS

279,   PRD OF SERVICE INDUSTRIES

28,CHEMICALS AND ALLIED PRODUCTS

281,   INDUSTRIAL CHEMICALS, ORG/INORG

2812,      SODIUM, PTSM, & OTH INORG CHEMS

28123,         SODIUM CPD, EXC ALKALIES

2813,      INDUSTRIAL GASES, COMPRESSED

2814,      CRUDE PRD FROM COAL TAR

2816,      INORGANIC PIGMENTS

2818,      MISC INDUSTRIAL ORG CHEMICALS

28184,         ALCOHOLS

2819,      MISC INDUSTRIAL INORG CHEMICALS

28193,         SULPHURIC ACID

282,   PLSTC MATERIALS & SYN RESINS

28212,         SYNTHETIC RUBBER

28213,         SYNTHETIC FIBERS

283,   DRUG (BIO PRD, MEDL CHEMS, ETC.)

284,   SOAP, DTRGNS, CLNG PREPS, CSMCS

2841,      SOAP & OTH DTRGNS EXC SPECIALTY

285,   PAINTS, VRNSHS, LACQUERS, ENAMEL

286,   GUM AND WOOD CHEMICALS

287,   AGRICULTURAL CHEMICALS

2871,      FERTILIZERS

289,   MISCELLANEOUS CHEMICAL PRD

2892,      EXPLOSIVES

28991,         SALT, COMMON

29,PETROLEUM AND COAL PRODUCTS

291,   PRODUCTS OF PETROLEUM REFINING

29111,         GSLN, JET, OTH HIGH VOLA PETRO

29112,         KEROSENE

29113,         DISTILLATE FUEL OIL

29114,         LUBRICATING & SIMILAR OILS

29115,         LUBRICATING GREASES

29116,         ASPHALT, TAR AND PITCHES

29117,         RESIDUAL FUEL OIL

29119,         PRODUCTS OF PETROLEUM REFINING

2912,      LIQUEFIED PETROLEUM GASES

295,   PAVING AND ROOFING MATERIALS

2951,      ASPHALT PAVING BLOCK & MIXTURES

2952,      ASPHALT FELT AND COATINGS

299,   MISCELLANEOUS PETROLEUM AND COAL

29911,         COAL AND COKE BRIQUETTES

29913,         PETROLEUM COKE, EXC BRIQUETTES

29914,         COKE PRODUCED FROM COAL

30,RUBBER AND MISCELLANEOUS PLASTIC

301,   TIRES AND INNER TUBES

302,   RUBBER AND PLASTIC FOOTWEAR

303,   RECLAIMED RUBBER

304,   RUBBER & PLASTIC HOSE & BELTING

306,   MISCELLANEOUS FABRICATED RUBBER

307,   MISCELLANEOUS PLASTIC PRODUCTS

31,LEATHER AND LEATHER PRODUCTS

311,   LEATHER

312,   INDUSTRIAL LEATHER BELTING

313,   BOOT AND SHOE CUT STOCK

314,   FOOTWEAR, EXC RUBBER OR PLASTIC

315,   LEATHER GLOVES AND MITTENS

316,   LUGGAGE, HANDBAGS

319,   MISCELLANEOUS LEATHER GOODS

32,STONE, CLAY, GLASS, CONCRETE PRD

321,   FLAT GLASS

322,   GLASS & GLASSWARE

3221,      GLASS CONTAINERS

324,   HYDRAULIC CEMENT

32411,         CEMENT, HYDLC, PORTLAND, NAT

325,   STRUCTURAL CLAY PRODUCTS

3251,      BRICK AND STRUCTURAL CLAY TILE

32511,         BRICK AND BLOCKS, CLAY & SHALE

3253,      CERAMIC WALL AND FLOOR TILE

3255,      REFRACTORIES, CLAY AND NONCLAY

3259,      MISC STRUCTURAL CLAY PRODUCTS

32594,         CLAY ROOFING TILE

326,   POTTERY AND RELATED PRODUCTS

327,   CONCRETE, GYPSUM & PLASTER PRD

3271,      CONCRETE PRODUCTS

3274,      LIME AND LIME PLASTER

3275,      GYPSUM PRODUCTS

328,   CUT STONE AND STONE PRODUCTS

329,   ABRASIVES, ASBESTOS, MISC

3291,      ABRASIVE PRODUCTS

3295,      NNMETIC MNRLS OR EARTHS, GRND

33,PRIMARY METAL PRODUCTS

331,   STEEL WORKS & ROLLING MILL PRD

33111,         PIG IRON

33112,         FURNACE SLAG

33119,         COKE OVEN & BLAST FURNACE PRD

3312,      PRIMARY IRON & STEEL PRD

33121,         STEEL INGOT AND SEMI FINISHED

3313,      ELECTROMETALLURGICAL PRD

3315,      STEEL WIRE, NAILS, AND SPIKES

332,   IRON AND STEEL CASTINGS

33211,         IRON AND STEEL CAST PIPE

333,   NONFERROUS METALS PRIMARY SMELT

3331,      PRIM COPPER & COPPER BASE ALLOY

3332,      PRIME LEAD SMELTER PRD

3333,      PRIM ZINC SMELTER PRD

3334,      PRIM ALUMINUM SMELTER PRD

335,   NONFERROUS METAL BASIC SHAPES

3351,      COPPER, BRASS OR BRONZE

3352,      ALUMINUM & ABA BASIC SHAPES

3357,      NONFERROUS METAL AND INSULATED

336,   NONFERROUS AND NONFERROUS BASE

3361,      ALUMINUM & ALUMINUM BASE ALLOY

3362,      BRASS, BRONZE, COPPER AND CBA

339,   MISCELLANEOUS PRIMARY METAL PRD

3391,      IRON AND STEEL FORGINGS

3392,      NONFERROUS METAL FORGINGS

34,FABRICATED METAL PRODUCTS

341,   METAL CANS

342,   CUTLERY, HAND TOOLS, & HARDWARE

343,   PLUMBING FXTRS AND HEATING APPAR

3433,      HEATING EQUIPMENT, EXC ELECTRIC

344,   FABRICATED STRUCTURAL METAL PRD

3441,      FABR STRUCTURAL METAL PRODUCTS

34411,         FABR STRUCTURAL IRON OR STEEL

345,   BOLTS, NUTS, SCREWS, RIVETS

346,   METAL STAMPING

348,   MISC FABR WIRE PRD, EXC STEEL

349,   MISC FABRICATED METAL PRD

3491,      METAL SHIPPING CONTAINERS

3494,      VALVES & PIPE FTG, EXC PLUMRS

35,MACHINERY, EXCEPT ELECTRICAL

351,   ENGINES AND TURBINES

352,   FARM MACHINERY AND EQUIPMENT

3524,      GARDEN TRACTORS, GARDEN EQPMNT

353,   CONST, MINING & MATERIALS HNDLNG

3531,      CONST MACHINERY AND EQUIPMENT

3532,      MINING MACHY, EQPT & PARTS

3533,      OIL FIELD MACHINERY & EQUIPMENT

3537,      IND TRUCKS, TRACTORS, TRAILERS

354,   METALWORKING MACHINERY AND EQPMT

355,   SPECIAL INDUSTRY MACHINERY

356,   GENERAL INDUSTRIAL MACHINERY

357,   OFFICE, COMPUTING, AND ACCT

358,   SERVICE INDUSTRY MACHINES

359,   MISC MACHINERY & PARTS, EXC ELEC

36,ELECTRICAL MACHY, EQPT & SUPP

361,   ELECTRICAL TRANS & DISTRIB EQPT

362,   ELECTRICAL INDUSTRIAL APPARATUS

363,   HOUSEHOLD APPLIANCES

3631,      HOUSEHOLD COOKING EQUIPMENT

3632,      HOUSEHOLD REFRIG & FREEZERS

3633,      HOUSEHOLD LAUNDRY EQUIPMENT

364,   ELECTRIC LIGHTING & WIRING EQPT

365,   RADIO AND TV RECEIVING SETS

366,   COMMUNICATION EQUIPMENT

367,   ELECTRONIC COMPONENTS & ACCESS

369,   MISC ELECTRICAL MACHINERY, EQPT

37,TRANSPORTATION EQUIPMENT

371,   MOTOR VEHICLES & EQUIPMENT

3711,      MOTOR VEHICLES

37111,         PASSENGER CARS, ASSEMBLED

37112,         TRUCK TRACTORS & TRUCKS, ASSEM

37113,         MOTOR COACHES, ASSD, FIRE DEPT

3712,      PASSENGER CAR BODIES

3713,      TRUCK AND BUS BODIES

3714,      MOTOR VEHICLE PARTS AND ACCESS

37147,         MOTOR VEHICLE BODY PARTS

3715,      TRUCK TRAILERS

372,   AIRCRAFT AND PARTS

373,   SHIPS AND BOATS

374,   RAILROAD EQUIPMENT

37422,         FREIGHT TRAIN CARS

375,   MOTORCYCLES, BICYCLES & PARTS

376,   GUIDED MSL & SPACE VHL PARTS

379,   MISCELLANEOUS TRANSPORTATION

38,INSTRUMENTS, PHOTO & OPTICAL GDS

381,   ENGINEERING, LAB & SCIENCE INST

382,   MEASURING, CONTROL & INDICATE

383,   OPTICAL INSTRUMENTS & LENSES

384,   SURGICAL, MEDICAL & DENTAL INST

385,   OPHTHALMIC OR OPTICIANS GOODS

386,   PHOTOGRAPHIC EQUIPMENT & SUPP

387,   WATCHES, CLOCKS, DEVICES & PARTS

39,MISC PRODUCTS OF MANUFACTURING

391,   JEWELRY, SILVERWARE & PLATED

393,   MUSICAL INSTRUMENTS AND PARTS

394,   TOYS, AMUSEMENT, SPORT, ATHLETIC

3949,      SPORTING AND ATHLETIC GOODS

395,   PENS, PENCILS & OTH OFFICE MTL

396,   COSTUME JEWELRY, NOVELTIES

399,   MISCELLANEOUS MANUFACTURED PRD

40,WASTE AND SCRAP MATERIALS

401,   ASHES

402,   WASTE AND SCRAP, EXCEPT ASHES

4021,      METAL SCRAP, WASTE AND TAILINGS

40211,         IRON AND STEEL SCRAP, WASTES

4022,      TEXTILE WASTE, SCRAP

4024,      PAPER WASTE AND SCRAP

4026,      RUBBER & PLASTIC SCRAP & WASTE

41,MISC FREIGHT SHIPMENTS

411,   MISC FREIGHT SHIPMENTS

41111,         OUTFITS OR KITS

41114,         ARTICLES, USED, EXC CODES

41115,         ARTICLES, USED, RTD FOR REPAIR

412,   MISC COMMODITIES NOT REG FRT SVC

42,CONTAINERS, SHIPPING, RTD EMPTY

421,   CONTAINERS, NON-REV., RTD EMPTY

422,   TRAILERS, SEMI TRAIL, RTD EMPTY

423,   TRAILERS, REVENUE, RTD EMPTY

44,FREIGHT FORWARDER TRAFFIC

441,   FREIGHT FORWARDER TRAFFIC (CL)

45,SHIPPER ASSN OR SIMILAR TRAFFIC

451,   SHIPPER ASSN OR SIMILAR TF (CL)

46,MISC MIXED SHIPMENTS EXC FORWARD.

461,   MISC MIXED SHIPMENTS

462,MISC MIXED SHIPMENTS, 2 COMMOD.

48,HAZARDOUS WASTE";

                var items = test.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries);

                foreach (var item in items) {

                    var parts = item.Split(",".ToCharArray(),StringSplitOptions.RemoveEmptyEntries);

                    var key = parts[0];

                    var label = parts[1].Trim();

                    Console.WriteLine(string.Format("yield return new CommodityType() {{Name = \"{0}\", Category=\"STCC\", Description = \"{1}\"}}; ",key, label));

                }

    }

}