| rajeev chavan 2005-03-22, 3:55 pm |
| Hi Everbody
Thanks for your response.
To E.Fridman :
The program which converts from its native file format to ASCII is not
converting the records at 1 record per line.It breaks (with CRLF) the record
at 2-3 places.The record starts at date.So from one date to next date is one
record.Generally one record spans 3 lines(and 2 CRLFs) but not always eg
check 4th record.
To Lee Clinkscales :
Your idea of having date field as character is great.Otherwise I was getting
date as blank.What do you mean by "expanded dbf"
To Pete :
You have also mentioned about keeping date as character.Thanks for advice.As
I have explained above each record is getting broken at 2-3 places so simple
APPEND FROM wont work.
To Ross :
Many many thanks for the program.Although the format in which my program
requires XML file is little different I will try to improve upon your
program.I will come back to you if I find any dificulty.Thanks once again.
To All :
I need to process the ASCII file so that I have 1 record per line as
follows(pls view the follo with window maximized)
1-3-2005,"RETREADING RECEIPTS (CASH)","Sale",-5000.00,,"Ch. No. :qweq","(No.
:8830/SR)",
1-3-2005,"DABHT (ABHISKEH TRANSPORT)","Rcpt",-2000.00,,"C","(No. :1)",
1-3-2005,"RETREADING RECEIPTS (CASH)","Sale",-8000.00,,"(No. :8837/SR)",
2-3-2005,"RETREADING RECEIPTS (CASH)","Sale",-6000.00,,"Ch.
No. qw345v45y5275745745747547477487878744757
7547475477437tuiytieitueitueiutie
uieutieutiuiu583539938383938938535383583
83838538538538538583uuuuiuriewuitier
giggiriutiutiutiwtuu55729529485238583582
339885dkuut09912lowetysgerl","(No.
:8841/SR)",
2-3-2005,"CMRFL (MRF LTD)","Pymt",,5000.00,"Ch. No. :123456 pd for
purchases","(No. :1)",
Pls advice.
TIA
Rajeev Chavan
"E. Fridman" <pm771.am@gmail.com> wrote in message
news:1111426720.742726.197240@l41g2000cwc.googlegroups.com...
> Re: ASCII to DBF.
>
> It is not clear from your post where do you have [CR] and/or [LF]
> characters in your ASCII file.
>
|