Desire structure for input file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Desire structure for input file
# 8  
Old 09-20-2010
Code:
awk '!(/^$/||/--/||/selected/){print "A." $1 " <> B." $1 " or"}' infile |sed '$ s/ or$/;/'

# 9  
Old 09-20-2010
awk '!(/^$/||/--/||/selected/){print "A." $1 " <> B." $1 " or"}' report3.txt |sed '$ s/ or$/;/'
A. <> B. or
A.AAA<>B.AAA or
A.BBB<>B.BBB or
.
..
..
A.ZZZ<>B.ZZZ;

Now its better than previous. still one more row at the top now
kanakaraju
# 10  
Old 09-20-2010
I guess there is blank space in first line:

Code:
awk '!(/^$/||/--/||/selected/||/^ *$/){print "A." $1 " <> B." $1 " or"}' report3.txt |sed '$ s/ or$/;/'

# 11  
Old 09-20-2010
If the following doesn't work, you need to provide a more accurate account of what's in the file using something like `od -c`:
Code:
grep -Ev '^[[:space:]]*$|^--*$|record\(s\) selected' data | sed 's/.*/A.& <> B.& or/; $s/or$/;/'

Regards,
Alister

---------- Post updated at 08:07 AM ---------- Previous update was at 08:03 AM ----------

Alternatively, if a stream is not required and the result will be saved to a new file, ed can be used:
Code:
#!/bin/sh

# Usage: scriptname source-file destination-file

src=$1
dest=$2

ed -s "$src" <<EOED
    g/^[[:space:]]*$/d
    g/^--*$/d
    /record(s) selected/d
    1,\$s/.*/A.& <> B.& or/
    \$s/or/;/
    w $dest
    q
EOED

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to get desire line?

Hi Guys, I am newbie here and greeting to all guys of unix forum, now I want to learn unix here. I have query here, we have file where file has 20 line record, now i want display 10 to 15 line row record only, then how it possible. (5 Replies)
Discussion started by: aaditya321
5 Replies

2. Shell Programming and Scripting

Read input files and merge them in given order and write them to input one param or one file

Dear Friends, I am looking for a shell script to merge input files into one file .. here is my idea: 1st paramter would be outfile file (all input files content) read all input files and merge them to input param 1 ex: if I pass 6 file names to the script then 1st file name as output file... (4 Replies)
Discussion started by: hyd1234
4 Replies

3. Shell Programming and Scripting

Case structure combined with standard input

Hi folks, I am new to bash scripting so please excuse my question. Is there any chance to combine a case structure with the read command? Like case (read -p "" variable) in x) Thx! (7 Replies)
Discussion started by: haukee
7 Replies

4. Hardware

HTC Desire S vs HTC Desire C - USB Android tethering problem

Hi gurus, I have problem with android usb tethering (usb0 interface). I tried two phones HTC Desire C and HTC Desire S. With Desire C everything works as expected, usb0 automatically goes up and gains IP address and tethering is working (output bellow) HTC Desire C: Nov 6 23:32:36 HP-PC... (0 Replies)
Discussion started by: wakatana
0 Replies

5. Shell Programming and Scripting

Copy files from input file with dir structure

hi, I want to copy files from source directory based on input file (or output of previous command) and i want to have the SAME DIRECTORY STRUCTURE. Note that i will have other files and directories which i dont want to copy to destination. For example, dir source has following content:... (22 Replies)
Discussion started by: dragon.1431
22 Replies

6. Shell Programming and Scripting

Need script to take input from file, match on it in file 2 and input data

All, I am trying to figure out a script to run in windows that will allow me to match on First column in file1 to 8th Column in File2 then Insert file1 column2 to file2 column4 then create a new file. File1: 12345 Sam 12346 Bob 12347 Bill File2:... (1 Reply)
Discussion started by: darkoth
1 Replies

7. Shell Programming and Scripting

Can't get DF output I desire

I currently have a shell script that creates Oracle databases configured the way we want them here. One part of it allows you to choose which file system to place the database files. This is the command which works. This produces a list of file systems from which to choose. I have been... (1 Reply)
Discussion started by: sewood
1 Replies

8. Shell Programming and Scripting

How to create a directory structure with getting input from a file.

Hi How to create a directory structure with getting input from a file. I have file in that following lines are written. ./activemq-4.1.2/activemq-core-4.1.2.jar ./activemq-4.1.2/backport-util-concurrent-2.1.jar ./camel-1.4.0/apache-camel-1.4.0.jar ./camel-1.4.0/lib/activation-1.1.jar... (12 Replies)
Discussion started by: itsjoy2u
12 Replies

9. Programming

Search attributes in one structure using the values from another structure

Hello Groups I am trying to find out ways of comparing a value from a 'c' structure to a value in another 'C' structure. the 'C' structure can be a List or liked list as it contains lot many records. if we loop it in both the structures it is going to consume time. I am looking for a simple... (3 Replies)
Discussion started by: dhanamurthy
3 Replies

10. UNIX for Dummies Questions & Answers

Copying a Directory Structure to a new structure

Hi all Is it possible to copy a structure of a directory only. e.g. I have a file with the following entries that is a result of a find :- /dir1/dir2/file.dbf /dir1/dir2/dir3/file1.dbf /dir1/file.dbf I want to copy these to a directory and keep the structure however starting at a new dir... (8 Replies)
Discussion started by: jhansrod
8 Replies
Login or Register to Ask a Question