Hi All,
I have a requirement to trim i.e, remove single quote ' and double quote " from a string.
How can I do this.
I tried the following
Trim (string,'"','A') and also Trim(string,''','A')
But this does not work.
Any help.
Thanks
Devi
Trim ' and "
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
In Server would work but I don't know if that applies to PX transforms. If not, use
Code: Select all
TRIM(\"'\,'A')
Code: Select all
TRIM(CHAR(34):CHAR(39),'A')
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Does backslash work as a quote character? If so you can have
Code: Select all
Convert(\'"\,\\,InLink.TheColumn)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.