delimiter
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If your data are likely to contain single "<" or ">" characters prefer the Ereplace() function. This is not supplied by IBM for parallel jobs, but one of our posters has posted the code here on DSXchange.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And, if that assumption holds, you only need one Convert() function.
Code: Select all
Convert("<>"," ",InLink.TheName)
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.
-
- Participant
- Posts: 9
- Joined: Sun Jun 27, 2010 11:52 pm
I don't think that the field function is usable here. The FIELD() delimiter is a single character and not the 2-character sequence required here.venugopal.123 wrote:Use field function to remove <> in the column...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>