10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
2. UNIX for Dummies Questions & Answers
Could anyone please advise what the in the following if statement means?
if ; then
Thank you. (2 Replies)
Discussion started by: jimbojames
2 Replies
3. Shell Programming and Scripting
I have a file1.txt
file1.txt
F-120009210","Felix","U-M-F-F-F-","white","yes","no","U-M-F-F-F-","Bristol","RI","true"
F-120009213","Fluffy","U-F-","white","yes","no","M-F-","Warwick","RI","true"
U-120009217","Lity","U-M-","grey","yes","yes","","Fall River","MA","true"... (4 Replies)
Discussion started by: charles33
4 Replies
4. Shell Programming and Scripting
Hello,
is there a way to use the awk print statement on two files at once? I would like to take two columns from one file, and one column from another file and print them as consecutive columns to a third file. Seems simple...as in:
file 1
1 a
2 b
3 c
4 d
5 e
file 2
1 t
2 u... (3 Replies)
Discussion started by: HugoHuhn
3 Replies
5. Shell Programming and Scripting
Hi,
I am using awk statement to extract data from a file and write a new file with certain columns rearranged and few hard coded values added to new file.
Now i need to add a column with sysdate. can i do that inside the awk print statement?
Now:
nawk ' /^3/ BEGIN {FS=","}... (2 Replies)
Discussion started by: selvankj
2 Replies
6. Shell Programming and Scripting
Hello,
Would someone be able to tell me exactly how this command works please?
awk '!x++'
As usual any help much appreciated (8 Replies)
Discussion started by: Grueben
8 Replies
7. Shell Programming and Scripting
Hello,
I have recently come across this awk program. Can some one shed some light on what is taking place.
awk '{!a++}END{for(i in a) if ( a >10 ) print a,i }' $FILE
Best Regards,
jaysunn (1 Reply)
Discussion started by: jaysunn
1 Replies
8. Shell Programming and Scripting
hi all
can any one help me to understand this
bdf -t vfxs | awk '/\//{printf("%-30s%-10s%-10s%-10s%-5s%-10s\n",$1,$2,$3,$4,$5,$6)}'
i want to understand the numbers %-30S% (4 Replies)
Discussion started by: maxim42
4 Replies
9. Shell Programming and Scripting
Hi all,
I have some code like this
awk -F, '{
if ($1==3)
print $2 > "output_file"
print "1" > "new_file"
}' "input_file"
When I check output_file this has the correct values in it. However the new_file has 1 in it for every line in the input_file. If the input file has 20 lins then... (2 Replies)
Discussion started by: Donkey25
2 Replies
10. Shell Programming and Scripting
Hi,
Could anyone please explain why we have arr=1 - what does this statement do?
awk -F\; 'FNR==NR{arr=1;next};$3 in arr' core.txt gmrd.txt
Any help appreciated (2 Replies)
Discussion started by: penfold
2 Replies