10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have a multicolumn text file with header in the first row like this
The headers are stored in an array called . which contains I want to search for each elements of this array from that multicolumn text file. And I am using this awk approach
for ii in ${hdr}
do
gawk -vcol="$ii" -F... (1 Reply)
Discussion started by: Atta
1 Replies
2. Shell Programming and Scripting
echo {mbr_key,grp_key,dep_key,abc,xyz,aaa,ccc} |
awk 'gsub(/^|abc,|$/,"") {print}'
Required output
{grp_key,xyz,aaa,ccc} (5 Replies)
Discussion started by: 100bees
5 Replies
3. Shell Programming and Scripting
Hi Experts,
Can you please advise , why I am not able to make it work, or why this is not working: I spent quite a lot of time on this figuring out , but not working,
file :
This is a test file thanks for your reply
This is another file again
Have a nice day this is a small file... (3 Replies)
Discussion started by: rveri
3 Replies
4. Shell Programming and Scripting
Hi- I have issue with the code to get the input file reformat
--Goal is reformat and print out only column name one per line, leading space or trailing space will be removed...
--TABLE1.DDL as input file, and content of file as show below
REPLACE VIEW TABLE1
(
ID
,COL1
... (3 Replies)
Discussion started by: lv99
3 Replies
5. Shell Programming and Scripting
Hi,
i have a file that contains the following:
ARTPRD01_app =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.222.3.4)(PORT = 1540))
(CONNECT_DATA =
(SERVICE_NAME = artprd01.com)
ARTPRD01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.223.3.1)(PORT =... (2 Replies)
Discussion started by: reignangel2003
2 Replies
6. UNIX for Dummies Questions & Answers
I have a file that has the words I want to find in other files (but lets say I just want to find my words in a single file). Those words are IDs, so if my word is ZZZ4, outputs like aaZZZ4, ZZZ4bb, aaZZZ4bb, ZZ4, ZZZ, ZyZ4, ZZZ4.8 (or anything like that) WON'T BE USEFUL.
I need the whole word... (6 Replies)
Discussion started by: chicchan
6 Replies
7. Shell Programming and Scripting
hi
I have posted it earlier but i was unable to put my exact problem.This time posting in parts.
I have a text file which i had transferred to UNIX.It has strings like:
alter table table_name add (column_name);
as well as modify options.
now i need to read the table name between alter... (3 Replies)
Discussion started by: alisha
3 Replies
8. Shell Programming and Scripting
I'm trying to use awk to extract certain text from a file. The file looks like this:
Start
1 10
2 20
3 30
...
...
...
<some word>
Now what I want to extract is the list of numbers (without the search text printed) that occur between "Start" and <some word>. The catch is... (23 Replies)
Discussion started by: NickC
23 Replies
9. Shell Programming and Scripting
suppose u hava a file
G1354R tGGC-CGC
D1361N cGAC-AAC
I1424T ATC-ACC
R768W gCGG-TGG
Q1382R CAG-CGG
Q178E gCAG-GAG
Y181C TAC-TGC
.........cont.
So the question is
By searching for first word i.e.character say R
output shud be
R768W gCGG-TGG
R182P CGG-CCG
R189W ... (6 Replies)
Discussion started by: cdfd123
6 Replies
10. Shell Programming and Scripting
If I have data as below :
1,ABC,XXXX
2,ABC000,YYYY
3,DEF,AAAA
4,ABC0,ZZZZ
I want to get records whose 2nd col exactly match with word 'ABC'
I am using command below :
awk -F"," '$2~/ABC/' Filename
It is retrieving records as -
1,ABC,XXXX
2,ABC000,YYYY
4,ABC0,ZZZZ
But in... (8 Replies)
Discussion started by: videsh77
8 Replies