Remplacer avec des caractères génériques

Question

Bonjour, 

Je voudrais modifier une série de variables du genre 

R12012013@GTV#0 en GTV

Pour ça je fais :

SELECT essaiReplace.Texte, Replace(Replace(Replace(Replace(Replace([Texte],"R1",""), "R2",""),"1",""),"2","") ,"0","")AS PhaseFROM essaiReplaceWHERE (((essaiReplace.Texte) Like "*arv*"));

J'ai essayé les mêmes caractères génériques que l'on peut utiliser avec LIKE du genre

Replace([Texte], [012345678],"")

mais ca ne remplace rien

jordane45 · Answer

Bonjour,

- Quel SGBD utilises tu ? ( Mysql, SqlServer, Access, oracle ... ?)

- Pourrais tu nous donner la structure de ta Table ainsi qu'un dump de quelques données ?

lacomm · Answer

Il s'agit de Microsoft Office Access 2003

Texte:
R110010102@arv#0R110010102@arv#0R110010102@i#1R110010102@i#1R110010102@i#1R110010102@s#2R110010102@s#2R110011001@s#0R110011001@s#0...

J'utilise la variable "texte" pour créer de nouvelles variables selon certaines parties de la variable: R11 par ex. correspond à une institution, R1 à un temps, ce qui suit @ correspond à une phase etc

Voilà la requête que j'utilise pour l'instant, ca marche très bien, mais je voudrais simplifier
SELECT TableGlobale.Texte,Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([Texte],"R1",""),"relu",""),"R2",""),"1",""),"2",""),"0",""),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9",""),"@",""),"#","") AS Phase, Replace(Replace(Replace(Replace(Replace(Replace (Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([Texte],"R1","T"),"R2","T"),"relu",""),"i",""),"arv",""),"s",""),"c",""),"e",""),"m",""),"T1","Bo"),"T2","Na"),"T3","St"),"T4","Li"),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9",""),"@",""),"#",""),"2",""),"1",""),"0","") AS Institution,Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([Texte],"R1","A"),"R2","B"),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9",""),"@",""),"#",""),"2",""),"1",""),"0",""),"relu","") ,"i",""),"arv",""),"s",""),"c",""),"e",""),"m",""), "A","T1"),"B","T2") AS Tps,TableGlobale.numEnonce, TableGlobale.Loc, IIf([KOtab]=0,TableGlobale!Categorie,"NoTag") AS Categorie, TableGlobale.KOtab, TableGlobale.KO, TableGlobale.Enonce, IIf([KOtab]=0,TableGlobale!Grammaire,"NoTag") AS Grammaire, IIf([KOtab]=0,TableGlobale!CatGen,"NoTag") AS CatGen, IIf([KOtab]=0,TableGlobale!Tag,"NoTag") AS Tag, IIf([KOtab]=0,TableGlobale!Valeur,"NoTag") AS Valeur, TableGlobale.NPhrase INTO TableGlobaleCorrectFROM TableGlobale;


merci d'avance

Remplacer avec des caractères génériques

2 réponses

Votre réponse

Discussions similaires