want to replace particular delimiter

[Anonymous]

I want to replace particular delimiter '#' with other i.e '~' from the field value. How can i do that ?

[vishsaggi]

may be try like,

Replace(Fieldname, '#', '~') AS NewReplacedField

[Anonymous]

Can I replace all the occurrences at once with this function? or do I need to use replace as many times the delimiter occurs?

PFB the kind of data I have

EB1D7C5EBA6B4F91B146ACFE5621C98E###5EBA6B4F91B146ACFE5###Initiate_Construction###In Progress######12123123333###EB1D7C5EBA6BOrder1213323###0###EB1D7C5EBA6B4F91B146ACFE5621C98X###EB1D7C5EBA6B4F91B146ACFE5621C98Y###iFrameworkAgreement1012###

[jerifortune · Accepted solution]

Replace('EB1D7C5EBA6B4F91B146ACFE5621C98E###5EBA6B4F91B146ACFE5###Initiate_Construction###In Progress######12123123333###EB1D7C5EBA6BOrder1213323###0###EB1D7C5EBA6B4F91B146ACFE5621C98X###EB1D7C5EBA6B4F91B146ACFE5621C98Y###iFrameworkAgreement1012###','###','~')

[Anonymous]

Try

Replace("XYZ",'-','') as "XYZ",

[Anonymous]

Yes it worked..thanks!