Hi Jamison, I tried this in both 2006-GB and 2007 beta versions, and it worked fine both times. What version are you using? If it is either of the above then please send me a sample of workspace that exhibits the problem. If it is earlier then I suggest you upgrade and try again.
Of course, the problem might occur on writing the data - which format are you writing to? If it's CSV then make sure you don't have the "Quote Output Values" setting turned on - or turn it on purposely instead of using the Concatenator. Hope this helps, Regards, Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "jamison_leach" <[EMAIL PROTECTED]> wrote: > > Good morning, > > I've encountered a similar problem as described below: I want to > add double quotes to the beginning and end of text strings. In the > Concatenator transformer, I type " as a constant and add it twice to > the "Concatenated Items" window (both before and after the attribute > (called FeatureName) holding my text string). > > The "Concatenated Items" window now looks like this: > > """ > FEATURENAME > """ > > This seems to make sense. In this window, the single set of double > quotes I actually > type in is itself put in double quotes, so there are three sets of > double quotes. > I would think that the Concatenator's result written to the output > attribute > would then be "WILLIAMS ROAD" or "MAPLE COURT" (depending on > what the actual FEATURENAME is). However, the output is actually > """WILLIAMS ROAD""", which I do not understand. Does anyone know how I > could just create single sets of double quotes using Workbench? I can > see that people have posted relevant information on this topic, but > TCL is used, and I know almost nothing about using TCL (apart from > pasting a line into the TCLCaller transformer). > > I even tried to use the Substring Extractor transformer to remove the > superfluous double quotes, but I'm not getting the results I want. > > Regards, > JD > > > > --- In [email protected], Graeme Hiebert <geh@> wrote: > > > > I feel your pain. The FME mapping file parser hasn't scaled as well > > over the years as other parts of FME. Workbench has eased the pain for > > most users, but there are still some of us fogies left who have to deal > > with this every day. :^) > > > > You were actually very close. The trick is that the FME parser gets a > > crack at the TCL program code before it is passed off to the TCL > > interpreter. Working backwards, what you want in TCL is > > > > regsub ... {"} FME_Attributes(INPUTVAL) > > > > To insert a quote into a quoted string in FME, you just have to precede > > it by a backslash. Thus, if your FME string read > > > > @TCL("regsub ... {\"} FME_Attributes(INPUTVAL)") > > > > FME would take everything between the outer quotes, replacing the \" > > with a simple ", to the TCL interpreter, and you would get what you > > want. > > > > Thus, the whole @TCL call should look like: > > > > @TCL("regsub $(casemac) -all {doublequote} > $FME_Attributes(INPUTVAL) > > {\"} FME_Attributes(INPUTVAL)") @Log("Output") > > > > (That's all on one line, of course.) > > > > -g > > -- > > On Saturday, August 30, 2003, at 07:56 PM, whitehousegis wrote: > > > > > FME'ers > > > > > > Reviewing several ways to produce double quotes I have experienced > > > difficulty producing double quotes. In the course of writing a look > > > up table from a mapping file to be used by another mapping file we > > > have run into difficulties writing double quotes. > > > > > > Below is a sample of the feature created and an effort to use TCL to > > > substitute doublequote with "". > > > > > > Any help would be greatly appreciated as I am stumped after looking > > > at TCL, the concatenate function and the workbench string replacer. > > > The function below works with other strings, just not "". > > > > > > > > > FACTORY_DEF * CreationFactory \ > > > FACTORY_NAME "Create Catch All Lookup Feature" \ > > > CREATE_AT_END \ > > > OUTPUT FEATURE_TYPE atend @SupplyAttributes > > > (INPUTVAL,"doublequote no") > > > > > > > > > MACRO casemac > > > > > > INCLUDE [ if { {no} == {no} } { puts {MACRO casemac -nocase}} ] > > > > > > FACTORY_DEF * > > > TeeFactory \ > > > FACTORY_NAME > > > STRINGREPLACER \ > > > INPUT FEATURE_TYPE > > > atend \ > > > OUTPUT FEATURE_TYPE DWGSTDLYRLOOKUP \ > > > @TCL("regsub $(casemac) -all {doublequote} $FME_Attributes > > > (INPUTVAL) {""} FME_Attributes(INPUTVAL)") > > > 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/
