>>Is there a quick way to remove blanks within a field? For example PART NUMBER = 'TRG 011 4TGH 77K' to become 'TRG0114TGH77K'
>>Thanks.
>
>Hi Timothy,
>
>Everyone's told you that using STRTRAN() is the solution to your problem, and, of course, they're right. I thought I'd give you another, related piece of advice about the function. I can't recommend your using a literal string here. It can make it hard to read. I'd suggest using either:
>
>lcnewstring = STRTRAN(yourstring, SPACE(1), "")
>
>or
>
>lcreplace = SPACE(1)
>lcnewstring = STRTRAN(yourstring, lcreplace, "")
>
>It's much more readable, and, therefore, maintainable.
>
>BTW, the third parameter isn't necessary. If it's eliminated STRTRAN() replaces the specified character with a "" anyway.
>
>hth,

What about STRTRAN(string,SPACE(1),SPACE(0))?