trimming columns when RCP is enabled

[Pratibha_Upadhye]

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

[samyamkrishna]

You should be able to do it by using the Trim(Columnname) function.

[ray.wurlod]

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.

[Sreenivasulu]

You can use the trim(columnname) function and if that column name is present in the input then it gets applied.

Regards
Sreeni

[meet_deb85]

Hi Ray,

But there has to be some way by which i can take this entire row in one string through a column export stage, and the try to remove all the whitespaces after the the delimiter "~".

I guess in this case the whitespace between the characters need to be kept within the string.

[ray.wurlod]

Only if the column is named. You can't do it with RCP.