Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to replace particular delimiter '#' with other i.e '~' from the field value. How can i do that ?
Replace('EB1D7C5EBA6B4F91B146ACFE5621C98E###5EBA6B4F91B146ACFE5###Initiate_Construction###In Progress######12123123333###EB1D7C5EBA6BOrder1213323###0###EB1D7C5EBA6B4F91B146ACFE5621C98X###EB1D7C5EBA6B4F91B146ACFE5621C98Y###iFrameworkAgreement1012###','###','~')
may be try like,
Replace(Fieldname, '#', '~') AS NewReplacedField
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###
Replace('EB1D7C5EBA6B4F91B146ACFE5621C98E###5EBA6B4F91B146ACFE5###Initiate_Construction###In Progress######12123123333###EB1D7C5EBA6BOrder1213323###0###EB1D7C5EBA6B4F91B146ACFE5621C98X###EB1D7C5EBA6B4F91B146ACFE5621C98Y###iFrameworkAgreement1012###','###','~')
Try
Replace("XYZ",'-','') as "XYZ",
Yes it worked..thanks!