topic Re: How to delete spaces in Header of .csv? in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-delete-spaces-in-header-of-csv/m-p/15037#M763 <HTML><HEAD></HEAD><BODY><SPAN>I know this is a little old, but I figured it would be worth answering this for future users with the same question.</SPAN><BR /><BR /><SPAN>Try using the 'calculate field' tool and use the 'Trim' function:</SPAN><BR /><BR /><SPAN>Trim([FIELD NAME])</SPAN><BR /><BR /><SPAN>This will trim spaces from the beginning and end of the text.</SPAN><BR /><BR /><SPAN>For other useful field calculator operations check out: </SPAN><A _jive_internal="true" href="https://community.esri.com/www.esri.com/news/arcuser/0405/files/fieldcalc_1.pdf ">Field Calculator Unleashed</A></BODY></HTML> Wed, 25 Apr 2012 22:34:11 GMT AaronTirrell 2012-04-25T22:34:11Z How to delete spaces in Header of .csv? https://community.esri.com/t5/data-management-questions/how-to-delete-spaces-in-header-of-csv/m-p/15036#M762 <HTML><HEAD></HEAD><BODY><SPAN>I am using model builder and want to import and join two tables.&nbsp; The tables have spaces in the header (i.e. " Drawing Name") that muck up arcmap.&nbsp; Is there any way in modelbuilder to correct the header before I attempt to import the table?&nbsp; I'm a very basic user of python and I'm sure there is a scripting way to do it, but would prefer if at all possible to stick with modelbuilder.&nbsp; Thanks!</SPAN><BR /><BR /><SPAN>**sorry I didn't realize I had posted this in the wrong forum, I have reposted in Geoprocessing and would delete this post if I knew how!**</SPAN></BODY></HTML> Tue, 31 May 2011 05:13:45 GMT https://community.esri.com/t5/data-management-questions/how-to-delete-spaces-in-header-of-csv/m-p/15036#M762 CelinaThom 2011-05-31T05:13:45Z Re: How to delete spaces in Header of .csv? https://community.esri.com/t5/data-management-questions/how-to-delete-spaces-in-header-of-csv/m-p/15037#M763 <HTML><HEAD></HEAD><BODY><SPAN>I know this is a little old, but I figured it would be worth answering this for future users with the same question.</SPAN><BR /><BR /><SPAN>Try using the 'calculate field' tool and use the 'Trim' function:</SPAN><BR /><BR /><SPAN>Trim([FIELD NAME])</SPAN><BR /><BR /><SPAN>This will trim spaces from the beginning and end of the text.</SPAN><BR /><BR /><SPAN>For other useful field calculator operations check out: </SPAN><A _jive_internal="true" href="https://community.esri.com/www.esri.com/news/arcuser/0405/files/fieldcalc_1.pdf ">Field Calculator Unleashed</A></BODY></HTML> Wed, 25 Apr 2012 22:34:11 GMT https://community.esri.com/t5/data-management-questions/how-to-delete-spaces-in-header-of-csv/m-p/15037#M763 AaronTirrell 2012-04-25T22:34:11Z