Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

conert the pipe delimated file into xls format

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting conert the pipe delimated file into xls format
# 1  
Old 12-19-2007
conert the pipe delimated file into xls format
Hi


I have spool file which is pipe delimated and i want to convert it into xls .
Is any tool or method availabe in UNIX for this kind of conversion
# 2  
Old 12-19-2007
Hi,
You could just import the file using pipe as delimiter and voila!
If you cant use pipe as delimiter you can
Code:
sed -e 's/|/;/g' thefile > thefile.csv

and then import and save it as xls file ... (if you're talking about M$ Excel file format of course Smilie)
# 3  
Old 12-19-2007
Of course, " | " can be used as delimiter in MS Excel

While importing specify the delimiter in other's block

that would do!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX/PERL script to convert XML file to pipe delimited format

Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant. The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
15 Replies

2. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies

3. Shell Programming and Scripting

Converting text files to xls through awk script for specific data format

Dear Friends, I am in urgent need for awk/sed/sh script for converting a specific data format (.txt) to .xls. The input is as follows: >gi|1234|ref| Query = 1 - 65, Target = 1677 - 1733 Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46 fd sdfsdfsdfsdf fsdfdsfdfdfdfdfdf... (6 Replies)
Discussion started by: Amit1
6 Replies

4. Shell Programming and Scripting

Output in xls format

Hi, I need the output of sql query which is executed using a shell script to xls file format. (10 Replies)
Discussion started by: Arasu
10 Replies

5. Shell Programming and Scripting

perl module to convert xlsx format to xls format

Hi Folks, I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx. I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly.... (1 Reply)
Discussion started by: giridhar276
1 Replies

6. Shell Programming and Scripting

Clearcase ucm baseline differences report in xls format

Hi All, Can any one help me to get the shell/perl scripts for the below requirements. 1: To get the clearcase checkin's information between two lables generate a formatted Xls output and to find the added changed and removed files and versions between the ClearCase baselines. 2... (2 Replies)
Discussion started by: saku
2 Replies

7. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

8. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies

9. Shell Programming and Scripting

Convert a csv file to an xls format

Hi, I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this? I'm struggling on this. Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies

10. Shell Programming and Scripting

Generating xls with utf-8 format

Hi All, This is my first mail to the group.I would like to generate an attachment in xls format which contains accented characters that are supported by UTF-8 format. However, I am not able to get them as i wished. Can anyone help me in this regard.I would like to know the mail format for... (0 Replies)
Discussion started by: kalyanramurs
0 Replies
Login or Register to Ask a Question