How to Determine File Format

Hello Experts

I have attached file that I'm unable to read as I don't what application is used to open the file, or the format of the file.

Can someone let me know how to determine the file type so that I can open it?

Cheers

Carlton
VANQ_TRIAD_COLLS_20180118
LVL 1
Member_2_7966113Asked:
Who is Participating?
 
Bill PrewConnect With a Mentor Commented:
You would need to know the file layout to have any chance of "decoding" and using the data.  Most of the character data can be "assumed" as far as content, but what it represented and where the fields start and end would have to come from the provider of the file.


»bp
0
 
Andrew LeniartSenior EditorCommented:
Some software that may help you can be found here;

https://www.raymond.cc/blog/what-file-is-that-how-to-identify-unrecognized-files-types-and-format/

Hope that helps.
0
 
Member_2_7966113Author Commented:
Hi Andrew,

Just tried 'Smart File Advisor'... it didn't work at all.

Have you tried any of these applications yourself?

Cheers
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
RaminTechnical AdvisorCommented:
How did you get that file ?
0
 
bbaoIT ConsultantCommented:
by checking the dump result of the given file, it looks like a sequence binary output file of an application, without file header.
0
 
Member_2_7966113Author Commented:
Ramin,

It was sent to me as a .Zip file
0
 
Member_2_7966113Author Commented:
OK, I couldn't get the software you recommended to work with the file

Any other suggestions?
0
 
Bill PrewCommented:
I think that is likely just a generic data file out of some application, like an export, etc.

I can tell you from looking at it in hex, it's in EBCDIC format (not ASCII) so may have come from a mini/mainframe application.


»bp
0
 
RaminTechnical AdvisorCommented:
Do you know the sender ?

Can you ask him/her to give you some information about that file ?
0
 
Bill PrewCommented:
Converting to ASCII there seems to be a header portion at the top, then repeating records of text and binary data.

sshot-401.png

»bp
0
 
Member_2_7966113Author Commented:
Bill

I can tell you from looking at it in hex, it's in EBCDIC format (not ASCII) so may have come from a mini/mainframe application.

You're spot on. I remember the person that sent it to me mention that the file was generated by an old skool mainframe application, but I can''t remember the application.

I would like to decode it so that I can run database queries on the decoded file

I hope that makes sense
0
 
Member_2_7966113Author Commented:
Bill,

Very good point.

I think that was the answer I needed to know.

Cheers
0
 
Member_2_7966113Author Commented:
Good answer Bill
0
 
Bill PrewCommented:
Welcome, glad that was useful.


»bp
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
I see that this question was already closed, and I admit to not reading all the messages in the thread, but based on the Title and the Question, I think that this Experts Exchange article may be helpful:

How to determine the type of file from its contents

Regards, Joe
0
 
Bill PrewCommented:
Interesting article Joe, but in this case TrID came up with nothing.  Makes sense since this isn't a standard file of any pattern recognizable type, but rather likely an EBCDIC custom data file format.


»bp
1
 
Joe Winograd, Fellow&MVEDeveloperCommented:
Thanks for that, Bill. I apologize for not reading the whole thread before posting.

And thanks to Ramin for the article endorsement — much appreciated!

Regards, Joe
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.