Want to remove the space from a file

psriv20 · New User Joined: 25 May 2009 Posts: 19 Location: Pune

I have a big file which is work as input file for a program A. I ran the the job and it is giving SOC7. I analysed it and found that at cols 45 to 48 expected value should be numeric but there is some space. I want to remove the spaces.

For ex.
Current file:
AAAAAAAA BBBBBBBBBBB

I want
AAAAAAAABBBBBBBBBBB

Thanks

prahalad · New User Joined: 14 Sep 2010 Posts: 18 Location: Pune

It seems that you want to shift data if there are spaces from pos 45 to 48.
If I am wrong then please correct me.
You can do it using SORT. Please use the following code:

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

psriv20,
What do you want to replace SPACES with? Do you want to reduce LRECL incase you find spaces?

For Example, all 4 bytes are spaces and assuming your input LRECL is 80, do you want to reduce LRECL to 76 or do you need initialize with some numeric?

Thanks,

psriv20 · New User Joined: 25 May 2009 Posts: 19 Location: Pune

Yes ...

dick scherrer · Posted: Mon Sep 27, 2010 9:52 pm

Hello,

If you actually want help, suggest you answer questions completely. . .

daveporcelan · Posted: Mon Sep 27, 2010 11:27 pm

I found it strange that the example removes spaces (non-numeric) and
replaces it with BBBB (also non-numeric)

Poor example?