Read a userid file and search for userid.json in directory and then search json file

Question

Sunshine 2024-7-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2136203-read-a-userid-file-and-search-for-userid-json-in-directory-and-then-search-json-file

评论： Sunshine 2024-7-15

I know what I need to do, just having a hard to getting it going.

I have this userid.txt file that contains the only user files that I want to consider. If the userid say, 1821407, matches a json file within the directory, for example 1821407.json (all json files have this format), I want to check in the file for some data. I'm thinking I can do the search within the json file part. How do I use Matlab to perform the userid comparison within the directory?

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

请先登录，再进行评论。

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

Answer 1

Benjamin Kraus 2024-7-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2136203-read-a-userid-file-and-search-for-userid-json-in-directory-and-then-search-json-file#answer_1483833

在 MATLAB Online 中打开

I suspect you want to use the dir command to get a list of files in the directory, remove ".json" from the end of the file names, then search that list for your target user IDs.

Something like this perhaps:

userIDs = readmatrix('userids.txt');
jsonFiles = dir('*.json');
jsonFileNames = string({jsonFiles.name});
jsonFileUserIDs = extractBefore({jsonFiles.name},".json");
fileExistsForUserID = ismember(string(userIDs), jsonFileUserIDs);
filesWithUserIDInList = ismember(jsonFileUserIDs, string(userIDs));
jsonFilesFromList = jsonFileNames(filesWithUserIDInList);
for f = 1:numel(jsonFilesFromList)
    fileName = jsonFilesFromList(f);
    data = readstruct(fileName);
    % Do whatever you want with the data here.
end

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

Sunshine 2024-7-15

Thank you for your insight. I was able to take this code and pull out json info. Your help is very much appreciated.

请先登录，再进行评论。

Answer 2

VINAYAK LUHA 2024-7-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2136203-read-a-userid-file-and-search-for-userid-json-in-directory-and-then-search-json-file#answer_1483828

编辑：VINAYAK LUHA 2024-7-12

在 MATLAB Online 中打开

Hi Sunshine,

To find the .JSON files with filenames same as the ones in your "userids.txt" file, you may use the MATLAB "textscan" function as follows -

fileID = fopen('userids.txt', 'r');
userIDs = textscan(fileID, '%s');
fclose(fileID);
userIDs = userIDs{1};
% Find uniqueUserIds since some userIds in your list are repeated eg. -226340
uniqueUserIDs = unique(userIDs);
jsonFiles = dir('*.json');
for i = 1:length(uniqueUserIDs)
    userID = uniqueUserIDs{i};
    jsonFileName = strcat(userID, '.json');
 
    if ismember(jsonFileName, {jsonFiles.name})
        fprintf('File %s found.\n', jsonFileName);
    else
        fprintf('File %s not found.\n', jsonFileName);
    end
end

Further, to search within the .JSON files, you can use the MATLAB "fileread" and "jsondecode" functions, For more details refer to the following documentations -