problem with awk command

Shell Programming and Scripting
1

I am having problem running an awk commad on a file
Before applying awk command on the file

After applying

I don't expect more than 409743 records in the file. Why do I have 1 record more after applying awk command?

Please let me know

2

Hi.

Perhaps your file is missing a new line on the last line?

$ echo Hello > file1
$ printf World >> file1
$ cat file1
Hello
World$ wc -l file1
       1 file1
$ awk 1 file1 | wc -l
       2

edit: changed "original input file" to "file", it was confusing

3

Scottn,

I didn't really get it. what do you mean by original file missing new line?:confused:

4

I think that the line terminator (<lf>) is missing from the last record of your input file.

$ printf "1111\n2222\n3333" >a.a
$ wc -l a.a
       2 a.a
$ cat a.a
1111
2222
3333$

Jean-Pierre.

5

Aigles

I am doing only the below commands

How can I make sure I have same number of record count after using awk command?

---------- Post updated at 11:05 AM ---------- Previous update was at 10:41 AM ----------

can somebody let me know how to fix the line terminator problem?

---------- Post updated at 11:09 AM ---------- Previous update was at 11:05 AM ----------

I got it

awk 1 eport.csv | wc -l
409745

Thanks