Re: Getting all data for a specific column from a file

Then "Item" would be "ITEM#" and "Attribute Name" would be a desired field name, like "COMMONNAME" or "STORENO"?

I am having a tough time sorting out what it is you are looking for.

Also, you list "Field" just above "ITEM#"; I notice that it isn't all upper case. Is that an actual field? Or was that just the column heading in a copy & paste?

On 6/7/2012 12:09 PM, Jeff Young wrote:

My file looks like this:
Field
ITEM#
COMMONNAME
PONUMBER
BATCH00001
PRODU00001
RECEP00001
STORENO
NETWEIGHT
.
.
.
.
.
.

My driver file has the following fields:
Item
Attribute Name
Attribute Data

For each attribute name, I want to get just the item and data from the
corresponding column for all records from the input file.

Thanks,

On Thu, Jun 7, 2012 at 12:53 PM, Alan Campin<alan0307d@xxxxxxxxx> wrote:

What you are asking is not very clear to me.

When you say column, do you mean row?

Column_Name Value
ColumnA XXY
CoiumnB AAA

etc.

An example of what the data looks like might help.

On Thu, Jun 7, 2012 at 10:46 AM, Jeff Young<jyoung0950@xxxxxxxxx> wrote:

All,
I have a file that contains data for multiple items.
Each column of that file contains data for a different attribute.
I have a file of attribute names that match the column name.
I do not know at compile time how many items or columns need to be
processed.
I want to read my file of column names and get all the items for that
column along with the corresponding data.

What would be the best way to do this?

Thanks,

--
Jeff Young
Sr. Programmer Analyst
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.