Ask Your Question
0

Trim all values in a record

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

anonymous user

Anonymous

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
0

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

iamontheinet gravatar image

Hi!

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

Stats

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

Seen: 33 times

Last updated: Oct 24