BED001,137CM BUDGET BLUE B/SET,BED001,BASE & MATTRESS,,Ea,0,0,39.47,0.00
BED0015,183CM BODY CUSHION BASE SET,BED0015,BASE & MATTRESS,,Ea,0,0,"1,099.91",0.00
##</code><code>##

BED001,39.47
BED0015,1099.91
##</code><code>##

perl -lne 'print join ",",map {s/[",]//g;$_}(split /,(?!(?:[^",]+",))/,$_)[0,8]' sample.txt