User:Pkchan/National squad re-formatting

Category:Football World Cup squads edit

1978 FIFA World Cup (squads) edit

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

1982 FIFA World Cup (squads) edit

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

1986 FIFA World Cup (squads) edit

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

1990 FIFA World Cup (squads) edit

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

1998 FIFA World Cup (squads) edit

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

2002 FIFA World Cup (squads) edit

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

Category:European Football Championship squads edit

1984 European Football Championship (squads) edit

/^$/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

1988 European Football Championship (squads) edit

/^$/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

1992 European Football Championship (squads) edit

/^$/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

1996 European Football Championship (squads) edit

/^|-\([[: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

2000 European Football Championship (squads) edit

/^|-\([[: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