Good afternoon, Setting the "Quote Output Values" setting to No solved my problem. Many thanks for letting me know about this setting; I didn't know it existed.
Regards JD --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > 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" <hemsidan@> 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/
