Partitioning data out of .txt files

Question

Jon 2022-10-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1820695-partitioning-data-out-of-txt-files

评论： Jon 2022-10-17

archer_fieldnotes_scan.txt

I have a lot of old data scanned from hand writen notes. It was scanned in to a .txt file, the result being one long string of words and numbers. See data sample attached "archers_fieldnotes_scan".

The data consist of a location (or the shorthand note of it), a number, its result, then the next location, number, its result....repeat.

I need to break this information down into a usable matrix, consisting of 1 column vector fot the location, 1 column vector for the numeric value, and a thrid column vector of the result.

All I have been able to do with it so far is read the .txt file in as one long string.

txt=readlines("archer_fieldnotes_scan.txt");

This is the first time I am attempting to partition something this string dependant. Any suggestions?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Chunru 2022-10-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1820695-partitioning-data-out-of-txt-files#answer_1070050

编辑：Chunru 2022-10-15

在 MATLAB Online 中打开

websave("scan.txt", "https://www.mathworks.com/matlabcentral/answers/uploaded_files/1150740/archer_fieldnotes_scan.txt")
ans = '/users/mss.system.KDDHFr/scan.txt'
%type scan.txt
s = readlines("scan.txt")
s = "northeast section ar20.63 - pos northeast sec ar20.69 - neg NE sec 20.71 - neg NE sect as 20.72 - ? southeast sec am20.70-neg SE sec am20.71 - pos"
x = regexp(s, '(\D+)(\d+\.\d+) - (pos|neg)* ', 'tokens')
x = 1×3 cell array
    {["northeast section ar"    "20.63"    "pos"]}    {["northeast sec ar"    "20.69"    "neg"]}    {["NE sec "    "20.71"    "neg"]}

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

Chunru 2022-10-15

See above. You can read through regext, which is very powerful.

Jon 2022-10-17

Ok, cool you used the pos of neg, which is more or less common this will work and I can change the off events where it doesnt mannually. Great, thank you much.

请先登录，再进行评论。