10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Experts,
Need your support for this awk script.
we have only one input file, all these column 1 and column 2 are in same file and have to do lookup for values in one file(column1 and column2) but output we need in another file
Need to grep row whose string contains 9K from column 1. When found... (6 Replies)
Discussion started by: as7951
6 Replies
2. Shell Programming and Scripting
Hi
Does anyone know of an efficient way to index a column of data in file2 to print the coresponding row in file1 which corresponds to the data in file2 AND 30 rows preceding and after the row in file1.
For example suppose you have a list of numbers in file2 (single column) as follows:... (6 Replies)
Discussion started by: Geneanalyst
6 Replies
3. Shell Programming and Scripting
Hi,
I have the following type of data that is separated by tabs:
-2 abandonar abandono abandonas abandona abandonamos abandonáis abandonan
-4 abandonado abandonada abandonados abandonadas
-2 abandona abandonos ... (1 Reply)
Discussion started by: owwow14
1 Replies
4. Shell Programming and Scripting
Hi,
I have following input and want to change it to following output
INPUT
01-APR-14,KB,822714
01-APR-14,MB,8133431
02-APR-14,KB,757140
02-APR-14,MB,7770368
03-APR-14,KB,815427
03-APR-14,MB,7590511
04-APR-14,MB,7529895
04-APR-14,KB,779561
05-APR-14,MB,8151537
05-APR-14,KB,809675
... (6 Replies)
Discussion started by: siramitsharma
6 Replies
5. Shell Programming and Scripting
I have a XML in which <Amt Ccy="EUR">3.1</Amt> tag repeats. This is under another tag <Main>. I need to sum all the values of <Amt Ccy=""> (Ccy may vary) coming under <Main> using awk and or sed command.
can some help?
Sample looks like below
<root>
<Main>
... (6 Replies)
Discussion started by: bk_12345
6 Replies
6. Shell Programming and Scripting
Sed replace using same pattern repeating multiple times in a line
I have text like below in a file:
I am trying to replace the above line to following
How can I acheive this?
I am able to do it if the occurrence is for 1 time:
But If I try like below
I am getting like this:
I have to... (4 Replies)
Discussion started by: sol_nov
4 Replies
7. Shell Programming and Scripting
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies
8. Shell Programming and Scripting
Need to transpose in awk rows to column like this:
input:
A1,6,5,4 3,2,1,
A2,8,7,9,10,11,12,13,14
A3,1,2,3,5,7,8,9
A4,9,4,8,1,5,3,
output:
A1,1
A1,2
A1,4
...
A2,7
A2,8
...
A3,1
A3,2
...
A4,1
A4,3 (5 Replies)
Discussion started by: sdf
5 Replies
9. Shell Programming and Scripting
Hi,
I have an sqlplus output file using the character ';' as a delimiter and I would like to replace the fields without datas (i.e delimited by ';;') by ';0;'
Example: my sqlplus output:
11;22;33;44;;;77;;
What I would like to have:
11;22;33;44;0;0;77;0;
Thanks in advance for your... (2 Replies)
Discussion started by: popesk
2 Replies
10. Shell Programming and Scripting
Hello all, :)
I have a pattern file some what like this,
cd003
cd005
cd007
cd008
and input file like this,
abc cd001 cd002 zca
bca cd002 cd003 cza
cba cd003 cd004 zca
bac cd004 cd005 zac
cba cd005 cd006 acz
acb cd006 cd007 caz
cab cd007 ... (25 Replies)
Discussion started by: admax
25 Replies