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

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

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?

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

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.

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

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

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