Topic: Can't link to string because of spaces Posted: 23 Jun 2015 at 8:16am
I have an excel spreadsheet with a list of part numbers (text) and list of codes (text).
The codes are a 2 digit number for example: 13.
The problem is in the Oracle database (JDEdwards) the Code field is a 24 character string field, stored as 10-spaces followed by the 2-digit code, for example: " 13" with no trailing spaces.
I know I can enter the 10 space prefix in the excel file but I want to make it easy on other users to just load part numbers and codes into the excel file and run their crystal report without making them add blank spaces.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum