01-02-2015
You can do this in bash using 'while read -a your_array;do ... done < file_in'. You must set up the array variable in advance, and your columns will be put away in the array for each line/row. You can test the columns and decide whether to echo out (reproduce) the row.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have created a script which adding two columns and removing two columns for all files.
Filename: Cust_information_1200_201010.txt
Source Data:
"1","Cust information","123","106001","street","1-203 high street"
"1","Cust information","124","105001","street","1-203 high street"
... (0 Replies)
Discussion started by: onesuri
0 Replies
2. Shell Programming and Scripting
I have a control file which tells me which are the fields in the files I need to compare and based on the values I need to print the exact value if key =Y and output is Y , or if output is Y/N then I need to print only Y if it matches or N if it does not match and if output =N , then skip the feild... (7 Replies)
Discussion started by: newtoawk
7 Replies
3. Shell Programming and Scripting
Hello everyone,
I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble.
I have many files each having two columns and hundreds of rows.
first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 Replies
4. Shell Programming and Scripting
Hi I have a matrix with n rows and m columns like below example. i want to extract all the pairs with values <200.
Input
A B C D
A 100 206 51 300
B 206 100 72 48
C 351 22 100 198
D 13 989 150 100
Output format
A,A:200
A,C:51
B,B:100... (2 Replies)
Discussion started by: anurupa777
2 Replies
5. Shell Programming and Scripting
I have a file some thing like this:
GN Name=YWHAB;
RC TISSUE=Keratinocyte;
RC TISSUE=Thymus;
CC -!- FUNCTION: Adapter protein implicated in the regulation of a large
CC spectrum of both general and specialized signaling pathways
GN Name=YWHAE;
RC TISSUE=Liver;
RC ... (13 Replies)
Discussion started by: raj_k
13 Replies
6. Shell Programming and Scripting
Hi Friends,
Hope all is well.
I have an input file like this
a gene1 10
b gene1 2
c gene2 20
c gene3 10
d gene4 5
e gene5 6
Steps to reach output.
1. Print unique values of column1 as column of the matrix, which will be
a
b
c (5 Replies)
Discussion started by: jacobs.smith
5 Replies
7. UNIX for Dummies Questions & Answers
I need to write the list of files to a new file in one column , the second column would contain the first line of that file (header record extracted through head -1 ) and the third column would contain the last record of that file (trailer record tail -1 ) .
Example :- folder where the files... (8 Replies)
Discussion started by: IshuGupta
8 Replies
8. Shell Programming and Scripting
HI All,
I'm embedding SQL query in Script which gives following output:
Assignee Group Total
ABC Group1 17
PQR Group2 5
PQR Group3 6
XYZ Group1 10
XYZ Group3 5
I have saved the above output in a file.
How do i sum up the contents of this output so as to get following output:
... (4 Replies)
Discussion started by: Khushbu
4 Replies
9. Shell Programming and Scripting
Hi everyone,
I have a situation in which I have multiple (3 at last count) date columns in a CSV file (, delim), which need to be changed from:
January 1 2017 (note, no comma after day)
to:
YYYY-MM-DD
So far, I am able to convert a date using:
date --date="January 12, 1990" +%Y-%m-%d
... (7 Replies)
Discussion started by: richardsantink
7 Replies
10. Shell Programming and Scripting
Hello,
I have a requirement to apply hashing algorithm on flat file on one or more columns dynamically based on header
sample input file
ID|NAME|AGE|GENDER
10|ABC|30|M
20|DEF|20|F
say if i want multiple columns based on the header example id,name or id,age or name,gender and hash and... (13 Replies)
Discussion started by: mkathi
13 Replies
LEARN ABOUT PHP
ibase_fetch_assoc
IBASE_FETCH_ASSOC(3) 1 IBASE_FETCH_ASSOC(3)
ibase_fetch_assoc - Fetch a result row from a query as an associative array
SYNOPSIS
array ibase_fetch_assoc (resource $result, [int $fetch_flag])
DESCRIPTION
Fetch a result row from a query as an associative array.
ibase_fetch_assoc(3) fetches one row of data from the $result. If two or more columns of the result have the same field names, the last
column will take precedence. To access the other column(s) of the same name, you either need to access the result with numeric indices by
using ibase_fetch_row(3) or use alias names in your query.
PARAMETERS
o $result
- The result handle.
o $fetch_flag
-$fetch_flag is a combination of the constants IBASE_TEXT and IBASE_UNIXTIME ORed together. Passing IBASE_TEXT will cause this
function to return BLOB contents instead of BLOB ids. Passing IBASE_UNIXTIME will cause this function to return date/time values
as Unix timestamps instead of as formatted strings.
RETURN VALUES
Returns an associative array that corresponds to the fetched row. Subsequent calls will return the next row in the result set, or FALSE if
there are no more rows.
SEE ALSO
ibase_fetch_row(3), ibase_fetch_object(3).
PHP Documentation Group IBASE_FETCH_ASSOC(3)