Skip to Content
0
Former Member
Sep 29, 2010 at 02:53 PM

Replace until to one character

286 Views

Hi,

i have the following string for example: 'B B B B'. Is it possible to replace three of them with SPACE and get only one 'B'?

The problem is that it is also possible to get only 'B B' or 'B'. There i should also get only one 'B'.

I tried this with the addition REPLACEMENT OFFSET but it doesn`t work because i do a CONDENSE after replacing and so the offset is always 0.

Any ideas?

Best regards,

Timo