Formatting with Printf

[cjohnman]

I am using the for loop below to print records from a database table to the users screen. I am having problems displaying the results in a lined up view. The data types are also below with a screen shot of how messy it currently looks. Any help is greatly appreciated getting this in a better formatted view.

/* PRINT TO SCREEN */
/*READ ALL RECORDS FOUND IN TABLE - TOTAL IS STORED IN variable COUNT*/
 for( x = 0; x < row_count; x++ )
  {
printf("COST CENTER:  LOCATION:   DESCRIPTION:        GROUP NUMBER:\n");
printf("%-14d         %-11s       %-20s               %s\n",  cc_lkup2[x].cc,  cc_lkup2[x].cc_sn,  cc_lkup2[x].cc_desc,  cc_lkup2[x].cc_grp);
  }

return (0);
}

Column Name            Type       Length Nulls Defaults
cc                               integer         2    no      no     
cc_sn                         varchar        10   no     yes     
cc_desc                      varchar        40   no     yes     
cc_grp                        varchar        40   no     yes

Screenshot of current output:

COST CENTER: LOCATION: DESCRIPTION: GROUP NUMBER:
249 BLDG 30 30 WASTE TREATMENT BUILDING
COST CENTER: LOCATION: DESCRIPTION: GROUP NUMBER:
518 127 MILL 127 TEMPER MILL ROLLING
COST CENTER: LOCATION: DESCRIPTION: GROUP NUMBER:
808 CHROMAGRAP OUTSIDE PROCESSOR - CHROMAGRAPHICS OUTSIDE PROCESS
COST CENTER: LOCATION: DESCRIPTION: GROUP NUMBER:
812 LYONS SLIT OUTSIDE PROCESSOR - LYONS SLIT OUTSIDE PROCESS
COST CENTER: LOCATION: DESCRIPTION: GROUP NUMBER:
526 NO 2 NORM NO. 2 NORMALIZER ANNEALING
COST CENTER: LOCATION: DESCRIPTION: GROUP NUMBER:
591 LOAD/SHIP LOADING & SHIPPING INSP., SHIP., STORAGE & DISTRIBUTION

[hk_mp5kpdw]

That's not a screen shot and dumping "output" into an unformatted (no code tags) portion of your post doesn't really help us to truly see that the output is indeed messy.

[matsp]

COST CENTER:  LOCATION:   DESCRIPTION:        GROUP NUMBER:
249                    BLDG 30           30 WASTE TREATMENT                 BUILDING
COST CENTER:  LOCATION:   DESCRIPTION:        GROUP NUMBER:
518                    127 MILL          127 TEMPER MILL                    ROLLING
COST CENTER:  LOCATION:   DESCRIPTION:        GROUP NUMBER:
808                    CHROMAGRAP        OUTSIDE PROCESSOR - CHROMAGRAPHICS               OUTSIDE PROCESS
COST CENTER:  LOCATION:   DESCRIPTION:        GROUP NUMBER:
812                    LYONS SLIT        OUTSIDE PROCESSOR - LYONS SLIT               OUTSIDE PROCESS
COST CENTER:  LOCATION:   DESCRIPTION:        GROUP NUMBER:
526                    NO 2 NORM         NO. 2 NORMALIZER                   ANNEALING
COST CENTER:  LOCATION:   DESCRIPTION:        GROUP NUMBER:
591                    LOAD/SHIP         LOADING & SHIPPING                 INSP., SHIP., STORAGE & DISTRIBUTION

I notice that cc_desc is varchar 40, but you allow 20 spaces for it.

--
Mats

[cjohnman]

I will change that to 40. Thanks for pointing that out. To rephrase my question a little. I want to print the first column with a width of 10 (due to heading), second column start one space after first and contain width of 10, third column start one space after second and have a width of 40, fourth column start one space after third and have width of 40. I hope that makes sense. Thanks.

[matsp]

Oh, and:

printf("%-14d         %-11s       %-20s               %s\n",  cc_lkup2[x].cc,  cc_lkup2[x].cc_sn,  cc_lkup2[x].cc_desc,  cc_lkup2[x].cc_grp);

should probably be:

printf("%-13d %-10s %-19s %s\n",  cc_lkup2[x].cc,  cc_lkup2[x].cc_sn,  cc_lkup2[x].cc_desc,  cc_lkup2[x].cc_grp);

Your spaces in the printf is being printed above and beyond the spaces needed to do the formatting.

--
Mats

[cjohnman]

/* PRINT TO SCREEN */
/*READ ALL RECORDS FOUND IN TABLE - TOTAL IS STORED IN variable COUNT*/
 for( x = 0; x < row_count; x++ )
  {
printf("COST CENTER: LOCATION:  DESCRIPTION:                             GROUP NUMBER:\n");
printf("%-12d %-10s %-40s %s\n",  cc_lkup2[x].cc,  cc_lkup2[x].cc_sn,  cc_lkup2[x].cc_desc,  cc_lkup2[x].cc_grp);
  }

return (0);
}