Hi Zac, no, the chr(13) or char(13) I could not figure out how to pass the ASCII to the expression.
I create a trigger in SQL Server to replace char(10) and char(13) with a '\n' in the dataset (it's a bit of a sledgehammer approach but it worked.) thanks gordon zspitzer wrote: > > i did the actual string manipulation outside FDO and thenrun every time. > saved it again, rather than as an expression which gets > > > if that didn't work, maybe try double quotes? > > z > > On Fri, Nov 13, 2009 at 2:34 AM, GordonL > <[email protected]> wrote: >> >> Hi Zac, >> where you replaced the linefeeds, did you do something like this? >> >> Translate(MYFIELD, chr(12), '\n') >> >> Do you know how to pass ASCII in the Expression for the tool tip? >> >> thanks >> gordon >> >> >> >> zspitzer wrote: >>> >>> that's really terribly explained, when I first saw "from-characterset" >>> with translate, I thought it was >>> something to do with code pages! >>> >>> Translate( <text property >, <from-characterset >, <to-characterset >) >>> >>> Would make more sense to humans as >>> >>> Translate( <text property >, <from-string>, <to-string>) >>> >>> I would like to see a fourth parameter, <repeat> 1 being the default, >>> 0 all or x number of times >>> >>> z >>> >>> On Thu, Jul 31, 2008 at 10:22 PM, Zac Spitzer <[email protected]> >>> wrote: >>>> ah, yep, strange name, that's why I missed it... >>>> >>>> turns out there's a bit more logic required to split a name nicely >>>> >>>> z >>>> >>>> On Thu, Jul 31, 2008 at 9:30 PM, Jackie C. Ng <[email protected]> >>>> wrote: >>>>> >>>>> FDO has the expression function Translate( <text property >, >>>>> <from-characterset >, <to-characterset > ) >>>>> >>>>> Is this available in mapguide? >>>>> >>>>> - Jackie >>>>> >>>>> >>>>> zspitzer wrote: >>>>>> >>>>>> Is there an expression with mapguide which can be used to do a >>>>>> replace >>>>>> all? >>>>>> >>>>>> I want to replace all newlines in a label with '\n' to split the >>>>>> words >>>>>> over multiple lines >>>>>> >>>>>> I couldn't see anything in studio >>>>>> >>>>>> z >>>>>> >>>>>> -- >>>>>> Zac Spitzer - >>>>>> http://zacster.blogspot.com (My Blog) >>>>>> +61 405 847 168 >>>>>> _______________________________________________ >>>>>> mapguide-users mailing list >>>>>> [email protected] >>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>>>> >>>>>> >>>>> >>>>> >>>>> ----- >>>>> http://themapguyde.blogspot.com >>>>> >>>>> http://www.linkedin.com/in/jackieng >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/Label-Expressions---replaceall-tp18748700p18752597.html >>>>> Sent from the MapGuide Users mailing list archive at Nabble.com. >>>>> >>>>> _______________________________________________ >>>>> mapguide-users mailing list >>>>> [email protected] >>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>>> >>>> >>>> >>>> >>>> -- >>>> Zac Spitzer - >>>> http://zacster.blogspot.com (My Blog) >>>> +61 405 847 168 >>>> >>> >>> >>> >>> -- >>> Zac Spitzer - >>> http://zacster.blogspot.com (My Blog) >>> +61 405 847 168 >>> _______________________________________________ >>> mapguide-users mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >>> >> >> -- >> View this message in context: >> http://n2.nabble.com/Label-Expressions-replaceall-tp1817399p3993541.html >> Sent from the MapGuide Users mailing list archive at Nabble.com. >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> > > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > http://www.ennoble.com.au > http://zacster.blogspot.com > +61 405 847 168 > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://n2.nabble.com/Label-Expressions-replaceall-tp1817399p3999227.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
