Tab Delimiter File
 

Hi guys,

I have this text file which is tab delimited.

The sample of the text file goes like this..


aaaa bbbb cccc dddd eeee

It looks fine..
i wrote a script to create a new worksheet in a excel..
but it turns out to be this in the worksheet

aaaa bbbb cccc dddd
eeee

any idea what is wrong?
i suspect the text file has a line feed after "dddd' that is causing
the problem


--
moonwalker
------------------------------------------------------------------------
moonwalker's Profile: http://www.excelforum.com/member.php...o&userid=31766
View this thread: http://www.excelforum.com/showthread...hreadid=514918

Tab Delimiter File
 

I'd open that text file in a text editor and verify what you believe.

Depending on what you find, you may have to just bite the bullet and fix the
text file.

moonwalker wrote:

Hi guys,

I have this text file which is tab delimited.

The sample of the text file goes like this..

aaaa bbbb cccc dddd eeee

It looks fine..
i wrote a script to create a new worksheet in a excel..
but it turns out to be this in the worksheet

aaaa bbbb cccc dddd
eeee

any idea what is wrong?
i suspect the text file has a line feed after "dddd' that is causing
the problem

--
moonwalker
------------------------------------------------------------------------
moonwalker's Profile: http://www.excelforum.com/member.php...o&userid=31766
View this thread: http://www.excelforum.com/showthread...hreadid=514918

--

Dave Peterson

Tab Delimiter File
 

ok..i think narrowing down the problem now

the text file looks like

aaa bbb ccc dddd

when i drag the text file to excel it opens up nicely

but when i use the Text Import Wizard set the delimiters and other
stuff, the worksheet became

aaa bbb ccc
ddd

any ideas?


--
moonwalker
------------------------------------------------------------------------
moonwalker's Profile: http://www.excelforum.com/member.php...o&userid=31766
View this thread: http://www.excelforum.com/showthread...hreadid=514918

Tab Delimiter File
 

Use a different text editor and find out what's in that text file.

I use a program called UltraEdit. It allows me to look at the text file in hex.

moonwalker wrote:

ok..i think narrowing down the problem now

the text file looks like

aaa bbb ccc dddd

when i drag the text file to excel it opens up nicely

but when i use the Text Import Wizard set the delimiters and other
stuff, the worksheet became

aaa bbb ccc
ddd

any ideas?

--
moonwalker
------------------------------------------------------------------------
moonwalker's Profile: http://www.excelforum.com/member.php...o&userid=31766
View this thread: http://www.excelforum.com/showthread...hreadid=514918

--

Dave Peterson

Tab Delimiter File
 

I've run into files like that, and sometimes, I find more success by
choosing Fixed Width and adjusting the vertical separation lines manually.
I've never recorded a macro while doing this, to see if the macro can be
fine-tuned and made permanent, but it might worth a try.

Tab Delimiter File
 

i think let me rephrase the question again..

when i drag and drop the txt file into excel
it opens up nicely..

aaaa bbbb cccc dd
dd

the column dd has a carriage return.

when i use the wizard to open the txt file

it open as

aaaa bbbb cccc dd
dd

actually im writing a script to automate of exporting tab seperated
delimiter file to a excel file and vice versa.

i hope some kind soul here can really help me..
thanks


--
moonwalker
------------------------------------------------------------------------
moonwalker's Profile: http://www.excelforum.com/member.php...o&userid=31766
View this thread: http://www.excelforum.com/showthread...hreadid=514918

Tab Delimiter File
 

i think let me rephrase the question again..

when i drag and drop the txt file into excel
it opens up nicely as a single row..

aaaa bbbb cccc dd
dd

the column dd has a carriage return.

when i use the wizard to open the txt file

it open as

aaaa bbbb cccc dd
dd

it becomes two rows

actually im writing a script to automate of exporting tab seperated
delimiter file to a excel file and vice versa.

i hope some kind soul here can really help me..
thanks


--
moonwalker
------------------------------------------------------------------------
moonwalker's Profile: http://www.excelforum.com/member.php...o&userid=31766
View this thread: http://www.excelforum.com/showthread...hreadid=514918

Tab Delimiter File
 

i narrowing this problem down..

i guess i just need to go through every columns and make sure and
replace carriage return with empty string

can anyone guide me?
rather new to vbscript

thanks


--
moonwalker
------------------------------------------------------------------------
moonwalker's Profile: http://www.excelforum.com/member.php...o&userid=31766
View this thread: http://www.excelforum.com/showthread...hreadid=514918