Exploring Lexi

Organizing and csv'ing.

So you've managed to download Lexi's picture sets and videos. Now let's organize them. Counting the images set you will find 38. So let's at least number them from 01 (being on the last page) and to 38 (being on the 1st page) as it seems like page 1 is where the set grows.

We have the list with set names. We got those from the grep command below. Now we need the proper set name as written on the html page.

A small grep command like the one below does the job for us

grep -Poh "(?<=<CENTER><FONT face=verdana,arial,sans-serif,\* size=-2>)[a-zA-Z0-9&; ]*[^<]" p*.html

click to enlarge

We copy the text and insert it in column mode next to the original text (from previous article) with the set names. We edit the text a bit and end up with something looking like the picture below.

click to enlarge

Now do some normal Search Replace where you replace " (" with " (" and " )" with ")". Save the text files as rendirs.bat in the pictures folder of the site. Doubleclikc the .bat file to run it and let it finish renaming the directories.

Now all you have to do is to pick the csv tool of your liking (ScanSort, The!Checker, Hunter, PhotoServe Check Ultimate, PhotoServe Professional Verify) and make the csv.