Ask Your Question

Trim all values in a record

asked 2018-10-22 22:52:11 -0500

anonymous user


I have a file with above 100 columns delimited with '|'. for each and every column there are trailing spaces. SO i want to trim spaces for all records without explicitly configuring trim to each and every column.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-10-24 10:40:51 -0500

iamontheinet gravatar image


You can use Field Replacer with the following Replacement rules:

Fields: /*

New value: ${str:trim(record:value(f:path()))}

This will trim leading and trailing white space characters from all column values.

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-22 22:52:11 -0500

Seen: 3,110 times

Last updated: Oct 24 '18