0

So I have been working with a csv export for a few days now and I have the data almost in the form I need it in. I need some advice on how best to proceed to get to the soltuion I need.

Here is the problem:

My csv export contains multiple rows (over 2000) of data in this format:

data1,data2,data3,data4
data1,data2,data3,data4
data1,data2,data3,data4

and I need to convert groups of three rows into one single line like this:

data1,data2,data3,data4,data1,data2,data3,data4,data1,data2,data3,data4

I have researched doing this with PHP and that is my first choice and why Im posting it here, but it looks like Bash and Python might be options as well.

Any thoughts on how you might handle this woukld be greatly appreciated.

2
Contributors
1
Reply
10
Views
3 Years
Discussion Span
Last Post by hericles
0

I'm not an expert on Python but I do know it has some advantages for this type of problem but to do this trivally in PHP:
Loop through the lines in the csv file (or whatever array you've loaded them into first).
Append each line to a variable (so it becomes line 1 + line 2 + line 3) and then do a modulo check on the loop counter + 1 (because it starts at 0 not 1), if it is evenly divisible by 3, pass the built up string to whatever is storing the final result, reset the variable and loop again.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.