10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have the following a.txt file
A|1|2|3|4|5|
A||2|3|0||
A|1|6||8|10|
A|9|2|3|4|1|
A|0|9|3|4|5|
A||2|3|4|5|
A|0|av|.9|4|9|
I use the following command to count null values for 2nd field
awk -F"|" '!$2 { N++; next } END {print N}' a.txt
It should give the result 2, but it is giving... (2 Replies)
Discussion started by: RJG
2 Replies
2. Shell Programming and Scripting
Using awk I am trying to replace all blank or null values with a . in the tad delimited input. I hope the awk is close. Thank you :).
input
name test
sam 1
liz 2
al
1
awk
awk 'BEGIN{FS=OFS="\t"}{for(i=1;++i<NF;)$i=$i?$i:"."}1'input
awk 'BEGIN { FS =... (6 Replies)
Discussion started by: cmccabe
6 Replies
3. Shell Programming and Scripting
Hi All
I had requirement where I need to re-order columns in a file by using a control file.
here is the ctrl file
c1
c2
c3
source file
c3 | c1 | c2
a | b| c
I should create output file based on the ctrl file columns
o/p should look like this
c1 | c2 | c3
b| c|a
I wrote some... (9 Replies)
Discussion started by: gvkumar25
9 Replies
4. Shell Programming and Scripting
I need to develop a script where I will take two date arguments as parameter date1 and date2 which will in format YYYYMM.
Below is the input file say sample.txt.
sample.txt will have certain blocks starting with P1.
Each block will have a value 118,1:TIMESTAMP.
I need to compare the... (7 Replies)
Discussion started by: garvit184
7 Replies
5. Programming
hello all,
in the following code a -> next should print zero, but it is giving the output as 0xbf940000
#include<iostream.h>
#include<conio.h>
#include<stdio.h>
class Node
{
public:
int data;
Node *next;
Node(int n=1)
{
data=10;
next=0;
}
};
void main()... (3 Replies)
Discussion started by: zius_oram
3 Replies
6. Shell Programming and Scripting
I am using below code to validate the source file,code working fine but if any column contains null value then below code throwing error actually it should not.how to customize the below code to handle null null values also.
When I run the script with below source data getting “date error”, as... (2 Replies)
Discussion started by: srivalli
2 Replies
7. Shell Programming and Scripting
I'm filling in a table of values for grades. I decided to go with reading into a hash from the files but I'm coming up with an error when printing a value that does not exist. I need to know if I can on-the-fly print a space (" ") or blank in place of the grade.
Here's what the output should... (2 Replies)
Discussion started by: D2K
2 Replies
8. Shell Programming and Scripting
Hello everyone
I am doing a join command. Obviously, before I need two files sorted first. ( Both files have headers and have about 2 million lines each one )
The problem is, one of the files has null values in the key to sort (which is the first filed ). For example I have the original... (4 Replies)
Discussion started by: viktor1985
4 Replies
9. Shell Programming and Scripting
Hi
I have a file with the values
abc
res
set
kls
lmn
ops
i want to sort this file with the null values at the bottom of the file
OUTPUT should look like this
abc
kls
lmn
ops (6 Replies)
Discussion started by: vickyhere
6 Replies
10. UNIX for Advanced & Expert Users
Hi,
Can someone help me comparing Null values.
Scenario is as follows:
I have a variable which "cache_prd" which can have either some integer or nothing(Null)
if it is integer I have to again do some comparision but these comparisons give me this error:( "line 32: [: 95: unary operator... (3 Replies)
Discussion started by: Yagami
3 Replies