Trim all fields on load

[#1]

I need to trim all fields I receive in my load script.

Unfortunately LOAD trim(*) as * is not an option.

At this time I need to adjust the script for many field from 'fieldname' to trim('fieldname') as 'fieldname'. A tedious work.

I've looked around for some smart search and replace editor but no luck.

Any ideas?

[amars]

Try using RTrim(LTrim(FieldName) as FieldName

Thanks...

[#3]

Sorry, but how does that Help me?

[#4]

Have you found any ideas? I have a similar issue that I need to trim only the right for every single field in my script. I know currently there is Verbatim that can be set to keep or remove trailing and leading spaces, but I have not seen any options to do only one side.