Visit Our UNIX and Linux User Community


Help with cut and sort

 
Thread Tools Search this Thread
Homework and Emergencies Homework & Coursework Questions Help with cut and sort
# 1  
Old 09-13-2009
Help with cut and sort

<B>
andan100:Anders:Andersson:800101-1234:TNCCC_1:TDDB46 TDDB80:berbe101:Bertil:Bertilsson:800102-1234:TNCCC_1:TDDB46 TDDB80:
The top is how it looks right now I want it t look
like this under and I want it to be sorted. I have tried with cut -f -d studenter.txt and so on but it still doesnt work can anybody helop me?? plz
andan100 Andersson,Andersberbe101 Bertilsson,Bertil
It need to be called like this:

abcde123_uppgift2 studenter.txt

</B>
# 2  
Old 09-13-2009
Unable to understand the requirement exactly, anyway use cut with delimiter and required fields as,

cut -d':' -f1,2,9.. FILENAME

If you come up again, kindly explain what you tried also.
# 3  
Old 09-13-2009
i have a document that shows

xerxi124:Xerxes:Xi:800124-1234:TNCCC_1:TDDB46 TDDB80:
ostov129:Íster:Íverbliven:800129-1234:TNCCC_1:TDDB46 TDDB80:
cecca102:Cecilia:Carlsson:800103-1234:TNCCC_1:TDDB46 TDDB80:
perpe115:Per:Persson:800116-1234:TNCCC_1:TDDB46 TDDB80:
louli111:Louise:Linghed:760112-1234:TNDDD_3:TDDA01 TDDB81 TDDB80:
erier104:Erik:Eriksson:800105-1234:TNCCC_1:TDDB46 TDDB80:

I only want the loginname and the name, for example
erier104:Erik:Eriksson:800105-1234:TNCCC_1:TDDB46 TDDB80:
should be
erier104 Erik,Eriksson


I've done
#!/bin/sh
#!/bin/sh
cut -f 1,2,3 -d : sort : studenter.txt (studenter.txt is the file name)

Previous Thread | Next Thread
Test Your Knowledge in Computers #360
Difficulty: Medium
The find command first appeared in Version 4 AT&T UNIX.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using :<<cut / cut to comment out block of bash script

I am using : << cut / cut to comment out block of code. Works fine on few lines of script, then it gives me this cryptic error when I try to comment out about 80 lines. The "warning " is at last line of script. done < results 169 echo "END read all positioning parameters" 170... (8 Replies)
Discussion started by: annacreek
8 Replies

2. UNIX for Advanced & Expert Users

cut and sort

Please help. I have a file containing rows of information. The row needs to be broken down into blocks of 5 and then sorted. Example: 10381 1042010046 ... (4 Replies)
Discussion started by: Dolph
4 Replies

3. Shell Programming and Scripting

Cut Command error cut: Bad range

Hi Can anyone what I am doing wrong while using cut command. for f in *.log do logfilename=$f Log "Log file Name: $logfilename" logfile1=`basename $logfilename .log` flength=${#logfile1} Log "file length $flength" from_length=$(($flength - 15)) Log "from... (2 Replies)
Discussion started by: dgmm
2 Replies

4. Shell Programming and Scripting

Using a combination of sort/cut/grep/awk/join/paste/sed

I have a file and need to only select users that have a shell of “/bin/bash” in the line using awk or sed please help (4 Replies)
Discussion started by: boyboy1212
4 Replies

5. UNIX for Dummies Questions & Answers

Using the Sort, Cut, and Awk commands

Hello, I am trying, utilizing the few commands I know, to extract all records within my file that were generated in November of 2007. Each record within the file has a "date" field giving the month, day, and year (9-8-88). How do I extract those records to their own file? Once I extract... (4 Replies)
Discussion started by: babbabooey
4 Replies

6. Solaris

concatenate/sort/cut

I have the following requirement. 1. I have to concatenate the 10 fixed width files. 2. sort based on first 10 characters 3. after that i have remove first 10 chacters from the file. can you please tell me how to do it. Thanks in Advance Samba (1 Reply)
Discussion started by: samba
1 Replies

7. Shell Programming and Scripting

sort / cut question

Hi All, I have a small problem, hope you can help me out here. I have a file that contains the same format of lines in 99% of the cases. 906516 XYZ.NNN V 0000 20070711164648 userID1 userID2 hostname 20070711164641 There are unfortunately several lines with these... (5 Replies)
Discussion started by: BearCheese
5 Replies

8. Shell Programming and Scripting

using cut command with sort

how to cut for pattern in the file and then count each occurance? say, each line has unique pattern and u want to grep but at last, you want to see how many of them occur? say, cut -d'\" -f15 filename | sort -? or.. do i need to use sed or something.. i need to count lets say how... (5 Replies)
Discussion started by: hankooknara
5 Replies

9. UNIX for Dummies Questions & Answers

Help with Last,uniq, sort and cut

Using the last, uniq, sort and cut commands, determine how many times the different users have logged in. I know how to use the last command and cut command... i came up with last | cut -f1 -d" " | uniq i dont know if this is right, can someone please help me... thanks (1 Reply)
Discussion started by: jay1228
1 Replies

Featured Tech Videos