How to parse a file with value pairs

Question

Ruben Ruiloba 2020-8-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/584069-how-to-parse-a-file-with-value-pairs

编辑： Stephen23 2020-8-25

Hi was looking for ideas on how to best parse a text file which lines are in the following format

the line is delimited by a '|' and it represents a value pair with the column name followed by an equal sign = followed by the value.

So in the example above I would like to end up with a table like this

FIX.BODY 2125 1067 150 329

___________________________________________

xxxxx aaaaaa bbbbb ccccc ddddd

3 个评论
显示 1更早的评论隐藏 1更早的评论

Ruben Ruiloba 2020-8-25

Hi thanks for the reply. Yes the file has multiple lines and the lines don't all have the same number of variable names.

The lines can differ. I can't upload the file as it has confidential data but it would look something like this.

!FIX.BODY=xxxxxx|2125=akcklsd|150=cchscc|329=ddddsd|

Thanks

Stephen23 2020-8-25

编辑：Stephen23 2020-8-25

"I can't upload the file as it has confidential data but it would look something like this."

A sample file does not have to contain confidential data in it, because you can write it with random, invented, made up data. However it should include all of the salient features of the actual data files, such as EOL character/s, file encoding (especially if this file is being generated from some other application), representative character strings, number encodings, etc.

Providing a file gives us an agreed reference with which we can test our code.

Not providing a file slows down you getting the solution you want.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2020-8-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/584069-how-to-parse-a-file-with-value-pairs#answer_484610

编辑：Stephen23 2020-8-25

在 MATLAB Online 中打开

This works with the attached file (which I had to create myself):

T = table();
[fid,msg] = fopen('temp0.txt','rt');
assert(fid>=3,msg)
while ~feof(fid)
    str = fgetl(fid);
    spl = regexp(str,'[^!|=]+','match');
    vnm = genvarname(spl(1:2:end)); % GENVARNAME is not required for R2019b or later
    T{end+1,vnm} =   spl(2:2:end);  %#ok<SAGROW>
end
fclose(fid);

Giving:

>> T
T = 
    FIX0x2EBODY       x2125        x1067       x150        x329        x4555        x908        x123   
    ___________    ___________    _______    ________    ________    _________    ________    _________
    'xxxxxx'       'aaaaaa'       'bbbbb'    'ccccc'     'dddddd'    []           []          []       
    'xxxxxx'       'akcklsd'      []         'cchscc'    'ddddsd'    []           []          []       
    'xxxxxx'       'ajfalkjfa'    []         []          []          'ndlsuel'    'akncld'    'hdeudnc'

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ruben Ruiloba 2020-8-25

Thanks this has given me ideas and exactly what I was looking for. Thanks again.

请先登录，再进行评论。

How to parse a file with value pairs

3 个评论
显示 1更早的评论隐藏 1更早的评论

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

How to parse a file with value pairs

3 个评论 显示 1更早的评论隐藏 1更早的评论

采纳的回答

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

3 个评论
显示 1更早的评论隐藏 1更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论