You mean VIEW$ The Grepper is my second-favourite transformer, and there are at least two people who hate me for making them learn regular expressions :)
(warning: do not come to work or practicum here if you don't want to be exposed to regex) Jason -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mark2atsafe Sent: Wednesday, January 10, 2007 11:59 To: [email protected] Subject: [fme] Re: Query or Search attribute with LIKE clause I think the Grepper is the way to go. Just searching for VIEW should work OK. ^VIEW would match a value starting with VIEW and $VIEW would match a value ending with VIEW Mark --- In [email protected], <[EMAIL PROTECTED]> wrote: > > Hi, > > How can I do a query on attributes with an equivalent of a "LIKE clause" in FME Workbench (Tester, Grepper or whatever)? > > Exemple, I have this values: > ---------------------------- > IDVIEW > VIEW# > IDVIEW# > TOTO > TATA > TITI > VIEWED > VIEW > > And I want to search all the attributes which contain the value *view* and I want the result: > IDVIEW > VIEW# > IDVIEW# > VIEWED > VIEW > > I don't want to use a "EQUAL clause" because I'm ignoring all the possibilities of the values in my database. > > Thanks in advance, > > > Jean-François Beaudry > Technicien en géomatique > > Hydro-Québec > Traitement des données à référence spatiale Géomatique Direction > principale - Expertise > Place Dupuis, 9e étage Tél. : (514) 840-3000, > 855, rue Sainte-Catherine Est poste 4230 > Montréal (Québec) H2L 4P5 Téléc. : (514) 840-4233 > [EMAIL PROTECTED] www.hydroquebec.com > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
