Thx. did not know about the SFIL function! Dan Goldberg
-----Original Message----- From: [email protected] <[email protected]> On Behalf Of Stephen Markson Sent: Thursday, February 6, 2020 1:03 PM To: [email protected] Subject: [RBASE-L] - RE: display format in a variable 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] <[email protected]> On Behalf Of Dan Goldberg Sent: February 6, 2020 3:01 PM To: [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]. 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]. 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D00143038798%40exchange11.
