Re: Exporting to text files
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On May 30, 2:36 pm, jim <j...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a tab-delimited text file (.dat file) created via sql server that I'm
attempting to parse in visual basic 6.0. I have tried Random, Sequential and
Binary file access. All to no avail. Finally, I had to parse the file by
retrieving the position of each tab in the file. That is, read a line and
w/in that line get the tab position of each tab to break up each column or
field.
I wondering if text file is the issue because parsing this same text file w/
another programming language had the same result.
any help is appreciated.
jim
Check the "type" of file. Sometimes, SQL Server generates a UNICODE
file that makes programs not recognize the delimiters. Open the file
in Notepad, so a "Save As..." and see what the "Encoding" is. If it's
"Unicode," change it to "ANSI", save the file, and try the parsing
again.
.
Relevant Pages
- Re: Parsing textfile
... In this case I would 1) either simply read the file one line at a time, then sue the Split function to break each line into a string array, 2) use the Excel object model to read and parse the file for me, then read it through there, or 3) goto connectionstrings.com and see if there is a way to read text files via ODBC and the Jet engine. ... access is the method for parsing tab-delimited files rather than using ... retrieving the position of each tab in the file. ... w/in that line get the tab position of each tab to break up each ...
(microsoft.public.vb.database) - Re: Parsing textfile
... attempting to parse in visual basic 6.0. ... Binary file access. ... retrieving the position of each tab in the file. ... w/in that line get the tab position of each tab to break up each column or ...
(microsoft.public.vb.database) - Find and replace, insert tab before
... replace to insert tab characters such that I can then programmatically parse ... arteriovenous NEC 747.60 ... that I can insert each into a field in the database. ...
(microsoft.public.word.formatting.longdocs) - Re: Reading of Large (20k+ lines) Flat File
... From Excel save your 25000 row .xls as a tab delim file. ... I have used this technique to parse large flat file records out ... D3 will run out of memory if the file is too large, ...
(comp.databases.pick) - parsing tab and newline delimited text
... I have a large file of text I need to parse. ... separated by newline characters, while fields within each entry are ... separated by tab characters. ... an individual entry might have this form: ...
(comp.lang.python) |
|
