August 21, 2008 06:00pm pdt

1. ozo 93,425
2. Tintin 83,992
3. omarfarid 73,129
4. hernst42 17,800
5. ahoffmann 16,700
6. ghostdog74 13,171
7. Shift-3 13,000
7. BSonPosh 13,000
9. Adam314 12,930
10. sentner 12,800
11. RobSamp... 12,475
12. MikeOM_... 10,200
13. sirbounty 9,775
14. sunnycoder 8,900
15. sungenw... 7,600
16. amit_g 7,500
17. JustUNIX 7,185
18. hielo 7,000
19. blu 6,730
20. merowinger 6,200
21. mikelfritz 5,500
22. ravenpl 5,100
23. oBdA 5,000
24. fridom 4,498
25. agriesser 4,032

1. ozo 150,963
2. Tintin 137,778
3. omarfarid 95,372
4. ahoffmann 43,471
5. amit_g 39,900
6. hernst42 32,500
7. RobSamp... 31,650
8. sirbounty 21,375
9. Shift-3 20,600
10. BSonPosh 19,350
11. Adam314 18,665
12. ghostdog74 16,781
13. ravenpl 14,200
14. sentner 12,800
15. SteveGTR 11,550
16. MikeOM_... 10,200
17. sunnycoder 9,300
18. duncan_roe 8,441
19. oBdA 7,800
19. nixfreak 7,800
21. sungenw... 7,600
22. JustUNIX 7,185
23. hielo 7,000
24. blu 6,730
25. evilrix 6,375

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