How to split text in csv file using sed?

There is a price list in csv format, select comma tire size, radius, load, speed rating and manufacturer:

Output format:
4918,335/30R18 102Y Pirelli PZERO CORSA I,0,3,15.3...
2940,335/25R22 105Y XL Vredestein Ultrac Vorti,26,,17.42,...

Required format:
4918,335,30,R18,102,Y,Pirelli,PZERO CORSA I,0,3,15.3,4 to 6 days
2940,335,25,R22,105,Y,Vredestein, Ultrac Vorti XL,26,,17.42,...

Will be iterated on Linux bash script, how to do it better?
June 10th 19 at 14:51
2 answers
June 10th 19 at 14:53
Line can be considered. Replace the slash with a comma. The third element: read to blank; then start (number) third element for the regular season; to count to a space; then the start (number) for the regular season; back to a space; before the first comma; all that is left.

sed, grep, cut, awk together.
Thanks for the logic, but I would regexp :) - nicholaus.OConnell commented on June 10th 19 at 14:56
One , it's another resource (Relansin, etc.).

Or on their own. - Domingo.Keeling11 commented on June 10th 19 at 14:59
June 10th 19 at 14:55
To parse the input file as CSV format: each source line to consider as a set of cells. Libraries full of any programming language.
The 2nd cell is split using regular expressions. How exactly - depends on the precise format of the cell. For example, in the particular case of the manufacturer name can be a single word (Pirelli, Vredestein), and maybe 2 or more. Thus, one cell can be split into several, recording the result in the output line.
Similarly, other cells.

Find more questions by tags sedbashCSVLinux