Sponsored Content
Top Forums Shell Programming and Scripting different files for different values Post 302276868 by angheloko on Wednesday 14th of January 2009 10:42:12 PM
Old 01-14-2009
Hi ss,

I thought all along that the source file would only contain the pipe-delimited rows (we did have a lot of misunderstanding). So this means that the source file also include the query as well.

Anyway, to remove the undesired lines try this:

Code:
sed '/^SQL/d;/^[0-9]/d;s/$$//g;/^ *$/d' $OUTFILE > $OUTFILE.tmp
mv $OUTFILE.tmp $OUTFILE

Will remove lines beginning with SQL and numbered lines, $ character, and blank lines

or

Code:
sed '/^D/!d;s/$$//g;/^ *$/d' $OUTFILE > $OUTFILE.tmp
mv $OUTFILE.tmp $OUTFILE

Will remove lines NOT beginning with D, $ character and blank lines

instead of:

Code:
sed -e '/SQL/d' $OUTFILE > THS_PROF.txt
 
sed -e '/2,21/d' $OUTFILE > THS_PROF.txt
 
sed -e '/D/d' $OUTFILE > THS_PROF.txt

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to sum values from 2 different files?

Hi I am trying to add count values from two different files into one file. Could any body please suggest me best command to do this? My problem was as follows: a.txt b.txt c.txt 10 20 30(needed) i tried cat a.txt b.txt > c.txt (its not adding the values) Thanks in advance.. Praveen (8 Replies)
Discussion started by: npk2210
8 Replies

2. Shell Programming and Scripting

Cat Values from Several files if it meets criteria for column values

I have results from some statistical analyses. The format of the results are as given below: I want to select lines that have a p-value (last column) less than 0.05 from all the results files (*.results) and cat to a new results file. It would be very nice if a new column is added that tells... (2 Replies)
Discussion started by: genehunter
2 Replies

3. Shell Programming and Scripting

match 2 files by values

Hello ALL, Hope all fine for you. I have the following task but no idea about how to do. I have 2 files (ascii) one of them is a list of bib records, looks like this: =LDR 01228nam 2200301 b 4500 =001 00000000000001 =005 20090429:10082000 =008 ... (2 Replies)
Discussion started by: ldiaz2106
2 Replies

4. Shell Programming and Scripting

Compare values in two files. For matching rows print corresponding values from File 1 in File2.

- I have two files (File 1 and File 2) and the contents of the files are mentioned below. - I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2. - I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies

5. Shell Programming and Scripting

Summarize the values from files

One of my process will create a file Market.txt with data like below. Count Markt file 334936 /pdm/data001/P3_Quest_5HT_AMERGE.csv 2770787 /pdm/data001/P3_Quest_ARB_ATACAND.csv 1198143 /pdm/data001/P3_Quest_Bisp_ACTONEL.csv 3821864 /pdm/data001/P3_Quest_CONTRA_ALL_OTHER_CONTRA.csv... (7 Replies)
Discussion started by: katakamvivek
7 Replies

6. Shell Programming and Scripting

Value falls between two values from different files

Hi, I have two files cat 1 100 1 110 2 113 4 230 5 334 7 500 8 900 10 I have another file cat 2 100 200 201 300 301 400 401 500 501 600 601 700 (3 Replies)
Discussion started by: jacobs.smith
3 Replies

7. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies

8. Shell Programming and Scripting

Comparing the values of two files

Hi Am trying to compare the values of two files.. One is a big file that has many values and the other is a small file.. The big file has all values present in small file.. # cat SmallFile 4456602 22347881 7471282 15859891 8257690 21954701 7078068 18219229 2883826 6094959 100000 ... (3 Replies)
Discussion started by: Priya Amaresh
3 Replies

9. Shell Programming and Scripting

Interpolation of two values in two different files

Dear All, I have two files which contain numerical data and strings. I want to create a new file that only revise numerical data from two files using interpolation. I guess AWK works, but I am new on AWK. FileA.txt . . index_2("0.1, 1, 2, 4, 8, 16, 32"); values("0.0330208, 0.0345557,... (17 Replies)
Discussion started by: jypark22
17 Replies

10. UNIX for Beginners Questions & Answers

Replace Stub Values In One Group Of Files With Actual Values From Another Group Of Files

I have two directories of files (new-config-files and old-config-files): new-config-files/this-db/config.inc.php new-config-files/that-db/config.inc.php new-config-files/old-db/config.inc.php new-config-files/new-db/config.inc.php new-config-files/random-database/config.inc.php etc. ... (4 Replies)
Discussion started by: spacegoose
4 Replies
KSSHELL(1)						      General Commands Manual							KSSHELL(1)

NAME
ksshell -- an interactive kickstart shell SYNOPSIS
ksflatten [-i | --input INFILE] [-o | --output OUTFILE] [-v | --version VERSION] DESCRIPTION
ksshell is an interactive kickstart shell. It optionally takes an input kickstart file as the basis, allows the user to specify additional kickstart commands, and then writes out the finished kickstart file to stdout or the given file name. This program supports all the usual readline niceties including tab completion of kickstart commands and their options, though not the values those options can take. In addition to understanding all the kickstart commands, ksshell has some builtin commands of its own to make working with kickstart files in the context of a shell easier: .clear Clear the existing kickstart data, including any from INFILE. This essentially starts you over from a blank state. .quit Quit the interactive shell, either saving to the file given by OUTFILE or printing to stdout if none was given. .show Print the current kickstart file state. EXIT STATUS
ksflatten returns 0 on success, and 1 if VERSION is incorrect. If INFILE does not exist, a warning will be printed but the user will still be dumped to the interactive shell. OPTIONS
-i, --input INFILE The name of the input kickstart file. -o, --output OUTFILE Write the flattened kickstart file to OUTFILE, or stdout if no filename is given. -v, --version VERSION Use this version of kickstart syntax when processing the file, or the latest if no version is given. SEE ALSO
ksvalidator (1), ksverdiff (1) KSSHELL(1)
All times are GMT -4. The time now is 01:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy