i have a record like
1,23423,4545,6767,89898,3434,121212,123123,322
2,23233,3434,4545,56566,rxrx,e344343,343434,3434
1,23223,336,78787,78787,654,6767677,6877989,7878
i want to check the $6 field if its start with any letters, i want to move this record to some other file and keep rest of... (2 Replies)
Hi
I have a file which is having following text. The file is in a tabular form with 5 fields. i.e field1, field2 ..... field5 are its columns and there are many rows in it say COUNT is the number of rows
Field 1 Field2 Field3 Field4 Field5
------- ------- ... (8 Replies)
Thank everyone advanced.
Would you please tell me how to use the shell variable in the awk body?
I try follows but they all do not work, pls kindly help me:
1.
str=`cat file2`
awk 'BEGIN{print("'"$str"'"}' file1 > file3
2.
str=`cat file2`
awk 'BEGIN{print(ENVIRON}' file1 > file3
3.... (3 Replies)
Guys
I have the file TEST.csv generated after a join of two different files with the same columns:
key,string,data,number,key,string,data,number
abc,test,020202,3,abc,test,010305,4
abc,level,070202,9,abc,tool,010203,7
def,tool,010101,7,,,,
ghi,,,ghi,test,010203,8
I have to generate a... (2 Replies)
Hi All,
I am a beginner to Unix. So would really appreciate if people out here can help me out.
I have a XML file which has a element <NoteData> in which two values DBHA and DAKO.
I need to search these in all the XML files in a directory and if found in the XML file then replace the... (3 Replies)
Hi
I have a scenario where i have a file name as
abcd_To_hfgh.20090456778_1.dat
I will get the filename as parameter
and i need a string in between second _ and first . i.e i need hfgh in this case.
Please help me with the script. This may not be awk script even if it can be... (2 Replies)
Hi All,I need to convert following field from a file
L2578978CLC/576/116804 => L2578978CLC/00000576/00168304
i have to append Zeros in the third and fourth number after slash / in the above string (total length of number should be 8).
means L2578978CLC/576/116804 should be converted to... (3 Replies)
Hello,
I have a file with the follwoing pattern:
Input file:
===========
tcp://xxx:123
8179 YY
1798 YY
tcp://abc:2345
not found
tcp://swt:4945
7356 QQ
tcp://pqr:456
8178 PP
9485 PP
4485 PP (8 Replies)