[PHP] convertir des caractères spéciaux de PHP urlencode

Question

Je cherche à importer un fichier texte en ligne de l'url suivante Le problème est que les données sont codées au format PHP urlencode(), ce qui signifie par exemple qu'une virgule est exprimée par %2C. Je voudrais pouvoir convertir à chaque importation ces caractères automatiquement ou même manuellement. Quelqu'un peut-il m'aider (si possible sans VBA) ? merci d'avance...

Amadéus · Answer

La commande Rechercher-Remplacer existe sur Excel 2003, elle doit bien exister sur Excel 2007. Avec 2003, c'est "Edition" "Rechercher" (ou Ctrl+F) et là tu cherches par exemple %2C et tu le remplaces d'un coup sur les 22000 lignes par une virgule. Au passage, je te signale que %2C n'existe pas sur l'import de ce jour. Cordialement...

Amadéus · Answer

Dans le fichier joint, un tableau des équivalences. Par ailleurs, il existe sur le Net des Encodeurs, Décodeurs (voir l'exemple avec le lien) Cordialement...

Sébastien · Answer

Pour convertir ton fichier en ceci : 79238,613914,008 snoop dogg,401,360,4,1221 28105,3414,Monodon,398,438,12,8472 10,515191,11 ** Fureur,508,520,16,11982 64568,857080,Athènes,327,613,6,9454 34236,484569,NC4. Huesca,446,652,2,12119 62477,908898,mini-athene,631,377,13,1976 68578,775359,rupturopolis,720,625,0,978 65018,739484,khadeodeus,399,343,0,3085 266,557365,kk.9,515,496,2,11138 79241,899885,fuji,413,705,7,1185 294,556527,A2 Money GasqueFP,490,514,12,12454 49,291959,18.M,521,513,7,11413 67912,839462,Ville de Elorif,749,496,6,2253 42147,614019,Byblos,567,615,3,10533 8643,602945,13*mimi,602,526,5,7480 61,27962,04.mojito,505,513,11,9823 67201,642415,Ville de gameiro56,543,685,19,1938 40757,755074,Méan,576,692,4,5924 79240,275815,5 Perissac,606,700,13,1381 32801,627446,05 Hagios,647,619,19,13716 64566,611309,piloupilou,577,391,17,4634 18434,346784,Gesoriacum,390,411,7,11329 49569,299379,Citrik95,714,565,2,8697 79232,239666,=Obito-Gaiden=,428,706,14,1908 403,481116,01 - Mean Streets,480,490,9,13509 74206,772877,Disciplinea,567,705,17,4719 65349,717033,M-Aurorea,451,665,13,8770 64572,871517,Ville de quentin5E,274,517,0,914 76437,1055034,Ville de fabx2210,633,346,0,490 43667,530490,Ville de lacinomarseille,401,319,14,198 10755,603956,12-Nargothrond,574,588,17,13157 28347,716749,5.3 Ombre Luna,626,618,13,12533 14564,606407,ville de linvincib18,528,629,14,11245 79231,605087,Saint-Benoît,717,618,5,1698 79236,650252,ALERIA Mu 01,717,618,9,2370 1757,595268,Valparaiso,538,534,3,12339 55746,772634,kratos,313,368,9,10337 66516,756988,Asgard,475,301,18,10805 51793,838771,01.Sparte,669,652,5,13716 69983,897620,Billapolis,730,539,18,9598 8542,523678,Black Pearl06,599,531,19,13433 79235,743519,cannapolis,253,425,4,1590 28280,391678,didi07,541,516,12,12606 31,12618,tumiche,499,487,2,12592 35775,630188,Red orange.,531,694,6,10814 76433,845954,Ville de edouard C,627,730,4,219 64562,738405,White Lagoon,429,290,7,10183 76434,867765,Ville de sylvek,355,325,0,1834 68677,608232,R.I.P Aldemar,484,585,7,3585 90,,1 UT,499,502,18,938 8552,,3-Bastet,587,555,6,1072 63497,595431,bihy,491,447,13,2768 8090,,Ville de seigneur wam,433,515,15,727 66026,614577,Bréhat,433,592,15,1387 79234,1100712,Ville de agnus,247,442,14,355 76435,1037915,Ville de martinabrami15,627,730,11,175 64567,616260,Bronx-Mu,739,563,0,836 57416,,MARSEILLE CITY,735,533,19,528 48910,,la M.A.C.H.I.N.E,404,307,0,276 64564,,Tartopum,352,579,10,716 38574,737294,04Pouchni dépecé,339,564,1,11222 42136,611922,1.7. Théra,588,620,1,10810 66517,678851,Cristal Palace,741,565,9,7173 250,57483,Ville de Atlantida,526,517,6,3915 273,549111,12Stizostedion lucio,490,514,13,13495 5195,245356,03 Les Renégats,471,436,5,9850 63789,107849,temple d Ares,352,392,2,5229 8233,598196,thasis,472,561,3,11758 6934,92089,nico13,485,565,5,10424 57453,704241,La cité interdite 9,683,517,0,10076 338,328665,13. Alamo,527,505,0,11234 48026,817649,Donostialdea,322,580,5,9396 271,6976,1.4,500,492,15,10506 77442,994347,Alariel,399,277,10,3648 36753,605220,C4 - Davosite,358,373,7,12722 48122,746350,sebesirem5,708,574,17,4435 36169,605378,antilles 1 p,325,428,14,11636 62466,630736,Tighettoville 13,544,740,11,11341 55102,600132,- Milnaé - Aihl - *,336,424,9,5402 3755,78209,022,566,525,6,6598 9118,404597,Proxima,455,412,10,12214 63785,728015,Brauron,496,317,4,10449 28291,614650,02 - Barcelone,595,468,2,13716 21963,618437,NO02*TOURNAI 438-603,436,602,3,13716 33089,727602,Ville de simon25290,489,658,11,2400 78153,965364,Continum 2,312,338,10,2571 67187,975884,Neutrinio,269,513,8,4849 67911,440098,Ville de mamat,500,522,1,2274 36853,608175,Reset,380,433,12,9844 75434,808240,argus2,350,622,12,1827 4883,105089,Apero II,461,441,14,10018 28923,,Ville de elicule 4,388,373,11,1401 67914,606407,Ville de linvincib20,500,638,1,10451 43,,Ville de julienl57,491,483,13,868 5205,245356,01 Les Renégats,471,436,14,9723 45775,780888,Pfaffeneim,619,682,18,436 263,597813,La Muerte 1.6 wv*,491,483,6,10614 46202,648262,la javanaise,694,597,0,11683 81184,1002199,Aragon,269,598,15,713 269,391678,didi14,523,509,0,4231 333,338455,08.Tournesol,526,517,10,13003 2925,275585,Obrigado,463,464,19,13027 8751,,Ville de thevincen,432,522,16,1163 2357,46754,09 Ivry City à plus,508,465,15,11280 43176,,Recovery,408,542,0,745 79233,822088,Athénapolis 2,356,641,10,1400 67457,316624,Surzur BZH 2,405,401,16,2861 18909,,Bucarest,561,418,13,974 46581,801215,Ville de reymi007,347,354,5,765 47553,,Piraoust,508,574,9,3699 14667,595907,06 - Durango,381,451,4,13152 76438,884651,Ville de lemoine.valentin,749,584,18,268 47996,104606,Sion,460,691,1,6494 77443,595670,Edward,497,562,2,2328 42720,,0.1 city,618,410,14,1067 67913,741426,Ville de trouvis,637,483,0,2320 79237,1100728,Ville de pape1,575,306,18,219 60459,622105,centora 6,265,495,0,609 45525,731396,PICHMAN 3,620,405,16,2715 79242,1100786,Ville de Mrsimon49,618,330,6,199 11099,606407,ville de linvincib23,491,578,19,13174 66031,477407,Mu 3,443,313,5,2740 77445,691075,07 Karpathos,695,592,16,4108 61981,869243,Ville de Gael 450,271,437,10,619 299,453419,Dionysos,490,514,14,10557 13354,616119,65bShadows,615,553,14,8023 66521,454558,**ROME**,551,504,10,2316 66524,411748,Ville toto du 17 1,352,493,0,3344 7863,588053,ALAN II,597,515,2,11326 21921,619487,dudu,646,566,3,4499 20240,611800,Fredopoulopolis 11,602,478,10,13716 78155,593396,Ville de superfredo,686,687,16,494 76440,1020511,Ville de dylanfru,285,617,19,262 51901,484569,SC2. Sousse,440,694,10,10465 64580,,Ville de lekiller15,369,686,6,984 69,453419,New Town,504,509,19,10860 79246,845608,Ville de gpaposologi,568,322,7,1527 79247,1100848,Ville de chat39300,247,442,6,326 66525,363478,Sachaka,574,561,6,6784 16484,605138,Catopsis,580,449,17,12323 66523,595670,Alice,497,562,0,6886 79251,595019,Shao-my..8,491,450,5,1331 76445,1043799,Ville de hitmandu57,301,337,1,286 31674,629417,13. Natty Dread,595,661,8,11781 32123,724545,catacombe,578,397,13,4462 79244,919069,Ville de Antoine 94,255,541,5,554 282,328665,05. Sarajevo,526,517,11,12859 349,328665,12. Nagazaki,522,518,17,10211 9623,598025,kahlan,492,572,12,10713 41835,718755,Tisgirds,330,391,16,3191 66030,604004,nord-3,464,575,4,1647 66520,751648,Emporiae,370,631,10,6576 79252,129674,ploum,427,315,16,1589 26502,,Laikin II,351,429,12,860 79243,1045238,Ville de aqua madoor,627,336,13,267 76447,1051835,Ville de bena1234,285,617,8,175 1563,595158,3.3-Oujappellapolys,469,488,4,11844 285,,Solo,522,518,1,1212 49049,735227,Vanvillûm,489,658,8,11402 64584,,Ville de reda24dz,333,401,16,652 66518,,Ville de yanrev,273,539,11,1556 9239,,fornicapolis D.C.,469,404,0,1130 48587,820678,Ville de nanard 2,652,466,19,2996 8680,588053,Lemean Hydra,601,529,11,7724 79245,426923,Istanbul,748,593,18,591 20067,,athènes,355,484,14,814 7279,404597,6...Katowice,463,420,12,11595 61461,876775,Ville de Totorox,266,461,15,292 66032,737749,5. Vathy sur Ithaque,599,671,8,2477 41848,,Ville de Darkorbit2,354,608,14,458 42524,656675,Nice,317,410,17,882 19988,,Ville de selenangye,378,418,19,835 64576,164993,Ville de lerouxl,739,563,11,501 49111,724670,Ville de nicolas983,341,614,3,417 27560,697158,Olympe,673,538,3,906 64577,616901,Mahora,615,442,0,2124 16085,594829,Yakkééa-05,580,449,13,11439 79248,832654,Ville de Zab45000,595,315,18,175 76444,1055349,Ville de nico7las,301,337,16,246 79250,944091,Ville de luxshan2,748,593,3,199 51937,735764,Ville de louis 1,312,381,15,290 3845,198186,Organion,542,555,13,3619 81301,826460,Ville 5 de bigshow27,327,613,8,1130 3836,500168,bavq,501,452,6,9306 1270,595231,cvaalf c,548,508,19,10079 61003,202368,01- REGIS,612,715,8,9460 77447,998837,Paradise City II,711,622,8,3359 69857,727202,georgopolis6,382,643,9,7447 68689,665762,Athènes,417,638,8,2752 41972,608717,Base P-492-367,490,366,1,12555 46329,320526,raposa,525,347,15,13716 79253,1057857,Ville de seyl,712,659,4,309 64583,627604,ostair 2,624,620,12,3698 71760,562854,Assasin,606,639,4,7868 39961,751139,auriane maxence fifi,303,481,16,2459 52043,785439,Capitaine Balgaro2,672,649,6,10751 42111,617692,02. Cadmée,454,608,9,10919 71759,314790,mu 1,479,532,6,5447 48588,820713,Ville de tom1111,475,694,0,2391 27950,601182,La Cité Doré,555,457,4,5692 58734,514252,04COM- Pylos,322,408,16,10806 27067,632417,3 GEMI,375,564,2,9348 705,593975,06 toulon,535,505,11,12358 144,420965,Atoll Capitale,511,483,17,11005 74290,1025912,glinin,670,393,0,1566 76448,826021,Ville de tommy54,555,757,13,322 8190,600733,Ville de LOGUDORO,567,574,13,12783 42142,369871,Monsieur Henry,438,416,12,10084 67884,968229,Ville de radic31,639,711,12,2030 55946,729833,Sarbiate,367,569,3,10959 47363,811496,Octave Auguste,395,664,13,3904 71764,356984,Ville de fabrice03,309,501,19,4349 77446,993602,AZENOPOLUX,674,428,4,2333 48608,805482,The Big Apple,552,352,4,1324 108,338455,01.XIII,508,520,17,11040 26499,622737,City Black Island,604,445,15,10362 76446,995260,Leningrad,313,641,0,2863 77448,883486,scarface-2,660,425,7,2150 283,566507,jyce empire F,511,483,12,10691 81299,1114583,Ville de sutrass,321,307,6,380 27925,606089,Mystra,549,430,9,13618 626,447652,Atlantis,514,478,2,2100 5918,598025,Elliot,528,581,12,9194 26988,381642,0.9 O,381,495,14,10869 53673,743223,Merci RITA34,322,603,3,10446 15644,316624,Vannes BZH 56,401,412,16,3488 61985,863434,Ville de théo robin,356,311,15,3018 71761,733792,Damned,555,686,19,9691 42114,621019,Roerdland I,412,558,10,12409 59477,721429,eden,399,288,13,4167 79249,858642,19-04-11,515,331,19,936 27557,130271,Ville de joueuse22,358,412,19,556 71762,,Ville de d2jp,677,413,15,382 69505,,Ville de blakie,328,497,1,927 66519,478136,Ishkan I,659,496,0,896 81298,947852,Ville de seikiki,260,573,1,175 81300,1114605,Ville de Jeredu97,334,296,3,175 6429,,Ville de pamampa,535,453,4,1199 36763,,Ville de coco335,311,490,3,988 77449,983100,THEBES,303,625,18,2731 66522,136620,Ville de charlene77,392,382,3,2617 48787,821382,Ville de lbreton69,404,307,2,3546 48634,820146,Ville de cléoprine,372,327,5,341 66530,629694,1holman,504,685,13,7721 64590,604798,Atlantis 10,429,536,11,4547 76449,903921,Ville de nathanhenaut,438,736,1,654 66533,582639,09.PorkWorld,578,528,4,4160 57968,623600,leboulet4,600,423,10,9571 31106,242865,43D Arthur,454,330,3,3362 4029,600408,Spéculos,439,488,6,7446 1702,428163,38-Girvan,539,540,7,12056 63166,740939,Echadey plage 3,365,604,19,11546 131,515191,02 -- sFyA,505,513,17,12541 5624,398644,illdira,558,560,8,12701 350,428163,18-Old Pulteney,527,505,5,11455 46979,5517,FanI,429,368,5,6391 64586,932417,Grivallo,372,294,14,6635 41928,598196,Jenny,475,564,7,10577 11314,537009,08 - KytinePark,521,615,3,9019 65348,737698,Ville de Alémap IV,404,337,6,12443 28021,722242,Nakitu-City IV,615,635,8,11811 57021,26405,TabarnaK,724,576,6,8514 8144,605279,18-AFFLIGEM,552,587,12,12622 79256,817080,Nauplie,739,563,13,1317 14573,608412,Cyparisse,466,582,2,11942 44886,614892,Okayama,468,606,7,13716 79262,864561,olympe,619,376,12,978 63392,597993,fuerte 10,438,301,1,9981 368,429842,A.8 Winterfell,527,505,17,11012 341,291959,20.M,499,502,3,11935 39594,729833,Pasisinis,330,542,7,11583 66034,757156,Ville de LeGrandDemon,490,682,0,1274 77450,1002586,NEUBAUTEN,296,637,18,1698 7258,604931,O55.N1,504,598,7,12511 1811,596491,15-Pegalia,501,555,17,11114 37472,673292,Ville de superbensurf,639,498,11,1943 48027,723980,Segusiavorum VII-75,708,574,19,10594 79259,375980,Ville de bex2,447,264,0,1719 58969,701540,**....Khao....**,482,267,14,2703 25061,618421,03-Seynac,520,386,19,10175 31680,91038,Ville de maudvz,328,449,11,363 81302,621798,Ville de Woltarus,480,750,2,175 15165,415528,Diamanland 08,586,469,13,11756 70293,,Kratanos,565,687,16,447 15083,522669,Lolo Cité Mu-20,410,518,10,11913 63451,,Okidokiisland 2,458,247,10,478 63425,764688,Triton,613,671,3,9576 71766,3982,Ville de michou47,278,587,15,1023 79261,699844,KavarakForEver,657,605,11,1011 27288,538368,03- Spartiate,375,564,15,12751 79254,1100920,Ville de ultimatesx,480,747,10,219 66037,349280,PorkWorld M55 11,578,528,2,5574 64589,,Ville de tavernix,521,698,11,1732 66528,,B.Manathan,347,586,5,4758 35350,735161,tranquille city,690,548,4,1911 79255,1100926,Ville de azertyuipqsdfghjkm,268,588,19,219 28474,,Ville de jeje2528,671,550,0,773 54270,,Ville de Kaporal D,710,596,9,569 15589,278191,Corimendre,464,588,7,1945 31134,,super pet fort,345,415,0,1266 64591,821082,Ville de fipfip,652,662,10,5453 359,,Ville de lilyc M 55,529,513,6,2303 48611,820780,makomakcity,396,312,13,4259 79260,1100979,Ville de Xaboni,279,612,9,232 5177,431126,Bouchers killers12,577,524,18,10497 77457,619188,GAELIDE X,485,396,1,3114 49020,357305,13-Soeur*Thin,507,583,8,7640 27762,606842,FR.12 b,467,335,13,12193 81305,438051,Ville de napoléon4,382,707,0,864 71774,835923,Ville de papynou 1,658,480,17,2073 183,596491,20-Nikkiria,494,511,5,12492 76454,840684,TEMPLAR,492,279,0,3120 71768,608240,9.KRZYSZTOF,616,561,14,3703 13166,606763,-Tura-,442,560,4,10355 77455,926353,Ville de mlefevre,354,673,1,1741 45989,790600,Rome,437,681,12,2712 29078,625875,Aramanth,355,504,9,6062 81304,1114670,real,304,658,4,282 66534,917069,Ville de rivoli,400,708,16,5305 700,597813,La Muerte 1.7 lv,491,480,7,11186 127,556847,4.1- Dark Ouffffff,491,490,0,10327 19668,411302,babaorhum,594,619,12,10292 77454,848784,Lyon,337,345,9,2028 44607,596594,Aydindril,418,606,6,9749 79264,893022,les centurions,575,306,6,270 79263,729724,Ville de misterganja,712,659,5,175 45664,611009,Corinthe,400,517,2,9475 71778,615285,jessie3,392,522,12,5600 69730,992336,Ville de .poupoupou.,596,333,9,2017 64573,607905,11* Ichigo Kurosaki,602,598,18,3535 28122,614376,Magaman Est 1,432,522,2,11704 28647,705243,Tess-làbas,622,490,9,9802 38488,745209,Ville de babylone,378,622,18,12301 62957,,ville de louis,396,284,2,294 15013,609196,Boussaypolis,447,574,6,12156 6126,115319,D Atlantis 1 D-b,528,581,7,9889 77452,58584,vbtrvbtr1,583,590,16,1722 76451,1055470,village des zombies,291,352,19,327 61987,905782,Edipolis,356,671,6,5790 71767,254579,guillomopolis,544,406,13,4123 46098,,Choucapik-City 2,575,571,13,814 77451,738382,Ville de aleximan,611,739,6,278 61991,370584,rafy,356,671,8,911 37893,413650,ATHENA 04 BIS,631,652,9,10072 68694,449199,Ville de langloi 2,422,634,6,4057 56904,729654,athenes,311,602,10,11503 244,453419,Peka Story,489,501,15,10806 67922,85726,Ville de TRIERAS,490,254,5,3306 71776,634738,-Alcatraz-5,411,605,16,2392 66532,614886,Ville de unbienplus,498,293,13,13237 57466,175179,497632,495,631,7,9767 64594,834832,* SPARTE - Mx3.-01 *,401,705,9,3625 81303,866988,Ville de kikiboss78,350,701,14,175 181,6976,Athena05,517,499,17,11136 59480,885662,RHODES 4,582,725,17,8729 66728,604276,Ville de cyriloubiloute,655,642,6,4372 70295,,Predonis,403,696,0,385 68691,607679,299.398.S4,299,398,16,3869 68693,698864,Ville de suzasti,720,625,14,304 75372,1040703,Ville de retep,260,537,4,374 71773,965018,Ville de big boss,451,734,6,246 58970,461139,Ville de lebouyen,540,331,13,1052 76450,295487,Ville de sajj 2,653,682,10,2287 411,,Ville de kirikou1,494,517,17,1319 309,,Grozny,515,496,12,1729 71769,822096,martpolis,382,278,11,805 64596,593377,Ville de elfsister,355,307,0,5137 17931,609454,....3-KaLaChNïKoV...,568,426,2,13439 70298,737698,Ville de Alémap VI,404,337,4,7173 77458,285986,Nolan IV,485,396,3,3002 31504,616935,Dragon feu,350,496,6,11787 5445,613830,LSAldrovandia,546,472,9,12184 66545,,v-2,468,446,2,1025 395,595165,Ater,491,483,3,10888 7185,588184,E06 Odelie,418,480,1,13716 79257,914850,helios,541,762,18,451 70297,763106,Ville de naomis,554,364,0,2532 3262,592085,Spécialiste 27.,560,534,8,11838 67919,537667,pat 4,578,418,10,4166 18067,618437,NE07 MALMEDY 484-604,482,603,14,13642 47024,625968,virus 12,657,505,11,13716 23891,106168,Calth,660,540,5,11969 60800,899122,1 - Babaorum,266,473,13,11958 41,,scrificeland 1,508,520,18,447 56052,207681,07.Omega Chi,660,442,19,6377 47132,602572,KINKINLAND1,682,622,8,7714 67924,864417,mel,647,411,7,6577 76452,599612,Ville de Hergos,511,763,7,175 78422,1087861,Windose XP,677,395,15,175 39806,245965,Alpha C1,361,358,5,12416 14843,604560,magmanix X,485,590,17,11513 29079,623309,03-Marsaxlokk,433,344,9,11222 76011,1049660,Ville de Jess00,693,441,5,1048 66540,846569,Thanatos,320,588,1,6531 39333,603619,Capitale Spartakus,454,561,9,13716 19259,604004,sud-3,433,586,2,8003 69514,438051,Austerlitz,386,705,17,2880 81306,92228,Ville de glacias,565,740,0,774 26501,627115,Garico,421,615,16,8544 64602,448769,05- matbon,484,680,16,5093 38383,744174,Angmar,382,626,19,11319 79265,556839,La Forteresse,618,330,14,670 66040,847795,Ville de MONSTEUR 10,284,579,10,398 79270,833926,Ville de alexis du 71,340,295,18,280 275,566507,jyce empire J,513,491,17,9285 610,478651,Ville de rapbab,525,525,19,1582 79268,949215,Pyrrhus,340,295,17,546 64601,473445,Ville de gabinlemmet,414,273,19,1121 79266,1101036,Héliopolis,705,469,0,248 67926,735213,Malyka 7,694,528,14,6607 71771,694774,Conquest of Paradise,289,384,16,4271 71928,121610,Ville de obel,559,751,11,5283 42548,717739,topaze,681,609,13,3993 2775,595231,cvaalf i,560,508,16,9382 50330,395236,Dol Amroth,502,448,0,5709 79269,932027,Ville de Goufou,369,686,1,968 52986,,Ville de docfull,635,526,16,643 77453,1066470,BCzzzone,611,739,16,1741 66544,955757,Ville de Daffin,361,299,12,948 3043,27235,Tanés IV,491,450,1,8236 69511,984746,Ville de fafasacha,496,252,5,219 69509,,moulin de la galette,324,615,13,512 79267,1081355,Ville de noyo 337000,269,381,10,219 68692,,v-3,460,446,18,1042 67923,309691,Tlaxcala,575,550,17,1514 34684,733419,Ville de tamaboy,621,447,4,1014 66541,,Ville de toto36,542,521,13,559 66538,520598,Ville de Shibuya,531,433,8,8790 384,594897,Ville de grzeskowiak,516,528,6,4949 31516,722590,Enkidiev,685,513,7,10537 71786,1006225,Ville de Dons,655,706,17,244 65463,602305,Ville bibi-09,396,498,12,10698 79271,889907,la mort,247,442,13,439 43603,740367,Aquaweed,661,639,16,11810 62959,912879,vous etes des cons,374,298,16,362 77456,1071566,alesia,441,739,12,223 81307,905862,Ville de mimines,713,496,7,223 81308,759510,Idefix,600,709,6,898 81312,110977,Simon O Town,508,571,10,933 67925,595670,Rosalie,497,562,5,3811 63403,441336,Ville de steven5300,468,261,3,539 73742,932280,Maravella,757,541,13,1451 70301,621294,cité de athéna II,374,507,9,3022 66041,838638,03Thor,345,636,4,5962 31681,,Ville de thom11,335,433,17,1089 71783,1003985,ville de pro dargent,278,587,4,2143 4833,566136,ville de mu3,578,506,14,10382 646,481520,02.Mideel,525,521,12,12314 42278,641512,???????????,620,673,2,678 44240,605378,ville en 24-1,294,482,11,12813 67920,607679,299.398.S1,299,398,19,4466 48598,615186,Brest10,355,631,4,10491 10167,289756,Ville Paul Muadib 90,467,398,1,10585 64598,720276,Ville de dodo043,577,332,2,1092 46950,538368,02- Spartiate,381,567,0,13190 79258,932782,Ville de dguyomar,247,442,16,224 63745,922119,Ninjapolis Beta,636,378,19,5381 12437,609196,Boussay Playa,463,571,0,12926 30263,211264,LAP1,595,657,5,5990 66546,,Umaril s ground,480,730,15,786 69517,990901,Ville de cozette du 64,272,402,14,506 38157,660540,yato VI,701,518,19,12807 51136,827201,08. SHIZUNE,381,662,6,10761 77459,603266,Atalan,272,447,9,2263 2093,498545,Guerriers de Liège 2,507,557,3,11530 68700,78209,011,585,572,0,9102 40854,614019,Delphe,571,621,7,9833 67745,973441,Bikini Bottom I,582,739,18,7790 25333,595907,12 - Bessières,372,401,6,13716 76457,1055545,Ville de stefmeuleau06,627,730,2,175 31081,623340,Le.Sage3,473,327,18,10156 40706,566777,3 Papille,508,593,9,11854 1108,,St Benji,522,488,17,546 71781,215671,Coco-town,412,294,14,1354 67656,,A Secret Place,387,697,14,3466 47721,518058,P2X-05,567,710,8,10530 9423,,Ville de carlito1312,407,462,8,999 77462,1071588,Ville de mathieuxdu36,693,430,11,342 70299,427344,Ville des Nordiques1,398,369,14,1439 54464,,Ville de MUSCLORE,431,285,6,482 81309,846232,ticland,391,726,15,224 81311,994028,Ville de RICOU1356,581,303,13,175 259,,angra mayna,495,497,6,1833 76455,1055541,Ville de lilokomoto,354,289,12,729 10910,604016,Zeus,454,561,1,2456 497,,Ville de romainv88,529,513,10,3455 51898,,Ville de tito85,619,389,0,2504 76458,,renaissance1,668,582,5,2135 79272,988773,Ville de tomtomus,269,381,17,175 67932,615256,3-Jakarta,320,369,6,5021 21587,618437,NO01*LEUZE 438-603,436,602,5,13716 1306,37199,Ville de emixam,483,474,4,2257 70303,742252,Caspion,578,676,11,9090 66550,962435,Divona,442,262,14,5835 64610,514475,Ville Lancelot,510,577,14,4137 31226,764597,Gargottes Puantes,504,685,6,10147 707,552519,06. Seitoa,523,529,6,10978 70302,623414,Belleville,673,497,13,5131 74367,1020067,Ville de tiririca,559,308,14,898 655,27962,05.pina-colada,499,524,7,10144 1102,328665,02. Stalingrad,537,514,19,13010 77461,1011004,Ville de mmariethoz,595,319,2,269 79280,224078,joselito 1er,627,336,4,614 26203,211622,08 Reine morte,409,601,13,12844 26862,621086,Epsilon II,616,479,10,9073 79274,403470,Ville de thoe,247,442,4,179 67931,840684,BLACK,498,283,0,6123 44870,319867,05- Scylla,546,565,19,11038 43693,706798,06 - Tarangopolis,458,682,0,4451 59552,505452,Bac 36574,366,673,13,13259 2547,595628,345,549,533,18,2204 67929,724911,Ville de vSig,655,625,6,10752 35763,611347,3 - Eopolis,402,513,10,10276 57973,,Ville de Yonden,358,317,17,494 16731,617629,Y22 pichardière,463,593,6,11857 2127,261404,Ville de Intello24,460,491,1,3446 45835,610516,M33 V de ibikit 4,392,368,3,12034 43522,770667,Trostylé,607,396,17,13716 67928,601356,4 August Burns Redya,501,675,0,9059 239,557365,Athena la belle,515,496,5,11317 81310,783818,Ville de zib78,423,297,11,897 2797,110977,Takuma City,505,560,15,13716 77460,776659,Hero,603,722,2,3245 81313,733826,Ville de ciboulette64,260,573,13,199 67933,444952,Cazillac mer36 -v2-,382,619,3,6332 79275,607524,Ville de vésuve,694,424,4,301 66551,878613,athene,334,319,6,1104 1684,31618,Boston Bruins,473,483,5,10652 43292,,màgikal-tour,548,707,1,1386 46590,,Ville de rooks666,492,692,1,596 58972,,Ville de word of warcraft,660,432,12,376 76456,1010432,Ville de truite108,519,298,0,322 2425,340819,04 Dark Sombre,522,471,18,11819 67930,976017,Ville de remihervouet,461,728,7,400 74364,312496,Ville de coju,297,632,9,339 16427,611185,Manstein,364,492,8,13716 49195,597312,Ville de thom28,634,679,10,1873 74363,943070,Ville de max.lec,316,656,5,1183 55767,25860,Ville de willom,471,273,13,2734 64604,,Ville de kstor,739,563,5,380 61988,905791,Ville de bouffy02,678,484,14,567 50573,836693,Ville de ZEUS,284,473,11,2924 79279,1040707,Ville de Raphael 10,533,294,8,259 66049,766999,Ville de jonathan70400,643,380,1,3026 79276,1101172,Ville de pablor,269,381,6,212 79278,842842,Ville de Mimindy,269,381,14,175 66549,567718,MaAx,361,299,13,2074 26503,537350,ville de psg,508,674,7,1607 79277,843313,Maiden,340,295,7,219 69518,600091,Ville de slmcf1998,265,422,16,2220 58345,847330,Ville de tomi117,557,731,8,1690 64612,605314,Ville de Marko2b,267,436,12,4411 25905,618421,06-Mariac,530,388,1,8805 81315,644492,Bordemer,446,315,2,962 66065,932338,Mu Wimereux,301,358,0,5349 81316,1098721,athene,250,529,9,317 52670,105427,631.ArmentièresAD,605,374,7,10517 45778,327228,free fisting...,514,532,3,1968 16888,605172,11.Hérésia,507,639,1,12412 66553,861583,Ville de GRECPOLICE,500,750,5,7142 1047,589158,xanaka,483,486,13,2623 65975,320652,KOLOSS,435,695,10,2630 11293,607580,..12,600,562,12,10939 40237,588053,Caucasian Eagle,553,547,5,12188 66059,749817,babasse78,364,353,8,2988 28338,417356,03 ANTI-ABSOLION,405,408,2,12138 81317,471501,Ville de dydylastar13,460,262,16,933 58343,606667,Ville de Alex2789,327,345,16,492 540,45931,4.1 Gosa Town,491,483,5,10479 58654,720211,Ville de zafra,348,656,14,9583 45781,620677,ATHENES,339,455,2,13716 81318,599505,Olympe 4,441,522,4,847 71791,616264,H-76,702,607,2,3112 66060,624592,8*spart,367,431,3,2763 26842,619039,ville de bertrand 12,596,431,16,10145 71788,614886,Ville de encoreplus,486,293,15,9033 66058,750524,2. Celestina,361,358,6,6986 etc. Tu peux utiliser ce code (à copier dans un fichier .php) : &lt;html&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8"/&gt; &lt;/head&gt; &lt;body&gt; &lt;?php // https://forum.excel-pratique.com/viewtopic.php?f=35&amp;t=22817 $texte=file_get_contents("http://fr12.grepolis.com/data/towns.txt"); $tab_texte=explode(chr(10), $texte); for($i=0; $i&lt;count($tab_texte); $i++) echo urldecode($tab_texte&#91;$i&#93;)."&lt;br /&gt;"; ?&gt; &lt;/body&gt; &lt;/html&gt; Il suffira ensuite d'ouvrir le fichier php pour afficher la liste ... Cordialement...