topic Trim all fields on load in QlikView https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161840#M35580 <HTML><HEAD></HEAD><BODY><P>Try using RTrim(LTrim(FieldName) as FieldName</P><P></P><P>Thanks...</P></BODY></HTML> Tue, 15 Mar 2011 14:19:00 GMT amars 2011-03-15T14:19:00Z Trim all fields on load https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161839#M35579 <HTML><HEAD></HEAD><BODY><P>I need to trim all fields I receive in my load script.</P><P>Unfortunately LOAD trim(*) as * is not an option.</P><P>At this time I need to adjust the script for many field from 'fieldname' to trim('fieldname') as 'fieldname'. A tedious work.</P><P>I've looked around for some smart search and replace editor but no luck.</P><P>Any ideas?</P><P></P></BODY></HTML> Tue, 15 Mar 2011 14:13:13 GMT https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161839#M35579 2011-03-15T14:13:13Z Trim all fields on load https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161840#M35580 <HTML><HEAD></HEAD><BODY><P>Try using RTrim(LTrim(FieldName) as FieldName</P><P></P><P>Thanks...</P></BODY></HTML> Tue, 15 Mar 2011 14:19:00 GMT https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161840#M35580 amars 2011-03-15T14:19:00Z SV:Re: Trim all fields on load https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161841#M35581 <HTML><HEAD></HEAD><BODY><P>Sorry, but how does that Help me?</P></BODY></HTML> Tue, 15 Mar 2011 15:59:39 GMT https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161841#M35581 2011-03-15T15:59:39Z Re: SV:Re: Trim all fields on load https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161842#M35582 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 29 Jun 2012 15:21:45 GMT https://community.qlik.com/t5/QlikView/Trim-all-fields-on-load/m-p/161842#M35582 2012-06-29T15:21:45Z