Creating one field form many (Part II)

[Gar]

I originally posted in the File Definition Forum and they suggested this is more of a scripting thing.

I have 50 records in File A.

Each record has a number of fields. (Call them Field X, Field Y, Field Z, etc.)

I am attempting to build File B that will contain a single field (Field XX) that will contain the information from multiple fields in File A.

However, I am trying to do this in this manner.

File B - Field XX:

1st 50 records = info from File A - Field X

2nd 50 records = info from File A - Field Y

3rd 50 records = info from File A - Field Z.

Total records in File B will be 50 x (Number of fields in File A).

Is this possible?

[sbg2]

File B:

Import[FileA::FieldX]

Import[FileA::FieldY]

Import[FielA::FieldZ]

Is the reason for creating File B for use as a value list?

Edited October 28, 2005 by Guest

[Gar]

No. The file is a "bridge" to format 4000+ comments (80 fields at 50 comments each in the original file) into a single field.

This is done so they may be exported in a TAB format to be imported into another database that only has one field designated for comments.

My hope is that the runtime end user be able to load this file, run the script from a simple (for them) button which will pull the existing info, format the data for the TAB file, export the tab, then go quietly away.

Thank you for the lead. I wish I had signed up for this board long ago.