Hi,
I am using the schema files to read the metadata using a sequential file stage and using RCP to propagate the columns furthur.
I have a condition where I have to trim the leading and trailing blank spaces of the delimted columns
before I load the data in the database.
Example:
Source data :
a~ b ~c ~ d e ~f
Target data :
a~b~c~d e~f
Please help
trimming columns when RCP is enabled
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Wed Nov 10, 2010 12:16 am
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: trimming columns when RCP is enabled
You should be able to do it by using the Trim(Columnname) function.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As soon as you need to perform some operation on a column that column must be named on the input link - it can not "magically" be produced there by RCP. That is, your Trim() function has to have an argument.
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.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: