| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Excel file automatically opens | Excel Discussion (Misc queries) | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| cannot open excel file, please help!!! | Excel Discussion (Misc queries) | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Linear Mode
