Sponsored Content
Top Forums Shell Programming and Scripting Formatting a report from 2 files Post 302100251 by vgersh99 on Monday 18th of December 2006 08:51:13 AM
Old 12-18-2006
prompt: your input files are missing HEADER lines as you had them in the original one.

if you're NOT going to have header lines, then delete line
Code:
FNR == 1 { next }


Last edited by vgersh99; 12-18-2006 at 10:50 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Formatting files

We currently use the following script to format a non formatted file to an 80 byte format (for grep purposes etc..) We need some assistance with converting the file back to a non formatted file with no carriage returns ( we want the file to be a continuous line) #!/usr/local/bin/perl ($fn,... (1 Reply)
Discussion started by: rivera
1 Replies

2. Shell Programming and Scripting

formatting and merging 2 data files

Hi, I have 2 files that I got as an output from another program. They are : File 1 ((((((CtBJa:197.0,CtBTz:197.0):85.0,CtAHr:197.0):116.0,CtDUw:197.0):176.0,CtSwe:197.0):110.0, (CtL2b:197.0,Ct4Bu:197.0):196.0):197.0,CmuNg:197.0);... (5 Replies)
Discussion started by: Lucky Ali
5 Replies

3. Shell Programming and Scripting

formatting files

how do i add the directory name to multiple flies and pad numbers sequences /bin/bin2/bin3/bin4/bin5/foo_bar_vX/foobar ie i have a pic in the foobar folder call dsc.1 id like to change it to foobar_dsc.0001 (2 Replies)
Discussion started by: thehive
2 Replies

4. Shell Programming and Scripting

Help needed in formatting script files

Hi, Can anyone tell me how i can convert all tab spaces inside a script to 4 spaces through another script. Also i need to find if all the quotes are matching and ended properly. Any idea whould be of great help. Many thanks! (3 Replies)
Discussion started by: justchill
3 Replies

5. Shell Programming and Scripting

Reading files under a folder and formatting content of each file

I have 'n' number of files in a folder .each file in the folder "myfolder" is having the content like. COLNAME ------------ AAAAAA BBBBBB CCCCCC DDDDDD ... ... ... ZZZZZZ 26 recrod(s) selected. My request is by reading each file in "myfolder" and format each file such a way... (18 Replies)
Discussion started by: rocking77
18 Replies

6. UNIX for Dummies Questions & Answers

SQL PLUS report formatting

Hi I am fetcthing the data from the oracle database using SQLPLUS. Here is my script #!/bin/ksh echo `sqlplus -s <<EOF set feedback off set linesize 5000 set pages 0 set space 0 set echo off set trimspool on set colsep '|' SELECT col1 , col2... (4 Replies)
Discussion started by: max_hammer
4 Replies

7. Shell Programming and Scripting

Formatting a report using awk

Our vendor produces a report that I would like to format in a particular way. Here is the sample output from their report: # AA.INDEX 2 11 2 239 52 (7,2) 07 MAY 11 203.1 55 # ACCOUNT 2 89561 2 ... (4 Replies)
Discussion started by: thaller
4 Replies

8. Shell Programming and Scripting

Formatting Report and Reading data and fetching the details from contents file

Data I was trying to write shell script which will be return the output in the below format First i was trying to do these using sed. sed -n '/.ksh/p' mainksh.ksh sed -e 's/*\(.*\)/\1/g' mainksh.ksh $RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file. when i am... (0 Replies)
Discussion started by: rameshds
0 Replies

9. Shell Programming and Scripting

search for content in files. Name of files is in another file. Format as report.

Hi I have multiple files in a folder and one file which contains a list of files (one on each line). I was to search for a string only within these files and not the whole folder. I need the output to be in the form File1<tab>string instance 2<tab> string instance 2<tab>string instance 3... (6 Replies)
Discussion started by: pkabali
6 Replies

10. Shell Programming and Scripting

Formatting The Output Files & Matching Keys

I have the following 2 output files, one contain the standard output after i decrypt the encrypted file and another keys listed from the gpg trust db, Provider File: gpg: encrypted with 2048-bit RSA key, ID 96301328, created 2014-04-29 "JKL <400@abc.com>" gpg: encrypted with 2048-bit... (2 Replies)
Discussion started by: Ariean
2 Replies
XCALEV(1)						      General Commands Manual							 XCALEV(1)

NAME
xcalev - load xcal calendar files with regular dates SYNTAX
xcalev [ -r ][ -x ][ -f file ][ -d dir ][ year ] DESCRIPTION
Xcalev is used to preload the calendar files for the xcal program with regular events in your life. It reads lines from a file (usually called regular stored in your Calendar directory. Each line in the file contains three fields separated by spaces or tabs, these are: a month name, a day in the month and some text. For example: December 25 Christmas Dec 31 New Year's Eve The order of the month and the day are optional, the program deduces the day by looking whether the string contains an initial numeric character or not. The year defaults to the current year unless the program is given a year number as an argument. This year cannot be abbreviated to two digits because xcal deals with years from year zero. There's a rough validity check on this. The string from the data line is inserted in the appropriate file and will appear in your xcal date strip. Nothing will happen if the string already exists in the file for that day. This means that it's safe to run xcalev at any time, only the strings that have altered in the regular file will be updated. To help with entering the same event for a number of days in one month, you can give a day range with a hyphen Jan 16-21 Usenix SF If you supply the -r option, xcalev will delete all the matching strings that it finds in the appropriate daily file. So, if you want to make radical changes to the regular file, you should run xcalev with the -r option to remove all the current entries from one year, edit the regular file and run xcalev to reload things. OPTIONS
The -r option makes xcalev delete rather than append entries. The -x option makes xcalev operate with Calendar files that are compatible with the xcalendar program. The -f switch is followed by a filename gives an alternative name for the regular file. If the filename does not start with a slash or a dot, then the name of your Calendar directory will be prepended to it. The -d switch is followed by a directory name and specifies an alterative location for your Calendar directory. Your home directory is prepended if the name doesn't start with a slash or a dot. FILES
$HOME/Calendar/* xc<dd><Mon><Year> A data file is day, Month in three letter format and the year. xy<Year> A year directory. xw<Day> A data file for the weekly code, one per day. SEE ALSO
xcal(1), xcalpr(1), xcal_cal(1) AUTHOR
Copyright 1993 by Peter Collinson, Hillside Systems All rights reserved. X Version 11 R5 October 1993 XCALEV(1)
All times are GMT -4. The time now is 02:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy