Ask Your Question

Applying string functions to all fields

asked 2019-03-13 09:21:54 -0500

srinath_222 gravatar image


I have a requirement to apply string function (trim) to all the columns coming from source.

To apply string function to single column, it is like ${str:trim(record:value('/field1'))}. I need to hardcode 100 columns from source

Can I use this function to apply for all the fields ?

When I tried using ${str:trim(record:value('/'))} it is combining data from multiple fields in to a single field.

Please suggest us how to proceed.

edit retag flag offensive close merge delete


In the SDC 3.8 release, which is coming soon, there is a new processor (Field Mapper) that will make this task far simpler. Please stay tuned.

jeff gravatar imagejeff ( 2019-03-13 11:16:10 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2019-03-13 09:40:05 -0500

iamontheinet gravatar image


Use Field Replacer processor with Fields set to /* and New Value set to ${str:trim(record:value(f:path()))}.

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-13 09:21:54 -0500

Seen: 407 times

Last updated: Mar 13 '19