Hello, and thank you in advance for your help!!!
I have a legacy file, in which 1800 unique field names and their associated values are in no specific order under generic Field_Name_1, Field_Value_2, Field_Name_2, Field_Value_2, Field_Name_3, Field_Value_3... through Field_Name and Value_35.
There are 6,000 records.
I do have a list of all of the individual field names, so if I had a mechanism to look inside each of the Field_Name cells, for each record, and assign its value to a different file that already had those 1800 headers across, that would be so incredibly wonderfully helpful. Thank you!
BTW, I did search, unsuccessfully, for similar examples... Thank you!!!
The below is a tiny snapshot of the larger whole. [TABLE="class: grid, width: 1552"]
<tbody>[TR]
[TD]Field_Name_1
[/TD]
[TD] Field_Value_1
[/TD]
[TD] Field_Name_2
[/TD]
[TD] Field_Value_2
[/TD]
[TD] Field_Name_3
[/TD]
[TD] Field_Value_3
[/TD]
[/TR]
[TR]
[TD]Air Compressor Type:
[/TD]
[TD]The VIAIR 400C compressor is a 2.54 CFM, 33% duty cycle unit that is intended to fill air tanks up to 5 Gal. to a pressure of 150 psi. The 400C provides speed over duration for operation, allowing the compressor to accomplish more in a shorter period of time. If conditions and prolonged use cause the unit to exceed unsafe internal temperatures, the built-in thermal overload protector will disable the unit temporarily, allowing the unit to be restarted when internal temperatures have dropped to acceptable levels.
California residents: see Proposition 65 information
Remote mountable air intake filter included, complete with 2-replacement dual-stage air filter elements
Equipped with a stainless steel braided leader hose with 1/4 in. NPT male fitting with inline check valve to eliminate head pressure and prolong service life
Mounting and remote air filter hardware included
Maximum amp draw at peak pressure is 26 Amp (12-Volt)
[/TD]
[TD]Base_lenght
[/TD]
[TD]12 x 9 x 6
[/TD]
[TD]Specs.
[/TD]
[TD]Specifications
Dimensions
Assembled Depth (in.)
12 in
Cord Length (in.)
18 Assembled Height (in.)
9 in
Hose length (in.)
21 ; Assembled Width (in.)
7 in ;
Details
Application Use
Inflation
Product Weight (lb.)
10 lb ; Compressor/Air Tool Features ; No Additional Features
Returnable ; 90-Day
Included _ N/A
Tools Product Type Air Compressor Kit
Maximum Pressure (psi) 150
Voltage (volts) 12
Warranty / Certifications
Certifications and Listings
M
[/TD]
[/TR]
[TR]
[TD]Facil.
[/TD]
[TD]Blg A Products-Area
[/TD]
[TD]Descrp.
[/TD]
[TD]16 oz. Claw Fiberglass Hammer: Basic tool that should everyone's toolbox should have. It's a good and convenient design hammer for DIY striking and pulling nails. Exceeds ASME.
Efficiency for faster swing and minimized fatigue
Magnetic starter for 16-denier double head nail
Comfort grip and thumb indent for strike accuracy
Exceeds ASME
[/TD]
[TD]Hammer_Base
[/TD]
[TD]corregated rubber
[/TD]
[/TR]
[TR]
[TD]Inv.#
[/TD]
[TD]GR98-2
[/TD]
[TD]Air_Compr.Type
[/TD]
[TD]Portable
[/TD]
[TD]specfcns.; \
[/TD]
[TD]The VIAIR 350C compressor is a 1.17 CFM, 100% duty cycle unit that is intended to fill air tanks up to 5 Gal. to a pressure of 150 psi. While other compressors may not have the stamina to work for long periods of time, the versatile 350C keeps on going. If conditions and prolonged use cause the unit to exceed unsafe internal temperatures, the built-in thermal overload protector will disable the unit temporarily, allowing the unit to be restarted when internal temperatures have dropped to acceptable levels.
[/TD]
[/TR]
[TR]
[TD]Screw_thread
[/TD]
[TD]16 gauge.
[/TD]
[TD]Supplier:
[/TD]
[TD]Fisston, Inc.
[/TD]
[TD]Material
[/TD]
[TD]anodized steel
[/TD]
[/TR]
[TR]
[TD]Facility
[/TD]
[TD]Blg A Products Ready for ship Area
[/TD]
[TD]Stress test
[/TD]
[TD]Break; flame; pressure
[/TD]
[TD]screw_count
[/TD]
[TD]20 | 25 | 3x5
[/TD]
[/TR]
</tbody>[/TABLE]
I have a legacy file, in which 1800 unique field names and their associated values are in no specific order under generic Field_Name_1, Field_Value_2, Field_Name_2, Field_Value_2, Field_Name_3, Field_Value_3... through Field_Name and Value_35.
There are 6,000 records.
I do have a list of all of the individual field names, so if I had a mechanism to look inside each of the Field_Name cells, for each record, and assign its value to a different file that already had those 1800 headers across, that would be so incredibly wonderfully helpful. Thank you!
BTW, I did search, unsuccessfully, for similar examples... Thank you!!!
The below is a tiny snapshot of the larger whole. [TABLE="class: grid, width: 1552"]
<tbody>[TR]
[TD]Field_Name_1
[/TD]
[TD] Field_Value_1
[/TD]
[TD] Field_Name_2
[/TD]
[TD] Field_Value_2
[/TD]
[TD] Field_Name_3
[/TD]
[TD] Field_Value_3
[/TD]
[/TR]
[TR]
[TD]Air Compressor Type:
[/TD]
[TD]The VIAIR 400C compressor is a 2.54 CFM, 33% duty cycle unit that is intended to fill air tanks up to 5 Gal. to a pressure of 150 psi. The 400C provides speed over duration for operation, allowing the compressor to accomplish more in a shorter period of time. If conditions and prolonged use cause the unit to exceed unsafe internal temperatures, the built-in thermal overload protector will disable the unit temporarily, allowing the unit to be restarted when internal temperatures have dropped to acceptable levels.
California residents: see Proposition 65 information
Remote mountable air intake filter included, complete with 2-replacement dual-stage air filter elements
Equipped with a stainless steel braided leader hose with 1/4 in. NPT male fitting with inline check valve to eliminate head pressure and prolong service life
Mounting and remote air filter hardware included
Maximum amp draw at peak pressure is 26 Amp (12-Volt)
[/TD]
[TD]Base_lenght
[/TD]
[TD]12 x 9 x 6
[/TD]
[TD]Specs.
[/TD]
[TD]Specifications
Dimensions
Assembled Depth (in.)
12 in
Cord Length (in.)
18 Assembled Height (in.)
9 in
Hose length (in.)
21 ; Assembled Width (in.)
7 in ;
Details
Application Use
Inflation
Product Weight (lb.)
10 lb ; Compressor/Air Tool Features ; No Additional Features
Returnable ; 90-Day
Included _ N/A
Tools Product Type Air Compressor Kit
Maximum Pressure (psi) 150
Voltage (volts) 12
Warranty / Certifications
Certifications and Listings
M
[/TD]
[/TR]
[TR]
[TD]Facil.
[/TD]
[TD]Blg A Products-Area
[/TD]
[TD]Descrp.
[/TD]
[TD]16 oz. Claw Fiberglass Hammer: Basic tool that should everyone's toolbox should have. It's a good and convenient design hammer for DIY striking and pulling nails. Exceeds ASME.
Efficiency for faster swing and minimized fatigue
Magnetic starter for 16-denier double head nail
Comfort grip and thumb indent for strike accuracy
Exceeds ASME
[/TD]
[TD]Hammer_Base
[/TD]
[TD]corregated rubber
[/TD]
[/TR]
[TR]
[TD]Inv.#
[/TD]
[TD]GR98-2
[/TD]
[TD]Air_Compr.Type
[/TD]
[TD]Portable
[/TD]
[TD]specfcns.; \
[/TD]
[TD]The VIAIR 350C compressor is a 1.17 CFM, 100% duty cycle unit that is intended to fill air tanks up to 5 Gal. to a pressure of 150 psi. While other compressors may not have the stamina to work for long periods of time, the versatile 350C keeps on going. If conditions and prolonged use cause the unit to exceed unsafe internal temperatures, the built-in thermal overload protector will disable the unit temporarily, allowing the unit to be restarted when internal temperatures have dropped to acceptable levels.
[/TD]
[/TR]
[TR]
[TD]Screw_thread
[/TD]
[TD]16 gauge.
[/TD]
[TD]Supplier:
[/TD]
[TD]Fisston, Inc.
[/TD]
[TD]Material
[/TD]
[TD]anodized steel
[/TD]
[/TR]
[TR]
[TD]Facility
[/TD]
[TD]Blg A Products Ready for ship Area
[/TD]
[TD]Stress test
[/TD]
[TD]Break; flame; pressure
[/TD]
[TD]screw_count
[/TD]
[TD]20 | 25 | 3x5
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited:
