Posts tagged with 'trim', page 1 of 1

trim

ADODB Code to Trim Text Fields

April 20, 2013 by JP

Updated code to trim all text fields in a MS Access database

December 11, 2012 by JP

Comments

This is a guest post from Eric @ http://ventre-a-pattes.net/.

I loved your TrimAllTextFieldsAllTables [Editors note: See original post], but it fails if some tables have no text fields. Attached is a slightly modified version that fixes the issue.

Thanks again.

Continue Reading »

Filed Under: Access, VBA

Tagged With: SQL, trim

Trim all text fields in MS Access database

July 20, 2011 by JP

1 Comment(s)

I recently had a need to trim fields in a table in one of the databases I use. Borrowing code from a newsgroup post, I was able to come up with VBA code to trim all the text fields in all the tables in a database (2003 MDB).

Filed Under: Access

Tagged With: database, field, trim

Clean up your Worksheet

June 6, 2011 by JP

3 Comment(s)

In Which macro shortcut keys do you use I posted the code I use to clean up my worksheets. Since then I've revised the code somewhat. The fact that my computer crashed and I lost my personal.xls workbook had absolutely nothing to do with this decision.

Filed Under: Excel

Tagged With: autofilter, trim, zoom

Formatting Zip+4 Codes

January 25, 2008 by JP

1 Comment(s)

If you have a column of zip+4, this macro will remove the suffix. Simply highlight the cells in question. It will skip any zip codes that don't have the suffix. It uses the Left$ string function which is more efficient than the standard Left() and always returns the first 5 characters in the cell.

Filed Under: Excel, VBA

Tagged With: Excel, trim, VBA, zip codes