AWK Script: Testing for Null values 1

[cgordon]

Hi,

I have an AWK script that worked until the data format changed. The 14th & 15th spaces are named RSV. This used to be only one space (until recently). Based on the value in RSV, I will print to a file in using PrintA or PrintB (different formats).

1545016908374 AVL111111
1545011234567M AVL111111

I was using

if (rsv!=" &quot
print..... (Use PrintA)
else
print..... (Use PrintB)

When the 15th position did not exist, this worked. Now RSV is two characters/digits. How do I test for a null value??

Thank you

 

[CaKiwi]

What happens if you simply add an extra blank to your test?

if (rsv!=" &quot
print..... (Use PrintA)
else
print..... (Use PrintB)

If this doesn't solve your problem, post again to tell us exactly what is in rsv when you want to use printa and when you want to use printb. Also, maybe you need to tell us exactly how rsv is set from the input line.
CaKiwi

 

[cgordon]

This is part of an AWK script called from a batch file.

grep AVL filename | awk -f ntnirpt.a

In ntnirpt.a, the first few lines describe the format.

rsv = substr($0,14,2)
.. then a series of counters, based on the RSV indicator. A = A+1, B = B+1, ...

Then a print statement.

I tried to just add an extra space, but then it treated every entry as if there was data there.
1234( ) 2222(M ) 3333( ) 4444(N )

Output should be (sample):
1234 2222(M ) 3333 4444(N )

The desired result is where the lack of a RSV means that no () are included and any indicator would be included in the (). The resulting file is then read into Excel, where more macros look for consecutive numbers without ().


My printf statements are:

if(rsv!=" &quot
printf(",%s(%s)",stn,rsv) > "tni"mkt".csv"
else
printf(",\"=text(%s,\"\"0000\"\&quot\"",stn) > "tni"mkt".csv"

mkt is defined as the first three characters of the dataline.
stn is defined as the 10-13 digits of the dataline.

Thank you

 

[CaKiwi]

I don't understand why the test rsv!=" " isn't working. How about trying

if (substr(rsv,1,1)!=" " || substr(rsv,2,1)!=" &quot

if this doesn't work, add a debug print statement before the test e.g.

print "- " length(rsv) " - " substr(rsv,1,1) " - " substr(rsv,2,1) " -"

CaKiwi