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
