King_DuckZ
3f353b7dfe
Lists are a bit dirty and can't be imported into sqlite atm due to them having duplicated serial numbers. They need cleaning, possibly against titelIDs.txt which, on the other hand, contains dodgy character sequences.
14 lines
655 B
Text
14 lines
655 B
Text
apply {{game_list}} to -
|
|
struct Games
|
|
name default("n/a") = //table[@class="sectiontable"]/tr/(td[@class="col3"]|td[@class="col7"])/fn:normalize-space(translate(text(), ' 
', ' '))
|
|
serial default("") = //table[@class="sectiontable"]/tr/(td[@class="col2"]|td[@class="col6"])/fn:translate(string-join(text(), '/'), ' 
 ', '')
|
|
languages default("") = //table[@class="sectiontable"]/tr/(td[@class="col4"]|td[@class="col8"])/fn:normalize-space(upper-case(translate(translate(text(), ' 
()', ' []'), ' ', '')))
|
|
end
|
|
end
|
|
|
|
==game_list
|
|
name,serial,languages
|
|
{{#Games}}
|
|
"{{{name}}}",{{{serial}}},{{{languages}}}
|
|
{{/Games}}
|
|
==end
|