ls in specific columns Post: 302572358

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace specific columns

hi All, Thi sis very urgent. I have large files with pipe delimited. For example: 1.txt 1001024|120|9|-0.0|#| 1001025|120|9|#| 1001026|120|9|#| 1001032|120|2|-0.0|#| 1002026|110|9|#| 1002027|110|9|-0.0|#| 1002028|120|1|1.0|#| I need to replace the 4th filed if it is # by |-| my...

2. Shell Programming and Scripting

Mean of the specific columns

I have a input file that has some common values in 1st,2nd and 3rd columns. 4th and 5th are different. Now I would like to print the mean of the fourth column of similar values in 1st.2nd and 3rd columns along with all the values in 5th column. input NM_0 1.22 CR5 0.4 n_21663...

3. Shell Programming and Scripting

Replace specific columns in one file with columns in another file

HELLO! This is my first post here! By the way, I think it is great that people do this. My question: I have two files, one is a .dilm and one is a .txt. It is my understanding that the .dilm file can be treated as a .txt file. I wrote another program where I was able to manipulate it as if it...

4. UNIX for Dummies Questions & Answers

How to delete all columns that start with a specific value

I have this space delimited large text file with more than 1,000,000+ columns and about 100 rows. I want to delete all the columns that start with NA such that: File before modification aa bb cc NA100 dd aa b1 c2 NA101 de File after modification aa bb cc dd aa b1 c2 de How would I...

5. Shell Programming and Scripting

Deleting specific columns

Hi group, Can you please tell how to delete specific columns from a file. I know something like awk -F, '{ print $1" "$2" "15 }' input.txt > output.txt will delete all other columns. But this is in a way to copy some particular columns. But is there any other way to select just some...

6. Shell Programming and Scripting

Can't figure out how to find specific characters in specific columns

I am trying to find a specific set of characters in a long file. I only want to find the characters in column 265 for 4 bytes. Is there a search for that? I tried cut but couldn't get it to work. Ex. I want to find '9999' in column 265 for 4 bytes. If it is in there, I want it to print...

7. UNIX for Dummies Questions & Answers

Printing lines with specific strings at specific columns

Hi I have a file which is tab-delimited. Now, I'd like to print the lines which have "chr6" string in both first and second columns. Could anybody help?

8. UNIX for Dummies Questions & Answers

Intersection by specific columns

Hi, I'd like to intersect two files by the 4th col of the first file and 6th col of the second file. This is the code I use: awk 'NR==FNR{A;next}$6 File1 File2 However, this is only outputting the second file lines. I'd like to have both lines in a single line separated by a tab. Thanks in...

9. UNIX for Dummies Questions & Answers

Grep in specific columns

I am trying to search a list of strings from a file and display the string as well as the column in the search file it was found. I dont care about the row. what is wrong with my script? while read line; do awk -v var="$line" '{for(i=1;i<NF;i++) if ($NF==$var) break; print $var FS $NF' }'...

10. Shell Programming and Scripting

Converting data from specific columns

i have a file (csv or txt or anything which has 4 columns (id,name,number,location) and it contains data. i want to convert the data of specific columns like name to ooooo and number to 88888 matching the field length of that columns. for example if name column has anthony which is 7, it should...

LEARN ABOUT DEBIAN

tv_sort

TV_SORT(1p)						User Contributed Perl Documentation					       TV_SORT(1p)

NAME

       tv_sort - Sort XMLTV listings files by date, and add stop times.

SYNOPSIS

       tv_sort [--help] [--by-channel] [--output FILE] [FILE...]

DESCRIPTION

       Read XMLTV data and write out the same data sorted in date order.  Where stop times of programmes are missing, guess them from the start
       time of the next programme on the same channel. For the last programme of a channel, no stop time can be added.

       Tv_sort also performs some sanity checks such as making sure no two programmes on the same channel overlap.

       --output FILE write to FILE rather than standard output

       --by-channel sort first by channel id, then by date within each
		       channel.

       --duplicate-error If the input contains the same programme more than once,
			    consider this as an error. Default is to silently
			    ignore duplicate entries.

       The time sorting is by start time, then by stop time.  Without --by-channel, if start times and stop times are equal then two programmes
       are sorted by internal channel id.  With --by-channel, channel id is compared first and then times.

       You can think of tv_sort as converting XMLTV data into a canonical form, useful for diffing two files.

EXAMPLES

       At a typical Unix shell or Windows command prompt:

       tv_sort <in.xml >out.xml
       tv_sort in.xml --output out.xml

       These are different ways of saying the same thing.

AUTHOR

       Ed Avis, ed@membled.com

perl v5.14.2							    2006-03-02							       TV_SORT(1p)