November 19, 2008 02:20am pst

1. duncan_roe 97,120
2. Tintin 74,364
3. omarfarid 66,334
4. ravenpl 61,725
5. ozo 41,202
6. sunnycoder 24,238
7. shakoush... 16,974
8. evilrix 16,080
9. Nopius 15,350
10. jkr 15,100
11. Adam314 12,600
12. Infinity08 12,226
13. ghostdog74 11,015
14. ahoffmann 9,810
15. amit_g 9,332
16. hernst42 8,700
17. wilhelm_... 6,995
18. agriesser 6,986
19. zmo 6,900
20. nognew 6,164
21. fridom 6,000
22. Tomun 5,500
23. grblades 5,000
24. sanjooz 4,800
25. PeturIngiE... 4,672

1. duncan_roe 309,051
2. sunnycoder 288,724
3. ozo 237,199
4. ravenpl 235,481
5. Tintin 190,514
6. ahoffmann 178,275
7. amit_g 124,957
8. omarfarid 75,702
9. jlevie 73,597
10. Nopius 71,070
11. brettmjohn... 63,339
12. fridom 62,065
13. slyong 57,785
14. manish_r... 56,260
15. khkremer 55,145
16. yuzh 52,673
17. bryanh 52,272
18. wesly_c... 49,519
19. Infinity08 42,176
20. jkr 38,900
21. NovaDeni... 38,345
22. garboua 37,573
23. noci 37,177
24. MikeOM_... 37,036
25. stefan73 34,952

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...

20080716-EE-VQP-32 / EE_QW_2_20070628