Good day. I could really use your help on this one. I have a stats text file in the following format.
ID=1000000 Name=Name1 Field1=Value1 ...(Fields 2 to 25) Field26=Value26 ID=1000001 Name=Name2 Field1=Value1 ...(Fields 2 to 25) Field26=Value26 ID=1000002 Name=Name2 Field1=Value1 ...(Fields 2 to 25) Field26=Value26 ...goes up to 15000
I have an active people text file separated by line breaks.
Name2 Name5 Name11 Name12 ...goes up to 1400 Random Names
I need to be able to delete records from the stats text file (ID, Name, Fields1 to 26) if the name is not found in the active people text file. In the example above, the associated record for Name1(ID, Name, Fields1 to 26) should be deleted since it's not in the active people text file.
I've tried reformatting the stats file through notepad++ using TextFX->Quick->Find/Replace to convert it to a comma separated file with each record separated by a line break. I had it rearranged to
ID Name Field1 ...Fields2 to Fields 25... Field26 1000000 Name1 Value1 ...Value2 to Value 25... Value26 1000001 Name2 Value1 ...Value2 to Value 25... Value26 1000002 Name3 Value1 ...Value2 to Value 25... Value26
I've opened it with excel and I've created two tables (stats table and a active names table) in mysql using the csv file file. I'm not sure how to process this in an automatic function. Besides removing inactive records, the other problem I have is rewriting it back to its old format.
I've been trying my best to figure this out for a hours on end. Is there a solution that won't require me to use find, copy, paste and switch between the two files 1400 times? I'm open to using different methods/programs to simplify the process. Unfortunately, I have to keep the stats file in this format.
I've hit a wall on this one. Please help. Thank you.