Hi Jamison, In answer to #2, start with the doc for the TCLCaller transformer at http://www.fmepedia.com/index.php/TCLCaller
For your problem of querying two attributes with two other attributes, try regexp in a TCLCaller instead of the Grepper since you're limited to FME 2006GB. That version of the Grepper doesn't allow for attributes in the search string, and of course it's limited to just one expression. e.g. for TCLCaller, on one line: expr [regexp -nocase [FME_GetAttribute field1a] [FME_GetAttribute field1b]] + [regexp -nocase [FME_GetAttribute field2a] [FME_GetAttribute field2b]] The value returned should be 2 (both matched), 1, or 0 (no matches). Follow this with a Tester or ValueMapper. Regards, Dan Iseminger Safe Software --- In [email protected], "jamison_leach" <[EMAIL PROTECTED]> wrote: > > Good afternoon, > > Many thanks for your reply. I have two questions resulting from > this. #1--Do you know yet when the 2007 beta version will be official? > #2--Does anyone know of a good source of guidance in constructing TCL > scripts? I have not used them before. > > Regards, > Jamison D. Leach > > --- In [email protected], "mark2atsafe" <mark.ireland@> wrote: > > > > Hello Jamison, > > I tried this (in the 2007 beta) and you can select attribute1 as the > > attribute and attribute2 as the regular expression. The Grepper will > > then search for attribute2 within attribute1 (and either MATCH or NOT > > MATCH). > > > > Unfortunately I don't think you can do this in GB - with the Grepper > > at least. Can't think of another way (at the moment I'm sitting in one > > of the conference sessions and the speaker is making it difficult to > > concentrate) but obviosuly TCLCaller and a script would be one method. > > > > Mark > > > > Mark Ireland, Senior Product Specialist > > Safe Software Inc. Surrey, BC, CANADA > > support@ http://www.safe.com > > Solutions for Spatial Data Translation, Distribution and Access > > > > --- In [email protected], "jamison_leach" <hemsidan@> wrote: > > > > > > Good morning, > > > > > > I've been using FME Workbench for several weeks and came up with a > > > question regarding string querying. I need to select records from an > > > input dataset where the following condition is met: > > > > > > The value of <Attribute A> is contained within <Attribute B>. > > > > > > In this case, <Attribute A> will be a single character, and <Attribute > > > B> will be one or more characters. This can be accomplished using > > > 'LIKE' in SQL, but I can't figure out how to do it in Workbench. > > > > > > I've heard that Grepper could be used for this, but I can't see how to > > > accommodate both Attributes A and B with Grepper. > > > > > > Regards, > > > Jamison D. Leach 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/
