You might try the repl command: repl(!string,' ','')
this should replace a single space with no space

-----Original Message-----
From: Neil Armstrong [mailto:[log in to unmask]]
Sent: Friday, March 30, 2001 9:58 AM
To: [log in to unmask]
Subject: Re: Suprtool - Left trim right trim blanks in fields


Ken,

Suprtool 4.4 now has this functionality, your task would look like this:

get users
extract $rtrim(user-id)
extract "."
extract $ltrim(department-id)
output test,ascii
xeq

You can e-mail [log in to unmask] to be on the early list or ask
for the latest pre-release.

Sincerely,


Neil Armstrong
Senior Programmer
Robelle
----- Original Message -----
From: "Born, Ken" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Friday, March 30, 2001 9:42 AM
Subject: Suprtool - Left trim right trim blanks in fields


> Greetings,
> I want to concatenate a couple of fields using suprtool and write to a
file.
>
> >get users
> >extract user-id,".",department-id,":"
> >output test ascii
> >xeq
>
> This produces the following:
> 1351  .  373:
> 330   .  225:
> 327   .  346:
> 415   .  374:
>
> However, what I really want is something like
> 1351.373:
> 330.225:
> 327.346:
> 415.374:
>
> I was looking for a RTRIM command and LTRIM to string these two fields
> together.
> I briefly looked at the Suprtool book but was wondering if anybody knows
off
> the top of their head the commands to string these fields correctly
> together.
>
> Thanks in advance....