Oppps Should be if ($record[6] .... ).
If you used it as is if ($record[6]) its just going to see if something is a there. -----Original Message----- From: Paul Kraus [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:02 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: big switching... Not tested While (<file>){ my @record = split /\|/; if ($record[6]){ #remember arrays start counting at zero do what ever you want with the data here } } HTH Paul -----Original Message----- From: LoneWolf [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:42 AM To: [EMAIL PROTECTED] Subject: big switching... 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] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
