>>>Hi
>>>
>>>I have a string like
>>>
>>>"IOBJ_IX I,PROJE_T_IX I,PARENT_IX I,ITYP I,ISUBTYP I"
>>>
>>>and would like to transform it to
>>>
>>>"IOBJ_IX I,PROJE_T_IX I,PARENT_IX I,ITYP I,ISUBTYP I".
>>>
>>>IOW I like to reduce multiple occurences of Space to one Char.
>>>
>>>What is the best command to use?
>>>
>>>TIA
>>
>>Agnes
>>
>>
>>cStr = "ABC XYZ 123"
>>? StrTran(cStr, " ", " " )
>>
>
>Hi Jos,
>
>Yes, thats correct. But this works for double only. If they are tripple or higher it fails.
>ok.
>
Agnes
In this case I think you will need to use a loop to process the source string checking for consecutive spaces and remove them from a destination string?
HTH
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.