10-02-2012
Can -v option in awk be used to store an array of variables?
I want to pass an array of variables to be inserted by awk in the 2nd column of a file.
|
Empl No. Employee Age |
1000000 22 |
1100000 24 |
1200000 26 |
Now, I want to pass an array having three different ages which need to replace the ages in the above table. Can I pass them to awk for it to replace the second column with new ages from an array?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to store contents of command
dir in array of variables
For eg: dir contents are
command d2 demovi~ file inven java new untitled folder
d1 demovi er1 filename inven~ myfiles ubuntu desktop xmms
-----------------------------------
I... (3 Replies)
Discussion started by: netresearch
3 Replies
2. Shell Programming and Scripting
Hi all.
Well, I have the next code:
I need to make an array with the values I have in the bucle, but just don't get it...
Question is, how can I store in an array that values, and how can I display them with echo? (8 Replies)
Discussion started by: crcbad
8 Replies
3. UNIX for Dummies Questions & Answers
im looping through an array setting three variables each time (one of the variables gives me the position in the array and is incremented each loop)
im trying to then set the variables to that position in the array without much luck. any ideas?
anArray=`$VAR1+$VAR2+"("$pos")"` (1 Reply)
Discussion started by: magnia
1 Replies
4. Shell Programming and Scripting
Hi,
I am trying to sort and display the below(like) input using awk command:
Input:
------
0;A
4;A
5;A
33;A
45;A
0;B
4;B
5;B
33;B
45;B
Output (desired): (5 Replies)
Discussion started by: pvamsikr
5 Replies
5. Shell Programming and Scripting
Guys anyone know how i can store fields into multiple variables in one go?
I'm wanting to grab the disk id's from format into disk1 and disk2
Below is what i want to work but i know it doesnt :-
: | format | awk '/^(\ +)/ {print $2}' | read disk1 disk2
The below does work...but i don't... (5 Replies)
Discussion started by: lavascript
5 Replies
6. Shell Programming and Scripting
Hi
I want to write a script which store all the parameters passed to the script into an array.
Once it is stored I want scan through the array and and delete those files for last month present inside the directory. The files in directory is appneded with YYYY_MM_DD.
I want to know how can I... (3 Replies)
Discussion started by: dgmm
3 Replies
7. Shell Programming and Scripting
Hi to all,
I have this input:
<group>
<x "2">Group D</x>
<x "3">Group B</x>
<x "1">Group A</x>
</group>
<group>
<x "1">Group E</x>
<x "0">Group B</x>
<x "1">Group C</x>
</group>
<group> ... (11 Replies)
Discussion started by: Ophiuchus
11 Replies
8. Shell Programming and Scripting
Hi everybody
I wanna store some values that r in a .txt file in some arrays
for example I have:
32782 28
32783 02
32784 01
32785 29
32786 25
32787 25
32788 00
32789 25
32790 02
32791 29
32792 23
32793 01
32794 28
and I need to save the first... (4 Replies)
Discussion started by: Behrouzx77
4 Replies
9. Shell Programming and Scripting
I have awk command :
awk -F ' ' '{ print $NF }' log filename
And it gives the output as below:
06:00:00
parameters:
SDS
(2)
no
no
no
no
doc=4000000000).
information: (6 Replies)
Discussion started by: ramprabhum
6 Replies
10. Shell Programming and Scripting
Here's my code:
awk -F '' 'NR==FNR {
if (/time/ && $5>10)
A=$2" "$3":"$4":"($5-01)
else if (/time/ && $5<01)
A=$2" "$3":"$4-01":"(59-$5)
else if (/time/ && $5<=10)
A=$2" "$3":"$4":0"($5-01)
else if (/close/) {
B=0
n1=n2;
... (2 Replies)
Discussion started by: klane
2 Replies
LEARN ABOUT PHP
db2_tables
DB2_TABLES(3) 1 DB2_TABLES(3)
db2_tables - Returns a result set listing the tables and associated metadata in a database
SYNOPSIS
resource db2_tables (resource $connection, [string $qualifier], [string $schema], [string $table-name], [string $table-type])
DESCRIPTION
Returns a result set listing the tables and associated metadata in a database.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the tables. This parameter accepts a search pattern containing _ and % as wildcards.
o $table-name
- The name of the table. This parameter accepts a search pattern containing _ and % as wildcards.
o $table-type
- A list of comma-delimited table type identifiers. To match all table types, pass NULL or an empty string. Valid table type iden-
tifiers include: ALIAS, HIERARCHY TABLE, INOPERATIVE VIEW, NICKNAME, MATERIALIZED QUERY TABLE, SYSTEM TABLE, TABLE, TYPED TABLE,
TYPED VIEW, and VIEW.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the tables that match the specified parameters. The rows are
composed of the following columns:
+------------+---------------------------------------------------+
|Column name | |
| | |
| | Description |
| | |
+------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | The catalog that contains the table. The value is |
| | NULL if this table does not have catalogs. |
| | |
|TABLE_SCHEM | |
| | |
| | Name of the schema that contains the table. |
| | |
|TABLE_NAME | |
| | |
| | Name of the table. |
| | |
|TABLE_TYPE | |
| | |
| | Table type identifier for the table. |
| | |
| REMARKS | |
| | |
| | Description of the table. |
| | |
+------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_spe-
cial_columns(3), db2_statistics(3), db2_table_privileges(3).
PHP Documentation Group DB2_TABLES(3)