Hello

**hayatt08** · 09-29-2008, 12:04 AM

Hello, I received a CD with Java files rfile000.000 and rfile001.000, I am able to read these files record by record through the application. But I need to extract the data to excel or listed all records if possible. But as I see that the file extension that I can read with Java are txt or dat.

I am new on Java. Can someone help me pls.

Thanks in advance
hayatt08

**serjant** · 09-29-2008, 02:39 AM

What are these files you are talking about?Can you explain more please about the stuff?

**Norm** · 09-29-2008, 02:41 PM

file extension that I can read with Java are txt or dat

There are no restrictions on filename extensions. You can use anything.
The problem will be what you do with the bytes you read from the file. Can you explain that?

**hayatt08** · 10-01-2008, 08:07 AM

Thx Serjant & Norm for your replies.

The application is reading data from files located as follows:
\2008en\r0\rfile000.000 size 324,420k
\2008en\r1\rfile001.000 size 100,384k

How could I read the records and extract them to excel or txt.

Thanks

**masijade** · 10-01-2008, 08:42 AM

What do you mean by "Java files". Since all I have to go by is the extension, all I can say is that those files are neither ".java" nor ".class", nor ".properties, etc" files, so they are not "Java files".

How are the files formatted? Are they simple text, are they fixed length record files? What?

As far as writing them to excel once you've read them, see JExcelApi

**DarrylBurke** · 10-01-2008, 10:15 AM

I am able to read these files record by record through the application.

Which application?

If you're referring to a Transbase CD Retrieval Database, do the terms of your license permit what you're apparently trying to do?

If not, what led you to believe that rfile???.000 files are Java files?

db

**hayatt08** · 10-02-2008, 07:39 AM

Hello,

It is a specific application for cars operations code and labor fee. I can search by Vehicle model & year and get only one record at a time. I just want to list all records.

If I explore the CD, I find the Java and Tomcat pathes. When the application runs, the Tomcat starts and stops when I close it. They are not text That's why I suppose that the data files are Java. It seems that they are compressed but also I couldn't open them by any archiver.

Thanks for interesting.

**Norm** · 10-02-2008, 02:05 PM

What are you trying to do now? Are you going to write a java program to read the files and ...???

**kellaw** · 10-03-2008, 12:58 PM

try downloading hjspilt and merge the files

**hayatt08** · 10-04-2008, 07:56 AM

Yes, read & list

**DarrylBurke** · 10-04-2008, 10:30 AM

You still didn't say whether you're referring to a Transbase CD Retrieval Database.

db

**hayatt08** · 10-12-2008, 10:05 PM

Originally Posted by Darryl.Burke

You still didn't say whether you're referring to a Transbase CD Retrieval Database.

db

Yes it is a Transbase CD Retrieval Database.

Thanks db

**Norm** · 10-12-2008, 10:44 PM

Have you written a program to read the files yet?
That would be simple enough to do.
Then what do you want to do with what you read?

**ddtaxe** · 04-04-2009, 03:37 AM

Hi there.
I am facing the same problem as you. Did you get to extract the data in those files to excel/txt?
Could you please reply me with some suggestion?
Best Regards.