Hello guys!
I have some issue in how to processing some data.
I have some files with 3 columns. The 1st column is a name of my sample. The 2nd column is a numerical sequence (very big sequence) starting from "1". And the 3rd column is a feature of each line, represented for a number (completely independent from the 2nd column). Something like this: (hypothetically)
The problem is that when the value of 3rd column is zero, te line is not included in this file I have, generating something like this:
Note that the 2nd column jumps from 2 to 8 (the lines 3, 4, 5, 6 and 7 are not there because its respective 3rd column have a value = zero).
Question: Is there some command line that add the lines that are not present, resulting in something like this?
Best regards..
Moderator's Comments:
Please use code tags next time for your code and data.
Last edited by zaxxon; 08-29-2012 at 11:14 AM..
Reason: code tags
hi
i am having a file of following kind:
20015#67143645#143123#4214
62014#67143148#67143159#456
15432#67143568#00143862#4632
54112#67143752#0067143657#143
54623#67143357#167215#34531
65446#67143785#143598#7456
75642#67143546#156146#845
24464#67143465#172532#6544... (5 Replies)
I need to read contents of directory and create a list of data files that match a certain pattern and process by renaming it and calling a existing .ksh script then archiving off to file another directory. Any suggestions or samples u could point me to on using .ksh perl or other to process... (5 Replies)
I have some process . How should i know that the process is still processing data or got hanged even though it is showing that it is running in background
I know of a command called truss. how should i use this command and determine
1) process is still processing data
2) process got hanged... (7 Replies)
Hi, everyone,
I have a matrix, let's say:
1 2 3 4 5 6 ...
4 5 6 7 8 9 ...
7 8 9 1 2 3 ...
3 4 5 6 7 8 ...
.........
(nxm matrix)
Is there a simple command that can take certain specific rows out of the matrix?
e.g., I want to take row 2 (4 5 6 7 8 9 ...) and row 4 (3 4 5 6 7 8... (2 Replies)
I have a file, first 5 columns are very normal, like "1107",106027,71400,"Y","BIOLOGY",,
however, the 6th columns, the user can put comments, anything, just any characters, like new line, double quote, single quote, whatever from the keyboard, like"Please load my previous SOM597G course content in... (3 Replies)
Dear fellow members,
I've just joined the forum and am a newbie to shell scripting and programming. I'm stuck on the following problem.
I'm working with large scale genomic data and need to do some analyses on it. Essentially it is text processing problem, so please don't mind the scientific... (0 Replies)
Hello,
I have some bitrate data in a csv which is in an odd format and is difficult to process in Excel when I have thousands of rows. Therefore, I was thinking of doing this in bash and using awk as the primary application except that due to its complication, I'm a little stuck.
... (24 Replies)
I have below Data ***************************************************
********************BEGINNING-1********************
directive url is : https://coursera-eu.mokar.com/directives/96df29ff-176a-35f7-8b1b-4ce483d15762
Src urls are :... (8 Replies)
Hi guys, I receive a list from pipe (with fixed number of lines) like this:
name1
name2
name3
And in my ./ folder I have three files:
01-oldname.test
02-someoldname.test
03-evenoldername.test
How to rename files one by one using while read?
Desired result:
01-name1.test
02-name2.test... (3 Replies)
Discussion started by: useretail
3 Replies
LEARN ABOUT NETBSD
column
COLUMN(1) BSD General Commands Manual COLUMN(1)NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
column exits 0 on success, >0 if an error occurred.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(echo "PERM LINKS OWNER GROUP SIZE MONTH DAY HH:MM/YEAR NAME";
ls -l | sed 1d) | column -t
SEE ALSO colrm(1), ls(1), paste(1), sort(1)HISTORY
The column command appeared in 4.3BSD-Reno.
BSD March 9, 2008 BSD