Datablade List Forum

Re: commas in 1000s

Posted By: Donald Payne
Date: Thursday, 22 May 2003, at 10:50 a.m.

In Response To: commas in 1000s (Janine Marriott)

Sorry, don't know any easy way.
The solutions I would try are:

- If using the Web Blade, you could write a tag, say
<?fmtInt intVal="...">
that uses variable processing functions $(STRLEN), $(SUBSTR) and $(CONCAT)
in a loop to build the formatted string:
copy last three (or fewer) digits to new string
While (there are more digits to copy):
prefix new string with comma
copy previous three or fewer digits to new string
done
display new string

- Write a UDR in SPL, using built-in functions LENGTH(), SUBSTR() (or
SUBSTRING()) and concat.
- copy integer to varchar
- Copy last 3 digits to new varchar
- While there are more digits, etc.

- Write a UDR in C, using the standard C library function sprintf().
_Something_ like this [untested!]:

CREATE FUNCTION addCommas (x integer)
RETURNING lvarchar
WITH (not variant, parallelizable)
EXTERNAL FILE
'$INFORMIXDIR/extend/myBlades/addCommas.bld(addCommas_int)
;

addCommas.c:

mi_lvarchar *addCommas_int (mi_integer x)
{
char *c;
mi_lvarchar s = mi_new_var(15); /* for 4-byte int as string, plus
terminating NULL (\0); ~double for INT8 */
c = mi_get_vardata(s);
sprintf(c, "%,i", x);
mi_set_varlen(s, strlen(c)); /* strlen should be at least one
less than 15 */
return s;
}

HTH.
Regards,
- Don

Donald E. Payne -- Sr. IT Specialist
OLTP Practice, Data Management Services, Software Group, IBM
phone / fax / pager 1-212-745-4380 (internal 243-4380)
mobile office: New York, NY
mailing address: 13 Myrtle Ave., Huntington, NY 11743-3506
Certified IBM Informix Professional
http://www.ibm.com/software/data




"Janine Marriott" <bill.marriott@optusnet.com.au>
Sent by: forum.subscriber@iiug.org
05/22/2003 06:59 AM


To: datablade-list@iiug.org
cc:
Subject: commas in 1000s [23]



Hi Everyone,

Just a short question on formatting output.
Does anyone know an easy way to format an integer field so that 1000 =
appears as 1,000
or 1000000 like 1,000,000 when outputted to a browser window?

thanks

Bill

Messages In This Thread

• commas in 1000s
  Janine Marriott -- Thursday, 22 May 2003, at 6:59 a.m.
  • Re: commas in 1000s
    Donald Payne -- Thursday, 22 May 2003, at 10:50 a.m.
  • Re: commas in 1000s
    Janine Marriott -- Friday, 23 May 2003, at 6:21 p.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.