reversing a list


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting reversing a list
# 1  
Old 10-11-2002
reversing a list

Hi Everyone,
I am reading in a list of IDs from a file that is is chronological order. My current code in simplified form looks like this (ksh by the way)

IDS=`awk -F\| '{print $1}' inputfile.txt`
for i in $IDS
do
do various things with that ID
done

inputfile.txt looks like this:

1|stuff|more stuff|etc
2|stuff|more stuff|etc
3|stuff|more stuff|etc
.
.
.
10000|stuff|more stuff|etc

What I would like to do is start with the last ID (10000) and work towards the first ID (1). This is an oversimplified example. There are gaps between IDs, the may not be consecutive. I cannot do a while loop starting with i=10000 and decrement to 1 due to this. Any ideas how I could reverse the values in $IDS before the for loop? The input file can be manipulated prior to calling the script. I thought there was a command to invert a list but I can't remember what it is and can't find it ( I searched the forum + google + man -k)
Thanks,
Tony
# 2  
Old 10-11-2002
Don't you hate when you search for ever, can't find the answer, then as soon as you ask someone else, you find it. The command I was think of was 'rev'. However, I still need some help if you can offer it. rev exists on my HPUX box but not on my Solaris box where the script runs. Anyone know where I can get a similar binary for Sun?
# 3  
Old 10-11-2002
I feel like I am having a conversation with myself, feel free to jump in.

The rev command did not do what I had remembered. It reverses the characters on 1 line, not the entire file or list.

Any other ideas? I am working on builting a script to reverse the lines using wc output and sed p in a loop.
# 4  
Old 10-11-2002
Here is the script if anyone is interested, however it isn't the most efficient.

#!/usr/bin/ksh
LINES=`wc -l $1| awk '{print $1}' | sed 's/ //g'`
while [ $LINES -ge 1 ]
do
sed -n "$LINES p" $1
LINES=`expr $LINES - 1`
done


If anyone finds the equivalent binary that basically reads the file from bottom to top, please post and let me know.
Thanks,
TioTony
# 5  
Old 10-12-2002
Code:
awk -F\| '{printf "%6s\n",$1}' inputfile.txt |
sort -r |
while read i
  do
  echo "Now processing $i ..."
  done

awk prints field 1 right-justified for proper sorting (reversed). Example output:
Code:
Now processing 158 ...
Now processing 75 ...
Now processing 3 ...
Now processing 2 ...
Now processing 1 ...

Jimbo
# 6  
Old 10-13-2002
Hi Jimbo,
Thanks, I think the sort -r will run faster then the sed '<address> p'. I will give it a try tomorrow.
Thanks,
Tony
# 7  
Old 10-14-2002
How about:
nl -ba inputfile | sort -nr | cut -f2-
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reversing a line based on column

Hi, I have a file that looks like this (tab seperated): read - DFHJ read1 - IOPE read2 + AAAB read3 + MMMN Basically what i want to do is reverse column 3 if column 2 has a - but leave it if its + so the output would look like this: read - JHFD read1 - EPOI read2 + AAAB... (3 Replies)
Discussion started by: kylle345
3 Replies

2. Shell Programming and Scripting

reversing multiple lines

Hi I want to reverse multiple lines from my file eg of File1 3 4 5 6 7 8 9 a b c d e f g h I am using this code to reverse lines but it can only work with one row awk -F'\t' '{while (NF){printf("%s%s", $(NF--),!NF?"":FS)}}' File1 > File2 I want the file to look like this 9 8 7 6 5 4... (2 Replies)
Discussion started by: phil_heath
2 Replies

3. Shell Programming and Scripting

reversing order of lines in a file

how can i reverse the line order in text files? (but total number of the lines is not constant ) for example i have a file like this: line1 line2 line3 . . lineN i wantto make it like this: lineN . . . line3 (26 Replies)
Discussion started by: gfhgfnhhn
26 Replies

4. Shell Programming and Scripting

Need help reversing this code

ssh servername.com "echo /$APP=$BUSIN >> $URI; echo /$APP/*=$BUSIN >> $URI" Ok for example here i ssh into a example servername.com, and I think what it does some line gets put into the urifile , my question is, how would i go about removing that in a script. in summary, the above code is... (3 Replies)
Discussion started by: new2learn09
3 Replies

5. Shell Programming and Scripting

reversing a line

Hi, I could not find this anywhere and I am wondering if someone knows a quick way of doing this. So heres the problem... I have a row that looks like this (an example): 5 4 3 2 1 What I want to do is reverse it so it looks like this: 1 2 3 4 5 Does anyone know the simple unix... (7 Replies)
Discussion started by: kylle345
7 Replies

6. Shell Programming and Scripting

reading and reversing a string

Hi Everyone....I am new to Unix and BASH programming...I just want to read a string and reverse it and display.....can anyone help me out???? (8 Replies)
Discussion started by: nikhilneela
8 Replies

7. Shell Programming and Scripting

Reversing file order using SED

Im trying to develop a shell script that will change the content order of the file. For example I have a file that says a b c d I want to change this to be d c b a Im trying to use sed to this by reading the file and then inserting each line at the top #!/usr/bin/ksh ... (3 Replies)
Discussion started by: MBGPS
3 Replies

8. Shell Programming and Scripting

awk and reversing

Hello I'm writing script in awk that reverse order the fields of every line in file. My script have problem with spaces - if there is more spaces between fields in line of file - my script erase them . I want my script work like command "tac" - how to change it ? #!/bin/sh file=$1... (1 Reply)
Discussion started by: scotty_123
1 Replies

9. Shell Programming and Scripting

output string in reversing order

If I have string { I_love_shell_scripts} anyone knows how to have output {stpircs_llehs_evol_I} by using shell and perl ?I know in perl, there is reverse() funcation, but can it be done by not using reverse()? (3 Replies)
Discussion started by: ccp
3 Replies

10. UNIX for Dummies Questions & Answers

Reversing UID's

Is it possible given a uid to determine information about the person with the uid? An example would be simple information regarding what group and the name of the person associated with that uid. It seems there is probably an easy staring me in the face but i cant seem to find it... (3 Replies)
Discussion started by: dreaming1
3 Replies
Login or Register to Ask a Question