Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ashwikal
Contributor II
Contributor II

want to replace particular delimiter

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

1 Solution

Accepted Solutions
jerifortune
Creator III
Creator III

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

View solution in original post

5 Replies
vishsaggi
Champion III
Champion III

may be try like,

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

ashwikal
Contributor II
Contributor II
Author

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
Creator III
Creator III

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

patrickbarry
Contributor
Contributor

Try

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

ashwikal
Contributor II
Contributor II
Author

Yes it worked..thanks!