ansaurus

Question

Answer 1

+2 A:

Do you have to do this in C? This would be easier to do in a scripting language like perl, or even awk.

awk '{print $1 $6 $7 $8 $9}' file.txt

Seth 2010-03-15 03:07:43

Answer 2

A:

Try to open them in excel with space as delimiter, delete it there. See if it works.

hallie 2010-03-15 03:08:03

Answer 3

+2 A:

Easily done as a shell pipe.

cut --delimiter=' ' --fields=3-5 --complement

If you really need to do this in C, you could run that command in a subprocess via popen.

If you had mixed space and tab delimiters, you would need to convert one to the other as cut does not like multiple delimiters. Do this with tr or col -x.

Lachlan Roche 2010-03-15 03:09:10

Answer 4

+3 A:

Pipe it through awk '{print $1 $6 $7 $8 $9;}'?

Mike DeSimone 2010-03-15 03:09:15

Answer 5

A:

I smell homework, but I'll give you the benefit of the doubt.

Cut will work, but you need to merge one or more spaces into just one first:

sed "s/ \+/ /g" input_file | cut -d' ' -f-2,6-

To save the output of any command to a file, it's command > file.

Max E. 2010-03-15 03:12:49

Answer 6

A:

Thx guys, I'll give it a try! I was being stupid when I tagged it as being C. Its really just Unix and scripting. My bad!

Joey jie 2010-03-15 03:13:25

This is not a forum; don't respond by "posting an answer" unless the answer turned out to be none of those given. Please respond by using the "add comment" links under the answer(s) you are responding to.

Mike DeSimone 2010-03-15 03:27:31

Answer 7

+2 A:

how does your cut command look like?

$ cut -d" " -f1,6- file
fe120b99164f151b28bf86afa6389b22 186 2010-03-14 19:26 Descript.txt
41705ea936cfc653f273b5454c1cdde6  30 2010-03-14 20:29 listof.txt
0e25cca3222d32fff43563465af03340  28 2010-03-14 23:35 sedexample.txt
d41d8cd98f00b204e9800998ecf8427e   0 2010-02-16 15:11 test1.txt
d41d8cd98f00b204e9800998ecf8427e   0 2010-02-16 15:11 test2.txt
d41d8cd98f00b204e9800998ecf8427e   0 2010-02-16 15:11 test3.txt
d41d8cd98f00b204e9800998ecf8427e   0 2010-02-16 15:11 test4.txt
d41d8cd98f00b204e9800998ecf8427e   0 2010-02-16 15:11 test5.txt
d41d8cd98f00b204e9800998ecf8427e   0 2010-02-16 15:11 test6.txt
f5c7f1856249d0526be10df5bd5b895a  26 2010-03-13 14:13 testingfile.txt
d41d8cd98f00b204e9800998ecf8427e   0 2010-03-15 00:28 uniquelist.txt

redirect to new file as needed.

Or awk

$ awk '{$2=$3=$4=$5="";gsub(/ +/," ")}1' file
fe120b99164f151b28bf86afa6389b22 186 2010-03-14 19:26 Descript.txt
41705ea936cfc653f273b5454c1cdde6 30 2010-03-14 20:29 listof.txt
0e25cca3222d32fff43563465af03340 28 2010-03-14 23:35 sedexample.txt
d41d8cd98f00b204e9800998ecf8427e 0 2010-02-16 15:11 test1.txt
d41d8cd98f00b204e9800998ecf8427e 0 2010-02-16 15:11 test2.txt
d41d8cd98f00b204e9800998ecf8427e 0 2010-02-16 15:11 test3.txt
d41d8cd98f00b204e9800998ecf8427e 0 2010-02-16 15:11 test4.txt
d41d8cd98f00b204e9800998ecf8427e 0 2010-02-16 15:11 test5.txt
d41d8cd98f00b204e9800998ecf8427e 0 2010-02-16 15:11 test6.txt
f5c7f1856249d0526be10df5bd5b895a 26 2010-03-13 14:13 testingfile.txt
d41d8cd98f00b204e9800998ecf8427e 0 2010-03-15 00:28 uniquelist.txt

ghostdog74 2010-03-15 03:25:26

My original cut command was like this:more indexfile.txt | cut -d " " -f 1,6,7,8,9 >goodindex.txt

Joey jie 2010-03-15 03:29:34

Many thanks for your help! Your solution was perfect!

Joey jie 2010-03-15 03:30:17

@Joey jie: In case it is not clear why your initial *cut* sometimes dropped the time and/or filename: The extra padding spaces in the size(?) column created extra, empty fields internally in *cut*. This caused your field enumeration to be too short in some cases. If you used `-f1,6,7,8,9,10,11` it would have worked, but obviously `-f1,6-` is more succinct and flexible. You would need a different solution if you wanted to cut out fields that were beyond the first space-padded column. Maybe `cut -c` if all the columns (before and including the columns you want to cut) have fixed widths.

Chris Johnsen 2010-03-15 07:12:01

Answer 8

A:

I tried using awk '{print $1 $6 $7 $8 $9}' file.txt however it gives me the following output:

fe120b99164f151b28bf86afa6389b221862010-03-1419:26Descriptions.txt 41705ea936cfc653f273b5454c1cdde6302010-03-1420:29listofnumbers.txt 0e25cca3222d32fff43563465af03340282010-03-1423:35sedexample.txt d41d8cd98f00b204e9800998ecf8427e02010-02-1615:11test1.txt d41d8cd98f00b204e9800998ecf8427e02010-02-1615:11test2.txt d41d8cd98f00b204e9800998ecf8427e02010-02-1615:11test3.txt d41d8cd98f00b204e9800998ecf8427e02010-02-1615:11test4.txt d41d8cd98f00b204e9800998ecf8427e02010-02-1615:11test5.txt d41d8cd98f00b204e9800998ecf8427e02010-02-1615:11test6.txt f5c7f1856249d0526be10df5bd5b895a262010-03-1314:13testingfile.txt d41d8cd98f00b204e9800998ecf8427e02010-03-1500:28uniquelist.txt

All the columns have become joined into one which is not ideal for me as I will be using uniq one this at some point. Thanks for your help!

Joey jie 2010-03-15 03:26:15

Answer 9

A:

$ perl -lane'$, = " "; print @F[0,5..$#F]' input.txt

NOTE: As well as the cut version it replaces two or more spaces in the input by a single space e.g., it can broke filenames in the input.

J.F. Sebastian 2010-03-15 08:04:34

ansaurus

tags:

views:

answers:

How to delete columns?

related questions