Converting a binary file to ascii and vice versa?

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting a binary file to ascii and vice versa?
# 1  
Old 10-03-2013
Converting a binary file to ascii and vice versa?

Hi All,
I have a binary file which is being exported from a Database, and i need to convert that to ASCII format. How can i achieve that? And this solution should work for any file which is given to us; means they will give different files from different tables.

Thanks in advance.
# 2  
Old 10-03-2013
strings is a rather generic way of extracting printable text from binary files:

STRINGS(1)                   GNU Development Tools                  STRINGS(1)

       strings - print the strings of printable characters in files.

What kind of "file" is it? Unless you know how to decode the file, that might be the closest you get, and there would be no vice-versa.

Last edited by Scott; 10-03-2013 at 05:01 AM.. Reason: Probably not a LOB!
# 3  
Old 10-03-2013
Hi Scoot,
THanks for the reply, As i told its a file extracted from a database table with '~' as a delimitter; The file might contain arbitrary No. of columns each time. Strings is not converting the entire file properly as expected. Is there any other command/script that will help me?
# 4  
Old 10-03-2013
You never mentioned anything about a ~ delimiter!

Run file filename against the file. What does it say?

And what exactly do you want to do once you've "converted" it to ASCII, before you convert it back again?

Without seeing a sample of the file, and with your description and requirement being as vague as they are, I would have no idea what to suggest here.
# 5  
Old 10-03-2013
when i run file filename it gives data

Actullay converting to ASCII is enough - After converting i need to scp that file to another server and it will be consumed by some other downstream applications

The converse is just to check whether the file file has been converted properly or not.

The file will have data extracted from a table. A mix of character, date, number and everything.

Is this helpful, please lemme know if u need more details?
# 6  
Old 10-03-2013
data is the most generic of terms and could mean anything. Assuming you mean it's the result of some SQL query, then you still need to post some of it before anyone can know what to do with it. And you need to be much more specific about what you mean by converting it to ASCII. Without knowing exactly what you mean by data and without seeing some of it, I don't know how you can expect any help here.
# 7  
Old 10-03-2013
I will try to post some of the data, watever i have it has some PII so this is the information i have as of now

'Binary' = 2-byte integer, n, followed by n bytes of data. In this format:

The data is prefixed by a record-length marker.

The record-length marker does not include the length of the marker

The record-length is not part of the transmitted data.

If possible you can help me with this if not i will try to post some sample data. but if i try to open the .dat file it shows junk character is that the expected behaviour? THanks.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Command for Host Name to IP Address or Vice Versa

Hi, In unix or linux is there any command exist to identify Host Name to IP Address or Vice Versa? Thanks in advance (6 Replies)
Discussion started by: nag_sathi
6 Replies

2. Shell Programming and Scripting

Converting odd values to even values(or vice-versa) located in a column

Hello All, I have a below data in a .csv file where all rows where col1 is A, col2 is odd numbers, similarly even numbers for all rows where col1 is B. Note that my data has some other columns(not shown here) too (around 100) after col2. Tool,Data A,1 A,3 A,5 .... so on B,2 B,4 .... ... (4 Replies)
Discussion started by: ks_reddy
4 Replies

3. UNIX for Dummies Questions & Answers

How to ping from Windows to Solaris 10 and vice versa?

Hi all, I installed Oracle virtual box 4.1.8 on my desktop. I installed Windows 2008 server R2 as one instance and Solaris 10 as another instance. When am trying to ping from Windows to solaris and vice-versa, ping not working. windows IP : Solaris IP : netstat... (2 Replies)
Discussion started by: kjks
2 Replies

4. Shell Programming and Scripting

Converting from Centigrade to Fahrenheit and vice versa.

I need to write a script that will take the input from a file and convert the number from centigrade to fahrenheit and vice versa. This is what I have but it doesn't seem to be correct. Also the data file has 11 numbers inside of it and the output needs to be listed as so: Fahrenheit Temperature... (18 Replies)
Discussion started by: N1ckNak
18 Replies

5. Ubuntu

What is the advantage of ubuntu over vista and vice versa?

i am thinking of replacing my vista with ubuntu. Questions: 1) what will be the advantages and disadvantages of using ubuntu instead of vista? 2) what will be the setbacks of replacing my vista? 3) how hard is it to cope up with the new OS? what must i learn to utilize ubuntu? (1 Reply)
Discussion started by: Anna Hussie
1 Replies

6. Shell Programming and Scripting

Uppercase to lowercase and vice versa

shell script to convert file names from UPPERCASE to lowercase file names or vice versa in linux anybody please help me out!!!! (5 Replies)
Discussion started by: jacky29
5 Replies

7. UNIX for Dummies Questions & Answers

Appending from a file to a script and vice versa

Hi, I am new to Unix and discovered this example problem online that I believe will help my learning: Run the command's below env >> xx env >> xx env >> xx env >> xx env >> xx You will now have a file called XX with the env redirected into it 5 times Create a script named... (2 Replies)
Discussion started by: Jimmy_c
2 Replies

8. Shell Programming and Scripting

Pdf to text conversion and vice versa

Hi, I have a pdf file. i want to convert it to text file and do some work on it and later want to convert it back to pdf. Can this be done via unix? or Is there a way unix can directly work on PDF file? (2 Replies)
Discussion started by: saltysumi
2 Replies

9. UNIX for Advanced & Expert Users

Converting ASCII to Binary mode

Dear All, Business Users are transfering ( FTP ) a CSV file into the IBM AIX box with transfer mode as ASCII. But I want to convert the CSV file from ASCII mode into binary mode, as my script expects file in binary mode. Is it possible to do through Unix commands? Thanks in Advance, RK (1 Reply)
Discussion started by: srajeshmca
1 Replies

10. Programming

binary to string conversion and vice versa

please let me know that in unix using c programming language we can do binary to string conversion and vice versa using ltoa and atol but how can we do it in c++ programming language. thank you in advance. (3 Replies)
Discussion started by: kinnaree
3 Replies
Login or Register to Ask a Question