Convert double character into single

[dsquest]

Hello,

This might have been discussed already. But I couldn't find anything close to my need.

I have the following.

Code: Select all

"|||abc|||def|hg"

I wanted it to be converted into

Code: Select all

"abc|def|hg"

I think I can remove the leading and trailing Pipes using Trim with 'B".

I have remove the duplicate intermediate pipes and replace into one.
FYI: Covert('||','|',input) isn't working.

[ray.wurlod]

If there are no space characters in your data (as per your example) you could convert the pipe characters to space characters, use a simple Trim() function (only one argument), then convert the space characters back to pipe characters.

Code: Select all

Convert(" ", "|", Trim(Convert("|",  " ",  InLink.TheString)))

[ArndW]

Code: Select all

TRIM("|||abc|||def|hg","|","R")

will do what you want.

[chandra.shekhar@tcs.com]

Ray, I must say that your solution is fantastic. :D

[priyadarshikunal]

Ray,

Why do we need two converts, I believe trim with R should do the work. also suggested by Arnd.

[dsquest]

Thanks AndrW! It worked!.

[ray.wurlod]

I'd forgotten the "R" option for Trim(). It's not an option I use very often.