**CLOSED Convert an integer to a string for a JOIN

[robert fuschetto]

I need to convert an INT master file column to an A20 in a DEFINE so I can Join it to another table.

Integer values range from 1 - 999. No matter what I have tried the character conversion comes out wrong..typically leading zeros dissapear etc. I just want the number 1,2,3...10,11,12...100,101,102 etc.

[Patrick Huebgen]

DEFINE FILE CAR

RCOST_A/A15 = FTOA(RCOST, '(D12.2)', RCOST_A);

ALPHA_SALES/A20=EDIT2(SALES,'I11');

END

 

TABLE FILE CAR

 

BY HIGHEST SALES

BY HIGHEST ALPHA_SALES

BY HIGHEST RCOST

BY HIGHEST RCOST_A

 

BY COUNTRY

END

[Brent Mason 2]

DEFINE FILE ggsales

UNITS_FORMAT/A20 = FPRINT(UNITS, 'I08');

END

 

TABLE FILE ggsales

PRINT UNITS UNITS_FORMAT

END

[David Beagan]

Hi Robert, be aware that the examples above can have leading spaces in the A20 result, even though it might not look like it in the HTML output. These leading spaces can be a problem. You can explicitly either right justify or left justify the value of the A20 defined field to match the field you are joining to. You can use the RJUST or LJUST functions to do this.

Documentation link: Using Functions Manual