Sean Blackmon 2 Posted August 24, 2020 Share Posted August 24, 2020 What is the most effective way to remove double quote from a string in Tibco BW. I have an input string like this "http://somedatahere/08242020". I'm not really concerned with the first ", but rather how to remove the " that comes after 08242020. Trim does not work and I'm thinking some kind of substring function could work, however the data(08242020) will change with each input. Any reccomendations would be appreciated Link to comment Share on other sites More sharing options...
Mustapha Shaikh 4 Posted August 25, 2020 Share Posted August 25, 2020 you can use the function substring-before-last, if you want to remove the last double quotes. Link to comment Share on other sites More sharing options...
pavan uppalapati Posted August 26, 2020 Share Posted August 26, 2020 translate(,'"','') should work best. eg: translate('sample " test','"','') Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now