Sponsored Content
Top Forums Shell Programming and Scripting how to parse this file and obtain a .csv or .xls Post 302509970 by pravin27 on Friday 1st of April 2011 07:55:03 AM
Old 04-01-2011
Hi Ant-one, Try this,
Code:
awk -F\" '{gsub(/^ +/,"");if(/HELPTEXT/) {printf $0;flg=1;next}if(flg==1 && !/HELP/){printf $0" ";next} if(/HELP/){flg=0;print;next}if(/THRESHOLD / || /RESET /){gsub("THRESHOLD ","THRESHOLD,");gsub("RESET ","RESET,");print;next}print $1","$2}' inputfile

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies

2. Shell Programming and Scripting

From xls to csv file

Can we convert an xls file into csv format in Unix Thanks Suresh (1 Reply)
Discussion started by: sureshg_sampat
1 Replies

3. UNIX for Advanced & Expert Users

obtain duplicate keys in csv file

Hi, having two csv files, both sorted, by key (column1), f1 containing duplicate keys and f2 containing no duplicate keys, how can I obtain all rows from f1 with the keys listed in file2? Example: f1 is: k1,gsj01fd k2,vi982cj k2,1fjk01e k3,81kjfds k4,sd9dasi f2 is: k2 k3 and I... (3 Replies)
Discussion started by: oscarmon
3 Replies

4. 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

5. 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

6. 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

7. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Hi All, I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box . I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies

8. Shell Programming and Scripting

How to convert a xls file to csv?

Hi, My requirement is to convert the xls to csv file with utf-8 conversion. Is there any way please suggest me. Thanks, Raja (4 Replies)
Discussion started by: cnraja
4 Replies

9. Shell Programming and Scripting

Perl script to Convert XLSX or XLS files to CSV file

Hi All, I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file. I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box. Perl code should have 2 params while running. i.e perl... (1 Reply)
Discussion started by: manab86
1 Replies

10. Shell Programming and Scripting

Generate .csv/ xls file report

There can be thousand of .ksh in a specific directory where sql files are called from ksh. Requirement is to loop through all the files content and generate a report like below: Jobname Type type sqlname gemd1970 sql daily tran01 gemw1971 sql weekly ... (6 Replies)
Discussion started by: vedanta
6 Replies
JPEGHOTP(1)							   User Commands						       JPEGHOTP(1)

NAME
jpeghotp - find hot or dead pixels in otherwise black or white JPEG images SYNOPSIS
jpeghotp [OPTION]... JPEG-FILE [PIXEL-BLOCKS-FILE] DESCRIPTION
Jpeghotp automatically finds hot pixels in an otherwise black JPEG image (default) or dead pixels in an otherwise white JPEG image (if the --invert option is specified). The output is suitable as a pixel block specification file for the jpegpixi(1) program. A typical applica- tion is to process an image taken with a digital camera with CCD defects. To obtain a black image, take a picture in total darkness or with covered lens. To obtain a while image, take an overexposed picture of a well-lit piece of white paper. JPEG-FILE is the filename of the JPEG image to read. It can be -, which refers to standard input. PIXEL-BLOCKS-FILE is the name of the file to write the coordinates and sizes of the hot (or dead) pixel blocks to. If it is omitted, the coordinates and sizes are written to standard output. OPTIONS
-t THRESHOLD, --threshold=THRESHOLD Specify the threshold between noise and signal. Pixel luminosities below the threshold are considered CCD noise, luminosities above are considered hot pixels. THRESHOLD must be a number between 0 and 100 followed by a percent character (%). The default is 10%. -i, --invert Invert the image. If this option is specified, dead pixels in an otherwise white image instead of hot pixels in an otherwise black image are found. -c, --comments Output comments with the luminosities of the hot (or dead) pixel blocks. This can be helpful in hand tuning the pixel blocks file. --help Display a short help text and exit immediately. --version Display version information and exit immediately. BUGS
Please report bugs to <martin-jpegpixi@zero-based.org>. COPYRIGHT
Copyright (C) 2003, 2004, 2005 Martin Dickopp Jpeghotp is free software; it may be copied and/or modified under the terms of the GNU General Public License version 2 or (at your option) any later version. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. SEE ALSO
jpegpixi(1) The jpegpixi homepage: http://www.zero-based.org/software/jpegpixi/ jpegpixi 1.1.1 18-Apr-2005 JPEGHOTP(1)
All times are GMT -4. The time now is 09:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy