User:Pkchan/National squad re-formatting
From Wikipedia, the free encyclopedia
Contents |
[edit] Category:Football World Cup squads
[edit] 1978 FIFA World Cup (squads)
Regular expression used for re-formatting:
/^|-$/d s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\2|name=\3|age=\4|caps=|club=\5}}/g s/pos=MD/pos=MF/g
[edit] 1982 FIFA World Cup (squads)
Regular expression used for re-formatting the raw data:
/^$/d s/^\([0-9]\{1,2\}\). \(.*\) (\(.*\)).*$/{{nat fs player|no=\1|pos=|name=[[\2]]|age=|caps=|club=\3}}/g s/^\(.*\)pos=\(.*\) (GK)\(.*\)$/\1pos=GK\2\3/g s/^\(.*\)club=\([^,]*\)\, \(.*\)\(.*\)$/\1club=[[\2]], \3\4/g s/^\(.*\)club=\([[:alpha:] -]\{1,\}\)\(.*\)$/\1club=[[\2]]\3/g s/ AUS/ Australia/g s/ BEL/ Belgium/g s/ ENG/ England/g s/ ESP/ Spain/g s/ FRA/ France/g s/ FRG/ West Germany/g s/ SUI/ Switzerland/g
Regular expression used for re-formatting the formatted:
/^|-$/d s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=|caps=|club=\4}}/g s/pos=D/pos=DF/g s/pos=M/pos=MF/g s/pos=F/pos=FW/g s/pos=-/pos=/g
[edit] 1986 FIFA World Cup (squads)
Regular expression used for re-formatting:
/^$/d /^|-$/d s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=\4|caps=|club=\5}}/g s/pos=G/pos=GK/g s/pos=D/pos=DF/g s/pos=M/pos=MF/g s/pos=F/pos=FW/g s/pos=-/pos=/g
[edit] 1990 FIFA World Cup (squads)
sed commands used for re-formatting:
/^$/d /^===.*===$/d /^<table.*>$/d /^<tr.*><th.*>\[\[Image.*\]\].*\[\[\(.*\)\]\]\(<\/th>\)*<\/tr>$/s//=== [[\1]] ===/ /^<tr.*><th.*>.*Player.*<\/tr>$/s//{{nat fs start}}/ /^<tr.*><th.*Goalkeep.*$/,/^<tr><th colspan=3.*Defender.*$/s/^<tr><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><\/tr>$/{{nat fs player|no=\1|pos=GK|name=\2|age=|caps=|club=\3}}/g /^<tr.*><th.*Defender.*$/,/^<tr><th colspan=3.*Midfield.*$/s/^<tr><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><\/tr>$/{{nat fs player|no=\1|pos=DF|name=\2|age=|caps=|club=\3}}/g /^<tr.*><th.*Midfield.*$/,/^<tr><th colspan=3.*Forward.*$/s/^<tr><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><\/tr>$/{{nat fs player|no=\1|pos=MF|name=\2|age=|caps=|club=\3}}/g /^<tr.*><th.*Forward.*$/,/^<tr><th colspan=3.*Coach.*$/s/^<tr><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><td.*>\(.*\)<\/td><\/tr>$/{{nat fs player|no=\1|pos=FW|name=\2|age=|caps=|club=\3}}/g /^<tr.*><th.*Goalkeep.*$/d /^<tr.*><th.*Defender.*$/d /^<tr.*><th.*Midfield.*$/d /^<tr.*><th.*Forward.*$/d /^<tr.*><th.*>\(.*\)\(<\/th>\)*<\/tr>$/s//\1/ /^{{nat fs player|no=\([0-9]\)|\(.*\)$/s//{{nat fs player|no=0\1|\2/ /^<\/table>$/s//{{nat fs end}}/
/^{{nat fs start.*$/{ h D } /^===.*===$/G
/^{{nat fs end.*$/{ h D } /^{{nat fs player|no=22/G
/^Coach.*$/{ h D } /^===.*===$/G /^{{nat fs player|no=0\(.*\)|\(.*\)$/s//{{nat fs player|no=\1|\2/ /^$/d
[edit] 1998 FIFA World Cup (squads)
Regular expression used for re-formatting the 6-column lists:
/^|-\([[:space:]]\)*$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=\4|caps=\5|club=\6}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^ # $/d /^Name$/d /^Position$/d /^Age$/d /^Caps$/d /^Team$/d /^$/d
Regular expression used for re-formatting the 5-column lists:
/^|-\([[:space:]]\)*$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=\4|caps=|club=\5}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^ # $/d /^Name$/d /^Position$/d /^DOB$/d /^Team$/d /^$/d
[edit] 2002 FIFA World Cup (squads)
Regular expression used for re-formatting:
/^|-\([[:space:]]\)*$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=\4|caps=\5|club=\6}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^ # $/d /^Name$/d /^Position$/d /^Age$/d /^Caps$/d /^Team$/d /^$/d
[edit] Category:European Football Championship squads
[edit] 1984 European Football Championship (squads)
/^$/d /^|-$/d s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=|caps=|club=\4}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g
[edit] 1988 European Football Championship (squads)
/^$/d /^|-$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=|caps=|club=\4}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^ # $/d /^Name$/d /^Position$/d /^Team$/d
[edit] 1992 European Football Championship (squads)
/^$/d /^|-$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=|caps=|club=\4}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^ # $/d /^Name$/d /^Position$/d /^Team$/d
[edit] 1996 European Football Championship (squads)
/^|-\([[:space:]]\)*$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=\4|caps=|club=\5}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^! # $/d /^! Name$/d /^! Position$/d /^! DOB$/d /^! Team$/d
/^|-\([[:space:]]\)*$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=|caps=|club=\4}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^! # $/d /^! Name$/d /^! Position$/d /^! DOB$/d /^! Team$/d
[edit] 2000 European Football Championship (squads)
/^|-\([[:space:]]\)*$/d s/^{|.*$/{{nat fs start}}/g s/^|}/{{nat fs end}}/g s/^|\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)||\(.*\)$/{{nat fs player|no=\1|pos=\3|name=\2|age=\4|caps=\5|club=\6}}/g s/pos=D|/pos=DF|/g s/pos=M|/pos=MF|/g s/pos=F|/pos=FW|/g s/pos=-|/pos=|/g /^!.*|$/d /^ # $/d /^Name$/d /^Position$/d /^Birthdate$/d /^Caps$/d /^Team$/d