Method Question

[Michael Bedar]

Ok, so if I understand it, If I want to filter out the "+" char, I  
could make a vFiled with a method like:

"REPLACE(origional_field, '+', '')"

If that's correct, how would you string 2 of these together?

"REPLACE(REPLACE(origional_field, '^', ''), '+', '')"  ???

Thanks for answering the newb questions.


On Mar 13, 2006, at 3:44 AM, Ruslan Zasukhin wrote:

> On 3/12/06 10:11 PM, "Michael Bedar" <mike at bedar.net> wrote:
>
> Hi Michael,
>
>> I have a VChar field that contains some values with special
>> formatting characters.  Is it possible to make a virtual filed that
>> will filter out these specific characters?
>>
>> For instance, I would like to filter out the "+" char, so that "aa 
>> +bbb
>> +ccc" would become  "aabbbccc" in the calculated field..
>>
>> Is something like this possible?
>
> I think yes.
>
> Please check in Valentina SQL.pdf or in our Wiki
>
> http://www.valentina-db.com/dokuwiki/doku.php? 
> id=paradigma:public:en:documen
> tation:vsql:reference:expr:expr
>
> List of available string functions. In case you will not find nothing
> suitable, let me know.
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina