That’s exactly what is was looking for! There is no samples in the help file and I could not figure it out.
Thx Dan Goldberg From: 'James Bentley' via RBASE-L <[email protected]> Sent: Friday, February 7, 2020 7:39 AM To: [email protected] Subject: Re: [RBASE-L] - RE: display format in a variable Dan Try the following set var vCurAmt currency = 1,975.32 set var vFmtAmt text = ((FORMAT(.vCurAmt*100,'[-]000000000'))) Sho Var v% result: vCurAmt = $1,975.32 CURRENCY vFmtAmt = 000197532 TEXT Jim Bentley, American Celiac Society 1-504-305-2968 On Thursday, February 6, 2020, 3:03:25 PM CST, Stephen Markson <[email protected]<mailto:[email protected]>> wrote: R> SET VAR vTextAmount TEXT='$1,975.32' R> SET VAR vResult TEXT=(SFIL('0',9-SLEN(CTXT(INT(100*FLOAT(.vTextAmount)))))+CTXT(INT(100*FLOAT(.vTextAmount)))) R> SHOW VAR vResult 000197532 Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Dan Goldberg Sent: February 6, 2020 3:01 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - display format in a variable I need to right justified a currency in a text variable and need help on th= e format function. If I have an amount: $975.32 I need to display it in the variable as: 000097532 I see in the help I can right justify and use 0 as blanks but not sure on h= ow to write it. TIA Dan Goldberg -- For group guidelines, visit https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.rbase.com%2fsupport%2fusersgroup_guidelines.php&c=E,1,kmS--UE8xiyjbAokada_mxEUA7U1kXjMEBOthlLtndw3G9GPcnfpFHtwSkAzyf_HNYhYsVl4CkrHcR894W3NvPmbAM3EigAN5sDZcXa78z_R&typo=1 --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].<mailto:[email protected].> To view this discussion on the web visit https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2frbase-l%2f2E4830CEC16615458329D3D83342F8D0014303856B%40exchange11.&c=E,1,_2gMOKyRwu0LtcX_QTcOmrY6DxV7o7i46Sue6cCyAKMB70o2ZHm0WyZbDm9uv0vyZAs3eobQiOHsF_Cp497iETiqwzYQRrGQMfp1S8dAdvIeOk_G2jc,&typo=1 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].<mailto:[email protected].> To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/YQBPR0101MB1777F0C95631B6C1CB6F52F7D61D0%40YQBPR0101MB1777.CANPRD01.PROD.OUTLOOK.COM. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1905448292.892390.1581089917967%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/1905448292.892390.1581089917967%40mail.yahoo.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014303B530%40exchange11.
