[mapguide-users] Label Expressions - replaceall

[GordonL]

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
> <gordon.luckett at arrowgeomatics.com> 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 <zac.spitzer at gmail.com>
>>> 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 <jumpinjackie at gmail.com>
>>>> 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
>>>>>> mapguide-users at lists.osgeo.org
>>>>>> 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
>>>>> mapguide-users at lists.osgeo.org
>>>>> 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
>>> mapguide-users at lists.osgeo.org
>>> 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
>> mapguide-users at lists.osgeo.org
>> 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
> mapguide-users at lists.osgeo.org
> 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.