regex biased twine csv matching
let me prologue observant i'm finish pledge comes regex wholly started few days ago. i'm perplexing solve problem formatting record have strike join sole form data. quarrel record structured this:
two words,word,word,word,"number, number"
what i need format this...
"two words","word",word","word","number, number"
i have regex settlement
s/,/","/g
working, solely also replaces comma already quoted number, array section, causes domain removed breaks file. essentially, i need cgange settlement reinstate comma "," [quote comma quote], nonetheless wholly comma isn't followed space. note fields never have space following comma, wholly delimited array list.
i managed up
s/,[a-za-z0-9]/","/g
which, while relating suitable strings, reinstate comma following letter. i have listened backreferences cruise competence i need use? bargain that
s/(,)[a-za-z0-9]\b
should work, nonetheless doesn't.
anyone have an idea?
Comments
Post a Comment