Whitespace added after every value
Moderators: chulett, rschirm, roy
Whitespace added after every value
Hi Gurus,
I have a input field coming all char data types and when i do a lookup against char datatype fields the lookup is failing becoz the values are coming along with spaces.
ex. char (3) input field - "30" when i do a look up for this field the data is getting rejected and the if i see the data in reject file it shows "30 "
I have tried using trim/stripwhitespaces/trimleadingand trailing.
I have the $APT_STRING_PADCHAR to 0x20 .
Not sure what is the problem..all the datatype as char fields....please help me out....
I have a input field coming all char data types and when i do a lookup against char datatype fields the lookup is failing becoz the values are coming along with spaces.
ex. char (3) input field - "30" when i do a look up for this field the data is getting rejected and the if i see the data in reject file it shows "30 "
I have tried using trim/stripwhitespaces/trimleadingand trailing.
I have the $APT_STRING_PADCHAR to 0x20 .
Not sure what is the problem..all the datatype as char fields....please help me out....
Chulett,
I have one more requirement ...is to pass a null field to validate a field.
So as mentioned in the previous issue if i passing field1 it is give as "30 " and for the requirement 2 if i pass null value in i/p it is taking as whitespace...not sure whats wrong with it.....
Can you let me know if there is a way to lookup vchar input field to char field in database.
I have one more requirement ...is to pass a null field to validate a field.
So as mentioned in the previous issue if i passing field1 it is give as "30 " and for the requirement 2 if i pass null value in i/p it is taking as whitespace...not sure whats wrong with it.....
Can you let me know if there is a way to lookup vchar input field to char field in database.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Whitespace added after every value
pandujoy wrote:I have the $APT_STRING_PADCHAR to 0x20 .
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:...You might be able to solve this by simply calling your input field a VARCHAR(3) instead.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Here in Germany, "PLZ" is the zip code, or "Postleitzahl".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>