Re: Field Value by Reference?

["Glenn Gundermann" <ggundermann@xxxxxx>]

Thanks for your reply Carel. 

My example didn't clearly indicate it but my output file does not contain 
all 999 fields today but just the possibility of containing up to 999 
fields. 

Today, my file contains 8 fields, INV001-INV005, INV020, INV030 and INV035.  
Tomorrow, it may have more. 

TIA. 

Carel Teijgeler writes: 

> Glenn, 
>
> Use an array. Strip the last three digits of the field name and use that as the index of the array. 
>
> Regards,
> Carel Teijgeler 
>
> *********** REPLY SEPARATOR  *********** 
>
> On 16-6-05 at 15:51 Glenn Gundermann wrote: 
>
> > I hope my example below is clear.  
> >
> > I have one file with many records for a given part, each containing just one 
> > value.  I want to update another file to hold all the values for one part on one record.  
> >
> > E.g.  
> >
> > Input File: 3 fields: key + field name + value
> > -----------------------------------------------
> > PARTA  INV001   30
> > PARTA  INV003   40
> > PARTA  INV007   50  
> >
> > I want the output file to look as follows: key + values
> > --------------------------------------------------------
> > PARTA  30   <blank>  40   <blank>   <blank>   <blank>   50  
> >
> > There are a possibility of 999 different fields so I don't want to code a  
> > complicated SELECT.