[Regex] Note

parse_csv_content.md

E.g.

lastName, firstName, email, phone, uid, subject, verificationCode
Wang,haha,,+886912345678,10001,PM,a,7624
Ke,yuyou,814007@gmail.com,,10002,RD,b,8140

Regex

^(?<lastName>[^,]*),(?<firstName>[^,]*),(?<email>[^,]*),(?<phone>[^,]*),(?<uid>[^,]*),(?<subject>[^,]*),(?<sales>[^,]*),(?<verificationCode>[^,]*)$

Split Regex

^ 
(?<lastName>[^,]*)
,
(?<firstName>[^,]*)
,
(?<email>[^,]*)
,
(?<phone>[^,]*)
,
(?<uid>[^,]*)
,
(?<subject>[^,]*)
,
(?<sales>[^,]*)
,
(?<verificationCode>[^,]*)
$

javascript

const regex = /^(?<lastName>[^,]*),(?<firstName>[^,]*),(?<email>[^,]*),(?<phone>[^,]*),(?<uid>[^,]*),(?<subject>[^,]*),(?<sales>[^,]*),(?<verificationCode>[^,]*)$/gm;
const str = `lastName, firstName, email, phone, uid, subject, verificationCode
Wang,haha,,+886912345678,10001,PM,a,7624
Ke,yuyou,814007@gmail.com,,10002,RD,b,8140`;
let m;

while ((m = regex.exec(str)) !== null) {
    // This is necessary to avoid infinite loops with zero-width matches
    if (m.index === regex.lastIndex) {
        regex.lastIndex++;
    }
    
    const rowData = m.groups;
    console.log(rowData);
}