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