|
|
Post by Privateer on Sept 28, 2016 16:09:22 GMT
1st do a find in files, Find text should be Class= in files should be the Campaign folder file type should be *.mis Once the results pop up, Right click and select export csv I use Open Office and I separate the import using the = sign Once imported I delete all the columns EXCEPT for the last one with the actual name like JPFish01 etc. Now you'll see names repeated and not in alphabetical order. Save the file for the next step. Here's where you'll need (and appreciate)a Script! Open 010 and select Scripts in the Orders bar at top, Click on Scripts Repository, Scroll down until you find SortLines.1sc click it and click the install button. Now open the file you saved with just the names. Click Scripts up top again and go to 3 text. You'll see Sortlines listed. Click it.  You should now have a sorted list with all the repeat names gone. You'll repeat the find in files with a few different settings now. Find text should be ClassName= in files should be the Rosters folder file type should be *.cfg you'll do the same save and work with the CSV files as above. The Sortlines Script is already installed so you skip that step. Now you have 2 lists you can compare pretty easily. |
|
|
|
Post by propbeanie on Sept 29, 2016 4:19:57 GMT
Well, I'm just now finishing up on a busy day, so I've got part one run from above, and have to clean my list up, and then do part two tomorrow... btw, 8314 results in 103 files, searched in 394... in the Campaign folders... yikes! I think I'm going to look through there and see how much "trash" is in there too... I know I've been keeping the MIS files I'm working on in there, but that's only been 6-8 files thus far...
|
|
|
|
Post by Privateer on Sept 29, 2016 18:08:45 GMT
I have a quicker way to do all this so you don't need to have Open Office or other programs to work the CSV files. Just need to finish a few tweeks and I'll get you all setup with a modified script. The modified script will allow you do the same thing above but in even less time and work!! CUsersPrivateerDesktopTrim_Files.1sc (3.61 KB) Save this as Trim_Files.1sc Don't know why it added the other stuff. |
|
|
|
Post by Privateer on Sept 29, 2016 19:03:16 GMT
Now you need to install the new script. Open 010 and go to the Scripts thing up top. Then go to view installed scripts. When the window opens do the install script and install the new script. This script will remove the need for Open Office or other such programs! It parses and removes most of the stuff we don't want. Step one- Do your find in files thing and save as a CSV file. Step two- Open that file and run the new script. In the Output window at the bottom, right click and export text. Step three- close the old file and open your output file you just saved. Step four- Delete the Executing script blah blah at the top of the file and save it. Do a replace where find text is class= and replace text is blank. Save the file again. (You do not need to close and reopen the file! Just let it stay) Step five- Run the Sortlines script and save! Step six- Have a beer! |
|
|
|
Post by Privateer on Sept 29, 2016 21:40:03 GMT
When I get a little more time?
I can reduce the number of steps and do an auto save on the files and reduce it to two steps.
|
|
|
|
Post by propbeanie on Sept 29, 2016 22:04:07 GMT
Thanks for the file. I'll check it out later. I've run into some "life" crap that everyone has to deal with, and I hope to get about an hour later this evening to look at it. I went to do me a "check" on the results, and I'm not getting what I expected. I haven't had a chance to go through and actually look at a few of the lines in my 2nd set of data, to see what I'm getting, but I'll guess that my first set of data results with the Class= is bringing in the first hit of each Group, while searching on a "Type=" is bringing in all the ships in the the group. I at first tried to combine the two finds into one, both with the "*" wildcard, and the results didn't match, then I noticed that I'm getting an "R" with the "Type=" query for whatever reason. I do not have that selected in the Options box. So I separated them, and got what appears to be nearly identical data to what the combined search got me... I get the 8314 results or whatever it was of the "Class" hits, but I get way more of the "Type" hits. I've looked at doing a script, and while the language used looks familiar (python?), and it reminds of C in some ways, there are apparently Constants that I have no familiarity with. I'm reading the scripting section now on my tablet - which keeps ~crashing~, thank you very much UPDATE!!! The wife's job is changing for the worse... does it never end?... :lol: Life, can't live without it. |;^)
|
|
|
|
Post by propbeanie on Sept 30, 2016 6:32:32 GMT
You know that GIGO saying, well...
|
|
|
|
Post by propbeanie on Sept 30, 2016 19:00:05 GMT
OK Mr. Privateer Sir... I cannot bend the 010 Hex Editor to my will, and I am now in the Help! documentation looking at scripting (LOOK-OUT computer world!!!). Like Dr. Heinz Doofenshmirtz, it will probably not end well for me, or for those around me caught in the soon-to-be-created vortex...
What I am attempting to do, is pull in 3 pieces of data on 3 consecutive separate text lines in the MIS files, and then separate them with a comma. This is the Class=*, Type=*, and Origin=* of most of the MIS files. Not all of them might have that data set, dependent upon the file and where in the file the different data is, but most of them will, especially in the root Campaign folder. I can pull in the data singly, and then try to match the lines, but even then, I'm getting a lot of data (think prodigious amounts) not matching between them, pulling in the weather settings, time, etc., that I don't want. I just want the groups that have all three "variables" on three consecutive lines in the files. When I do all three at one time with a Find In Files, the way it stands now, my "Origin=" is just that, no Origin data. Blank. Also, both the "Type=" and the "Origin=" portion of the query, after running, will have the leading (r), even if I then edit them out and run it again. I do not have Regular Expressions enabled in the Options box...
Any advice for the newb? I'm almost certain its the carriage return at the ends of the first two lines messing it up. I want the carriage return left on the third line for the spreadsheet set delimiter, but can't figure-out how to accurately strip the other two carriage returns (or New Line thingies, whatever they call them). I always was a good string mangler, just not accurate... ??
halp! You know they put those memory allocation bounds and attempts at fail-safe in programming languages for guys like me, right? "What do you mean the hard drive is wiping itself after running Dr. Heinz's AS400 SQL Query?" Oops...
|
|
|
|
Post by Privateer on Sept 30, 2016 21:07:27 GMT
I sent a question to the Guys at Sweetscape about this.
As far as I know, unless we do a script, it's a single search function in 010 directly.
Now if I parse the file structure? Scripts will be easy to pull off.
|
|
|
|
Post by propbeanie on Oct 1, 2016 0:12:04 GMT
Yeah, I'm trying to parse "on the fly", do it and return data on run through, and this ain't C. Close, but script. Gotta remember that. But, a script can use the output in the Results box, right? or does it have to be "saved" first... where's that confounded help topic again... lol
|
|
|
|
Post by propbeanie on Oct 1, 2016 1:54:18 GMT
OK, I got that first described data of the Class= in the Mis files, and the ClassName= in the CFG files, combined the two and inserted spaces where needed to keep their lines the same. This is a 100FalloftheRisingSun_Ultimate_v0.26Beta_EN install only - however - I did NOT clean my FotRS install first, so there is some extraneous data from my MIS file editing, so there ~might~ be a couple used that really aren't... Can't say for certain. This is an experiment only, and it's kind of nice being able to get similar results with just the 010 Editor, or with the Editor and a Spreadsheet app... There are things missing in the ClassName column that I did not think were previously... dunno. Anyway, I'll do another run like this when you guys get the real ships cleaned, dried and JSGME'd... I'm going to experiment some with some RR CVE groups, land based airplanes, and some "Elite" DE Convoy dogs... Don't want 'em too killer... especially in light of the AI controller mod. Oooh... imagine that on 5, and the MAD dudes on Elite...
ClassAndNamesSortedCompare26.xlsx (16.52 KB)
btw, if anyone wants an older XLS format, or CSV, just let me know, and I'll put it up. This was created in Excel 2010 (hey, got it free from work - direct from MS - payola :lol:), but should be able to be opened and viewed by anything... |
|
