using System.Xml.Serialization;
using System.Data.DataSetExtensions;
public static void Main()
string test = @"1,FARM PRODUCTS
1132, CORN, EXCEPT POPCORN
1137, WHEAT, EXCEPT BUCKWHEAT
114, OIL SEEDS, NUTS & KERNELS
115, FIELD SEEDS, EXC OIL SEEDS
119, MISCELLANEOUS FIELD CROPS
1195, POTATOES, OTHER THAN SWEET
12, FRESH FRUITS AND TREE NUTS
123, TROPICAL FRUITS, EXC CITRUS
129, MISC FRESH FRUITS AND NUTS
131, BULBS, ROOTS & TUBERS
133, LEAFY FRESH VEGETABLES
134, DRY RIPE VEG SEEDS, ETC
139, MISC. FRESH VEGETABLES
1398, MELONS, EXCEPT WATERMELONS
14, LIVESTOCK AND LIVESTOCK PRD
15, POULTRY AND POULTRY PRODUCTS
19, MISCELLANEOUS FARM PRODUCTS
191, HORTICULTURAL SPECIALTIES
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
10112, BENEFICIATING GRADE ORE
104, GOLD AND SILVER ORES
105, BAUXITE AND ALUMINUM ORES
109, MISCELLANEOUS METAL ORES
11112, CLEANED OR PREP. ANTH.
112, BITUMINOUS COAL AND LIGNITE
13,CRUDE PETRO, NAT GAS & GSLN
131, CRUDE PETROLEUM AND NAT.GAS
141, DIMENSION STONE, QUARRY
142, CRUSHED AND BROKEN STONE
14211, AGRICULTURAL LIMESTONE
14212, FLUXING STONE OR LIMES
14219, CRUSHED AND BROKEN STONE
14411, SAND (AGGREGATE AND BALLAST)
14412, GRAVEL (AGGREGATE AND BALLAST)
14413, INDUSTRIAL SAND, CRUDE
145, CLAY, CERAMIC AND REFRACTORY
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
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
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
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
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
2039, CANNED & PRESERVED FRUITS, VEG
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
20471, DOG, CAT & OTH PET FD EXC CAN
20472, CANNED DOG, CAT & OTH PET FOOD
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
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
213, CHEWING AND SMOKING TOBACCO
214, STEMMED AND REDRIED TOBACCO
221, COTTON BROAD WOVEN FABRICS
222, MAN MADE FIBER AND SILK
223, WOOL BROAD WOVEN FABRICS
227, FLOOR COVERINGS, TEXTILE
229, MISCELLANEOUS TEXTILE GOODS
2296, TIRE CORD AND FABRICS
2297, WOOL AND MOHAIR (SCRD ETC)
23,APPAREL & OTHER FINISHED TEXTILE
231, MENS AND BOYS CLOTHING
233, WOMENS, GIRLS & INFANTS CLOTHING
235, MILLINERY, HATS AND CAPS
238, MISC APPAREL & ACCESSORIES
239, MISCELLANEOUS FABRICATED TEXTILE
24,LUMBER & WOOD PRODUCTS, EXC FURN
241, PRIM FOREST PRD (PLPWD, PLNG)
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
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
262, PAPER, EXCEPT BUILDING PAPER
26212, GROUND WOOD PAPER, UNCOATED
26217, SPECIAL INDUSTRIAL PAPER
26218, SANITARY TISSUE STOCK
263, PAPERBOARD, PULPBOARD & FIBERBRD
264, CONVERTED PAPER & PAPERBRD PRD
26471, SANITARY TISSUES/HEALTH PRODS
265, CONTAINERS & BOXES, PAPERBOARD
266, BUILDING PAPER & BUILDING BOARD
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
2818, MISC INDUSTRIAL ORG CHEMICALS
2819, MISC INDUSTRIAL INORG CHEMICALS
282, PLSTC MATERIALS & SYN RESINS
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
289, MISCELLANEOUS CHEMICAL PRD
29,PETROLEUM AND COAL PRODUCTS
291, PRODUCTS OF PETROLEUM REFINING
29111, GSLN, JET, OTH HIGH VOLA PETRO
29113, DISTILLATE FUEL OIL
29114, LUBRICATING & SIMILAR OILS
29115, LUBRICATING GREASES
29116, ASPHALT, TAR AND PITCHES
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
304, RUBBER & PLASTIC HOSE & BELTING
306, MISCELLANEOUS FABRICATED RUBBER
307, MISCELLANEOUS PLASTIC PRODUCTS
31,LEATHER AND LEATHER PRODUCTS
312, INDUSTRIAL LEATHER BELTING
313, BOOT AND SHOE CUT STOCK
314, FOOTWEAR, EXC RUBBER OR PLASTIC
315, LEATHER GLOVES AND MITTENS
319, MISCELLANEOUS LEATHER GOODS
32,STONE, CLAY, GLASS, CONCRETE PRD
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
326, POTTERY AND RELATED PRODUCTS
327, CONCRETE, GYPSUM & PLASTER PRD
3274, LIME AND LIME PLASTER
328, CUT STONE AND STONE PRODUCTS
329, ABRASIVES, ASBESTOS, MISC
3295, NNMETIC MNRLS OR EARTHS, GRND
33,PRIMARY METAL PRODUCTS
331, STEEL WORKS & ROLLING MILL PRD
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
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
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
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
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
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
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.
var items = test.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
foreach (var item in items) {
var parts = item.Split(",".ToCharArray(),StringSplitOptions.RemoveEmptyEntries);
var label = parts[1].Trim();
Console.WriteLine(string.Format("yield return new CommodityType() {{Name = \"{0}\", Category=\"STCC\", Description = \"{1}\"}}; ",key, label));