LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,101
Default Reading from a dat file

Could someon help me try to read a dat file with lines of text of this
format. If you paste this into a text file it show you what im dealing with.
Im not sure how to look for chr(166) and read whats between the chr

Any help would be great!!

0\ <Unknown PLU: \ ¦1¦726224¦QUORUM NIC
TORO¦999.99¦22.92¦1¦¦0¦0.00¦¦<Unknown PLU: ¦999.99¦22.92¦0.00¦0.00¦¦
101\ ASHTRAY CERAMIC ASST \
808178020826¦44¦72031¦Ashtray-Assorted
Ceramic¦2.30¦6.90¦1¦¦101¦50.00¦808178020826 ¦ASHTRAY CERAMIC ASST
¦2.30¦6.90¦4.59¦4.59¦¦
104\ JOB 1.5 PAPERS 24PK BOX\ 079083157246¦1¦028381¦JOB 1.5
CIGT. PAPERS¦26.27¦25.22¦1¦¦104¦25.00¦07908315724 6¦JOB 1.5 PAPERS 24PK
BOX¦26.27¦25.22¦35.05¦35.05¦¦
104\ TOP ROLLING PAPER 24 BOX\ 077170510011¦1¦029926¦TOP CIGT
PAPERS¦15.74¦14.69¦1¦¦104¦25.00¦07717051001 1¦TOP ROLLING PAPER 24
BOX¦15.74¦14.69¦20.99¦20.99¦¦
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reading a file Roy[_10_] Excel Programming 2 November 17th 07 06:51 PM
reading txt file and copying the lines in new excel file [email protected] Excel Programming 2 August 11th 06 07:20 PM
reading from another file and pasting to current file, "combobox" Darius New Users to Excel 1 September 26th 05 07:13 AM
reading data from 2nd file in 1st file using Combobox Darius Excel Programming 0 September 22nd 05 04:51 PM
reading from text file to excel file dgoel Excel Programming 0 April 18th 05 06:49 PM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"