Char values automatically left justified building an array

[Rick Lipkin]

To All

I have a Sql Primary key value that is char(18) .. When I generate a random key I sometimes get a value like this with leading and trailing spaces .. and that is fine.

Code: Select all  Expand view

aEmp := {}

cName := "Rick Lipkin"
cEid     := "     12345678    "    

AAdd( aEmp, {cName,cEid} )
 

When I go to load the above character value cEid into an array the char value is truncated and loads as a left justified value .. similar to :

Code: Select all  Expand view

       A                 B
|Rick Lipkin    |12345678      |
 

Is there a way to initialize the array to accept the 'exact' value I am loading to the array element ?

Thanks
Rick Lipkin

[nageswaragunupudi]

When I go to load the above character value cEid into an array the char value is truncated and loads as a left justified value

No. The value is not trimmed. Please check again.