cut lines in a file.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting cut lines in a file.
# 1  
Old 07-28-2009
cut lines in a file.

Hi Everyone,
I have a file a.txt, inside is
Mon Jul 20 00:05:07 2009 12
Mon Jul 20 00:05:08 2009 1

The output should be a.txt, inside is
00:05:07 12
00:05:08 1

My method is
Code:
`cat a.txt | cut -f4,6 -d' ' > a.txt.tmp;mv -rf a.txt.tmp a.txt`;

Is any good way to do this? like perl directly or awk.

Thanks
# 2  
Old 07-28-2009
try this
Code:
awk '{print $4,$6}' file

# 3  
Old 07-28-2009
Quote:
Originally Posted by ryandegreat25
try this
Code:
awk '{print $4,$6}' file

Thanks Smilie,

But the issue is, i attached my a.txt.
I can copy those two lines from a.txt into the excel file, so the last field in a.txt can be pasted into another column (field) in the excel file.

by running awk '{print $4,$6}' file, will cause then pasted into one column (field) in the excel file.

Please advice.

Thanks
# 4  
Old 07-28-2009
redirect your output to a .csv file
# 5  
Old 07-28-2009
Quote:
Originally Posted by rakeshawasthi
redirect your output to a .csv file
I did:
Code:
awk '{print $4,"\t",$6}' a.txt

# 6  
Old 07-28-2009
yes i think the default delimiter in csv is "tab"
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cut lines from and to in a textfile

i am having a text file like below rama surya pandu latha singh raja i want to get the new file from 3 to 5 i.e pandu latha singh please help (1 Reply)
Discussion started by: suryanarayana
1 Replies

2. UNIX for Dummies Questions & Answers

Cut particular lines

All, I would like to cut all the lines from the log file for the timestamp . I'm not clear about how to apply grep ,awk here.Can you help me on this ? My logfile: ********** Wed Feb 20 03:48:26 2013 Thread 1 advanced to log sequence 400 (LGWR switch) Thu Feb 21 02:34:23 2013... (1 Reply)
Discussion started by: arul1185
1 Replies

3. Shell Programming and Scripting

Cut Lines using grep

Hi, I have a SQL script with "create table" and "alter table" statements and I want to cut all the alter table statements from original file (A) and move it to a different file (B). Can you please me the option. Thanks a lot for your time. (3 Replies)
Discussion started by: bhupinder08
3 Replies

4. Shell Programming and Scripting

cut lines from log file and save it another file

Dears, i want cut the lines from a log file. Example of the log file as follows.. May 27, 2011 5:54:51 PM com.huawei.ivas.utilities.sm.client.SMDeliverContrUtil isDeliverSM FINE: May 27, 2011 5:54:51 PM com.huawei.ivas.utilities.sm.client.SMUtil addSysUpMsgLog INFO: . The message content... (1 Reply)
Discussion started by: tonypalokkaran
1 Replies

5. UNIX for Dummies Questions & Answers

cut particular lines from a file

how can I cut out partiluar lines like from line 233 to 347 ? any idea? (2 Replies)
Discussion started by: kvok
2 Replies

6. Shell Programming and Scripting

Cut display multiple lines of output

I have a script that runs a command, and the output is on multiple lines. The fields are delimited by '='. I need the 8th column from the first line and the 2nd from the second line, but I can't figure out how to display the second line. command1 | cut -d '=' -f 8 The above gets me what I... (2 Replies)
Discussion started by: cbo0485
2 Replies

7. Shell Programming and Scripting

Cut lines before keyword

Hi, How to cut all lines in file before keyword? from 1 2333214 word ...... some text 2 234343 234234 word ...... some text 3 234324 324 3234 word ...... some text to 1 2333214 2 234343 234234 3 234324 324 3234 (4 Replies)
Discussion started by: Trump
4 Replies

8. Shell Programming and Scripting

How reverse cut or read rows of lines

Hi, My records are like this BSC403_JAIN03|3153_TropicalFarm_LIMJM1-3_97| BSC403_JAIN03|3410_PantaiAceh_PCEHM1_4_97| BSC406_BMIN02|1433_JomHebohTV3_COW7M1_11_97| I want to extract the value before _97| This command BSC_ID=`echo $DATA | cut -f5 -d"_"` gives me _97|, 4, 11 and by... (16 Replies)
Discussion started by: doer
16 Replies

9. Shell Programming and Scripting

cut 11 lines from a file

All, I have a file that I want to read, cut 12 lines and direct into a new file, and continue to do this until I reach the EOF. How do I do it? can I use cat or read to do this? the file is formated with repetitive output consisting of these 12 lines date: <Timestamp> dev_id: <device ID>... (7 Replies)
Discussion started by: turk22
7 Replies

10. Shell Programming and Scripting

cut a number of lines out of a file

Hi, I have a text file contaning around 150 lines, each line is a hostname. I want to read 4 lines/hostnames and save those 4 lines to a seperate file. say the big file is /files/bigfile and I want to have a lot of files in /files named /files/smallfile.1 , /files/smallfile.2 and so on... ... (1 Reply)
Discussion started by: networkfre@k
1 Replies
Login or Register to Ask a Question