Hi all,
I am genarating fixed with file and that file contains 2 columns.
Uniq char(4),Amt decima(8,2)
Output file i am getting is :
aaaa 000001.12
bbbb 000011.23
Required Output should be without space:
aaaa000001.12
bbbb000011.23
The problem here is Before decemal coumn i am getting one extra space.
I need to remove that space bec this is a fixed with file.
I tried many option with Stripwhitrspace and Trim functions,but still it is not removing.
Here I should not convert it in to Char ,it should be Decimal only.
Please help me on this.
Space in decimal number
Moderators: chulett, rschirm, roy
Space in decimal number
N R REDDY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Space in decimal number
Yes, you should. Flat files are just character data after all. Of course, make sure you're still writing out a valid decimal value but as noted, convert it to a string so you have full control over the formatting.raju4u wrote:Here I should not convert it in to Char ,it should be Decimal only.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers