Hi
I'm using a triming function to trim a lot of unwanted characters in my data and after triming all these characters I also need to concatenate the column data with a number 20, but the concatenation does not happen. Is there a better way of achieving the result?
Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim
(Column_Name),'','L'),'#','L'),'+','L'),'.','L'),'//','L'),'/','L'),'\','L'),'`','L'),'','L'),'','T'),'*','L'):20
Trimmimg and concatination
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try putting the right hand operand for the concatenation operator in quotes.
Use a single Convert() function to get rid of the unwanted characters.
Code: Select all
Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim
(Column_Name),'','L'),'#','L'),'+','L'),'.','L'),'//','L'),'/','L'),'\','L'),'`','L'),'','L'),'','T'),'*','L'):'20'
Code: Select all
Convert('#+./\`.*', '', InLink.ColumnName) : "20"
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: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
If your derivation ends with then the 20 will be added to the end of the string.
Code: Select all
:"20"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom