c - 如何在 C 中解析带引号的 .csv 文件

Question

假设我尝试解析的字符串读取

"Smith, John",Data1,Data2,Data3

我还可以得到读取的行

Dave, Data1,Data2,Data3

所以我有 if 语句

line 是文件中的文本行 fgets()，但我认为这有效

剩下的事情我已经挣扎了大约一个小时左右。我正在尝试重新格式化“Smith，John”，使其成为 John Smith，然后将其分配给 recTemp.artist

if (line[0] == '\"') {
    //Read the last name, first name",
    char lastTemp[30] = "";
    char firstTemp[30] = "";
    strcpy(lastTemp , strtok(line, ", "));
    strcpy(firstTemp, strtok(NULL, "\","));
    char * t;
    t = strstr(lastTemp, "\"");
    strcpy(t, " ");
    //Concatenate each string assign to the artist value
    strcat(firstTemp, lastTemp);
    strcpy(recTemp.artist, firstTemp);
}

我认为错误来自 strstr 调用或紧随其后的 strcpy，但我不确定

谢谢!

Answer 1

回答您的问题:

"I'm trying to reformat the "Smith, John" so its John Smith"

如果不使用正则表达式从字符串中提取引号，我会执行以下操作，

#include <iostream>
#include <cstring>
#include <stdio.h>

int main() {
    char line[100] = "\"Smith,John\",Data1,Data2,Data3";
    // fgets(line, 100, stdin);
    char* name = strtok(line, "\"");
    char *substring2 = strtok(NULL, "\"");
    char* LastName = strtok(name, ",");
    char* FirstName = strtok(NULL, ",");

    char result[100];
    strcpy(result, FirstName);
    strcat(result, ",");
    strcat(result, LastName);
    strcat(result, substring2);
    printf("%s",result);

}

产生输出:

John,Smith,Data1,Data2,Data3