View previous topic :: View next topic
|
Author |
Message |
southee
New User
Joined: 17 Jun 2012 Posts: 20 Location: INDIA
|
|
|
|
Hi,
I need to remove additional spaces in a record. These recrds contains spaces and the number of spaces depends on the Field length
i have records in below format :-
CITY (21 length) <-20 SPACES-> STATE(3) <-1 SPACES> ZIP(10 digit)
for example
Quote: |
AVENTURA <-20 SPACES-> FL 331802795
LAWRENCEVILLE <-20 SPACES-> GA 300443783
HALLANDALE BEACH <-20 SPACES-> FL 330097236 |
I want to get rid of those 20 spaces and replace a single space. the 20 spaces is always not the case.. it may change
like the output should be something like
Quote: |
AVENTURA FL 331802795
LAWRENCEVILLE GA 300443783
HALLANDALE BEACH FL 30097236
|
Pls let me know if i can use squeeze option to remove spaces and replace with a single space. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Like this one? Another question from today... |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
since You can post You have also internet connection,
send a PM to Kolusu asking for help
or look at his email address using the IBM employee directory |
|
Back to top |
|
|
|