I have a 12 field 3000 line file (| delimited) and need to check the 7th entry of each line to see what it is, and based on that it needs to be written out to a file with a new entry in the 7th spot. I could do it with a few entries to check, but the permutation is of 253 different choices.
Example: data.txt ww-a10991t|rolls|5765|365.3|385|12|RR|Rolls Royce|2|0|1|A ww-a10991w|rolls|5763|365.3|385|12|RR|Rolls Royce|2|0|1|A ww-a10991b|rolls|5790|365.3|385|12|RR|Rolls Royce|2|0|1|A RR is keyed as category 235 so the outputed file will be: ww-a10991t|rolls|5765|365.3|385|12|235|Rolls Royce|2|0|1|A ww-a10991w|rolls|5763|365.3|385|12|235|Rolls Royce|2|0|1|A ww-a10991b|rolls|5790|365.3|385|12|235|Rolls Royce|2|0|1|A My problem is just that the size of the switching and checking seems attrocious to do. Thoughts, suggestions? This is a flat file that I am then loading into MySQL and pulling the data from it, and without this step of swapping category codes for a category identification number gives me a HORRIBLE looking output as well as a TON of errors. TIA! Robert -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]