I have a csv file in which I have to make some changes which you will see in the examples I will put. And I think I can do it with arrays, but I do not know how to structure it. Any ideas?
Original File;
"1033reto";"V09B";"";"";"";"";"";"QVN";"V09B" "1033reto";"V010";"";"";"";"";"";"QVN";"V010" "1033reto";"V015";"";"";"";"";"";"QVN";"V015" "1033reto";"V08C";"";"";"";"";"";"QVN";"V08C" "1040reto";"V03D";"";"";"";"";"";"QVN";"V03D" "1040reto";"V01C";"";"";"";"";"";"QVN";"V01C" "1050reto";"V03D";"";"";"";"";"";"QVN";"V03D" "1050reto";"V01F";"V07L";"";"";"";"";"QVN";"V01C"
Desired Output:
"1033reto";"V09B";"V010";"V015";"V08C";"";"QVN";"V09B" "1033reto";"V09B";"V010";"V015";"V08C";"";"QVN";"V010" "1033reto";"V09B";"V010";"V015";"V08C";"";"QVN";"V015" "1033reto";"V09B";"V010";"V015";"V08C";"";"QVN";"V08C" "1040reto";"V03D";"V01C";"";"";"";"";"QVN";"V03D" "1040reto";"V03D";"V01C";"";"";"";"";"QVN";"V01C" "1050reto";"V03D";"V01F";"V07L";"";"";"";"QVN";"V03D" "1050reto";"V03D";"V01F";"V07L";"";"";"";"QVN";"V01C"See Question&Answers more detail:os