>hi all. it's the end of the day and i want to go home. please somebody help me!!! here's what i have:
>
>lc_variable = 123-456-7890
>
>i have a DO WHILE that runs through this variable and looks at each character. if the character is not = to a -, it replaces the character with a 0. for example, the first character is a 1, so it looks at that,
>sees it's not a -, and then attempts to replace it with a 0. i would like my end result to be 000-000-0000. but, i dont' know how to do the REPLACE part of the code. any clues?
The code below will replace any characters but "-" with "0"
lc_variable = "123-456-7890"
lcTemp = CHRTRAN(lc_variable, "-", "")
lcResult = CHRTRAN(lc_variable, lcTemp, REPLICATE("0", LEN(lcTemp)))
--sb--