Pipe delimited adding spaces for numeric columns

**dntel123** · 03-25-2011, 06:16 AM

Hey Guys,

I have a piece of code I'm using for creating a pipe delimited txt file:

Please Login or Register  to view this content.

I've checked through a few times and I can't see why it would be putting spaces in some of the values, so I thought if I post here someone may see soemthing that I missed.

Helps greatly appreciated!

Liam

**stanleydgromjr** · 03-25-2011, 06:38 AM

dntel123,

I can't see why it would be putting spaces in some of the values

Some of your original data may have extra leading/trailing space characters.

The bold in the following macro code should remove the extra space characters.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

**dntel123** · 03-25-2011, 06:57 AM

Thanks a lot buddy.

I'll give this a try and let you know how I get on and +rep accordingly

Pipe delimited adding spaces for numeric columns

LinkBack

Thread Tools

Rate This Thread

Display

Pipe delimited adding spaces for numeric columns

Re: Pipe delimited adding spaces for numeric columns

Re: Pipe delimited adding spaces for numeric columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions