December 4, 2008 08:48am pst

1. omarfarid 97,978
2. ozo 53,575
3. Tintin 36,408
4. sunnycoder 21,132
5. JustUNIX 20,884
6. yuzh 14,400
7. ravenpl 13,100
8. ahoffmann 12,252
9. jkr 10,960
10. duncan_roe 9,900
11. gheist 9,558
12. ghostdog74 8,295
13. woolmilkp... 8,000
14. Adam314 6,200
15. fridom 5,950
16. mikelfritz 5,700
17. amit_g 5,500
18. arnold 5,250
19. tfewster 4,700
20. sdstuber 4,100
21. evilrix 3,700
22. Infinity08 3,580
23. Kdo 3,259
24. blu 3,000
25. stefan73 2,800
25. sujith80 2,800

1. ozo 409,738
2. ahoffmann 391,215
3. Tintin 326,473
4. yuzh 244,280
5. amit_g 208,559
6. jkr 134,099
7. omarfarid 120,628
8. HamdyHa... 117,159
9. tfewster 110,057
10. ravenpl 99,554
11. MikeOM_... 92,456
12. sunnycoder 91,611
13. manav_m... 84,416
14. brettmjohn... 65,593
15. chris_cal... 51,019
16. cjjclifford 47,249
17. glassd 38,369
18. stefan73 28,573
19. JustUNIX 28,236
20. NovaDeni... 25,901
21. duncan_roe 24,950
22. dhm 24,510
23. nixfreak 23,948
24. gripe 23,382
25. fridom 23,024

07.31.2008 at 02:04PM PDT, ID: 23612474 | Points: 50

	[x] Attachment Details

AWK PARSING

Asked by vihar123 in Linux Programming, Unix Systems Programming, Perl Programming Language

Tags: UNIX

Hi
I have a pipe delimited file, I want to check if the length of the fourth field is >2. In that case fourth field is replaced with empty Otherwise the line is printed as it is.

eg: As below

If length(F4)>2 then the output should be
F1 | F2 | F3 || F5 ......
else
F1 | F2 | F3 | F4 | F5 ......

I am using the code as below. But it is giving a syntax error. What shall I change with in

awk -F'|' 'BEGIN {OFS="|"} {if (length($4)>2) $4="" else $4=$4; print $0}' data_fileStart Free Trial

         
             awk -F'|' 'BEGIN {OFS="|"} {if (length($4)>2) $4="" else $4=$4; print $0}' data_file

Keywords: AWK PARSING

	Title
1	awk script, get numbers from inside ()
2	Count fields within a field using AWK
3	How do I calculate the filesize of myfile…
4	Can someone convert this AWK script …
5	Error in awk script: not enough argum…
6	Unix, awk

Loading Advertisement...

20081112-EE-VQP-43 / EE_QW_2_20070628