I have a csv file that I am parsing, formatting and then writting to a new file. I am currently using an array, but I have some lines that might contain more data than others. I know for sure that columns 0-33 will always be there, but the customer has the option to add another set of columns to the row if needed. I do know that the addition's will always be 18 columns and I do know that they can add up to 15 set's of 18. So, the row length could be 0-33 or 0-51 if they add one additional set or 303 columns if they go up to 15.
The tricky part is I have to format each column for the new file that is created, I do this using sprintf. I have so far tried to use array_slice for the first 18 columns, then I do another array_slice starting at 18 and using the column count to get the last column in the row. Here is the code: array_slice($fields, 18,$lineCount); foreach ($fields as $key => $value){ print "$key|$value\r\n"; } The format of the new file will be this: 01-Customer information 02-Other information 03a Required Info (that can repeat up to 15 times per line) 03b "" 04b "" 04-Close Customer Record Repeat cycle for each row. The inner loop happens between the 02 and 04 records. Remember, I need to format each individual column, they are different format options. If you have some thoughts, I would be all ears as I have been starring at this too long and too hard. Thanks, -Scott -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php