September 7, 2008 03:43pm pdt

1. omarfarid 24,695
2. JustUNIX 18,750
3. tfewster 13,045
4. Tintin 12,283
5. sunnycoder 5,950
6. ozo 4,900
7. JJSmith 4,500
8. ahoffmann 4,000
8. Adam314 4,000
10. robocat 3,900
11. dvz 3,850
12. sjm_ee 3,450
13. sentner 3,000
14. blu 2,855
15. mikelfritz 2,680
16. agriesser 2,400
17. cflong 2,150
18. yuzh 2,000
18. amit_g 2,000
18. joebednarz 2,000
18. evilrix 2,000
18. ac24 2,000
18. sirah 2,000
18. CynepMeH 2,000
18. henjoh09 2,000

1. yuzh 93,545
2. tfewster 76,262
3. omarfarid 34,923
4. chris_cal... 26,089
5. Tintin 25,186
6. ahoffmann 22,192
7. JustUNIX 19,770
8. gheist 17,723
9. amit_g 16,198
10. JJSmith 13,775
11. ozo 13,686
12. sunnycoder 13,244
13. giltjr 8,764
14. Kdo 7,444
15. Panjandrum 5,852
16. dragulj 5,500
16. mass2612 5,500
18. jlevie 5,473
19. sjm_ee 4,450
20. Gns 4,390
21. robocat 4,300
22. Adam314 4,000
23. evilrix 3,996
24. PsiCop 3,944
25. nixfreak 3,900

07.22.2008 at 09:45AM PDT, ID: 23585709

	[x] Attachment Details

Parse text files

Asked by cutie_smily in HP-UX Unix, Unix Systems Programming, Shell Scripting

I have my source text files like below and my requirement is to parse /extract the sql out of this text file and create a new file with same source name (different extension).

I tried to write a simple script using "while read" but couldn't achieve. Any help will be greatly appreciated.

ThanksStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:

           
           
             BEGIN DSRECORD
      Identifier "V0S0P1"
      DateModified "1899-12-30"
      TimeModified "00.00.01"
      OLEType "CCustomOutput"
      Readonly "0"
      Name "lnMember"
      Partner "V0S1"
      Properties "CCustomProperty"
      BEGIN DSSUBRECORD
         Name "SOURCETABLES"
         Value "#TDData#.#Table#"
      END DSSUBRECORD
      BEGIN DSSUBRECORD
         Name "PREFETCH"
         Value "50"
      END DSSUBRECORD
      BEGIN DSSUBRECORD
         Name "WHERE_CLAUSE"
         Value "MEMBER >= '#StartDt#' "
      END DSSUBRECORD
      BEGIN DSSUBRECORD
         Name "OTHER_CLAUSES"
      END DSSUBRECORD
      BEGIN DSSUBRECORD
         Name "USERSQL"
         Value =+=+=+=
SELECT
  M.col1,
  M.col2,
  M.col3
 
FROM #TData#.#Member#  M
 
INNER JOIN #TData#.#TableCntct# G
  ON G.GRP_NBR = M.GRpNO
  AND G.DIVNBR = M.DIVNO
 
ORDER BY 1,2
=+=+=+=
      END DSSUBRECORD
      BEGIN DSSUBRECORD
         Name "BEFORESQL"
      END DSSUBRECORD
      BEGIN DSSUBRECORD
         Name "CONTBEFORESQL"
         Value "YES"
      END DSSUBRECORD
           
         

Keywords: Parse text files

	Title
1	Par files
2	Par. Query
3	PAR utility for newbie
4	PAR Protocol
5	par file
6	What does the /par in a .bat file mean?

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Parse text files

Asked by cutie_smily in HP-UX Unix, Unix Systems Programming, Shell Scripting

About this solution