Transforming a number

if i wanted to show on a frinted for the last 4 digits of an account nuber or
a ssno number or any number, what is the best way to do this. Transform does
not seem to be the correct function.

BrianHiatt
Mon Feb 06 15:36:11 CST 2006

Tom,
How about RIGHT() for STR(RIGHT()).
Look in the help screens and it will explain how it works.
Hope this helps.
Brian Hiatt

"Tom" wrote:

> if i wanted to show on a frinted for the last 4 digits of an account nuber or
> a ssno number or any number, what is the best way to do this. Transform does
> not seem to be the correct function.

Cindy
Mon Feb 06 17:29:28 CST 2006

Hi Tom,

? Right(Alltrim("123-45-6789"), 4)
? Right(Alltrim(Transform(12345)), 4)
? Right(Alltrim(Str(12345)), 4)

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com


"Tom" <Tom@discussions.microsoft.com> wrote in message
news:79D38B06-3D3B-4C28-A370-E5480E1C30BD@microsoft.com...
> if i wanted to show on a frinted for the last 4 digits of an account nuber
> or
> a ssno number or any number, what is the best way to do this. Transform
> does
> not seem to be the correct function.

Tom
Tue Feb 07 10:04:28 CST 2006

thanks for the advice. i ended up doing this. and it works nicely

l=len(allt(account))
A=repl('x',l-4)+substr(account,l-3,4)
lreturn=allt(A)

"Cindy Winegarden" wrote:

> Hi Tom,
>
> ? Right(Alltrim("123-45-6789"), 4)
> ? Right(Alltrim(Transform(12345)), 4)
> ? Right(Alltrim(Str(12345)), 4)
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "Tom" <Tom@discussions.microsoft.com> wrote in message
> news:79D38B06-3D3B-4C28-A370-E5480E1C30BD@microsoft.com...
> > if i wanted to show on a frinted for the last 4 digits of an account nuber
> > or
> > a ssno number or any number, what is the best way to do this. Transform
> > does
> > not seem to be the correct function.
>
>
>

AA
Thu Feb 09 05:51:11 CST 2006

Except it crashes if there are less than 4 digits.
-Anders

"Tom" <Tom@discussions.microsoft.com> skrev i meddelandet
news:C5CC3411-B9C5-4B07-8146-57623341E056@microsoft.com...
> thanks for the advice. i ended up doing this. and it works nicely
>
> l=len(allt(account))
> A=repl('x',l-4)+substr(account,l-3,4)
> lreturn=allt(A)
>
> "Cindy Winegarden" wrote:
>
>> Hi Tom,
>>
>> ? Right(Alltrim("123-45-6789"), 4)
>> ? Right(Alltrim(Transform(12345)), 4)
>> ? Right(Alltrim(Str(12345)), 4)
>>
>> --
>> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
>> cindy_winegarden@msn.com www.cindywinegarden.com
>>
>>
>> "Tom" <Tom@discussions.microsoft.com> wrote in message
>> news:79D38B06-3D3B-4C28-A370-E5480E1C30BD@microsoft.com...
>> > if i wanted to show on a frinted for the last 4 digits of an account
>> > nuber
>> > or
>> > a ssno number or any number, what is the best way to do this. Transform
>> > does
>> > not seem to be the correct function.
>>
>>
>>

Tom
Thu Feb 09 11:39:26 CST 2006

Geeze, i didnt even look at that. and then i just happened to find one..
Great. thanks Anders. lol

"AA" wrote:

> Except it crashes if there are less than 4 digits.
> -Anders
>
> "Tom" <Tom@discussions.microsoft.com> skrev i meddelandet
> news:C5CC3411-B9C5-4B07-8146-57623341E056@microsoft.com...
> > thanks for the advice. i ended up doing this. and it works nicely
> >
> > l=len(allt(account))
> > A=repl('x',l-4)+substr(account,l-3,4)
> > lreturn=allt(A)
> >
> > "Cindy Winegarden" wrote:
> >
> >> Hi Tom,
> >>
> >> ? Right(Alltrim("123-45-6789"), 4)
> >> ? Right(Alltrim(Transform(12345)), 4)
> >> ? Right(Alltrim(Str(12345)), 4)
> >>
> >> --
> >> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> >> cindy_winegarden@msn.com www.cindywinegarden.com
> >>
> >>
> >> "Tom" <Tom@discussions.microsoft.com> wrote in message
> >> news:79D38B06-3D3B-4C28-A370-E5480E1C30BD@microsoft.com...
> >> > if i wanted to show on a frinted for the last 4 digits of an account
> >> > nuber
> >> > or
> >> > a ssno number or any number, what is the best way to do this. Transform
> >> > does
> >> > not seem to be the correct function.
> >>
> >>
> >>
>
>
>