I wonder if there might be a less ugly way to do this in LC instead of
SQL...
Pete
On Mon, Mar 19, 2012 at 2:04 PM, Marek <reichenbach.ma...@gmail.com> wrote:
> Thanks a lot! That helped me a lot man.
>
> Marek Reichenbach
>
> On 2012 Kov. 19, at 19:29, Ken Ray <k...@sonsothunder.com> wrote:
>
> >
> > On Mar 19, 2012, at 3:44 AM, Marek Reichenbach wrote:
> >> when i get for example: 1234567 -> i should get result +++++++, 123-56-
> I
> >> would get +++-++- .
> >
> > The only way I know is kind of ugly, requiring seven nested REPLACE
> statements:
> >
> > SELECT
> REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("123-56-","1","+"),"2","+"),"3","+"),"4","+"),"5","+"),"6","+"),"7","+")
> >
> > This would return:
> >
> > +++-++-
> >
> >
> > Ken Ray
> > Sons of Thunder Software, Inc.
> > Email: k...@sonsothunder.com
> > Web Site: http://www.sonsothunder.com/
> >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
--
Pete
Molly's Revenge <http://www.mollysrevenge.com>
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
