Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: zanzemaj
  • Content: Threads
  • Order by date
  1. zanzemaj

    Transform contents of text file

    Hi, I need help in transforming a text file. Here is an example of file1.txt: pos1 TABLE ah_feed 3828 48 pos1 TABLE ah_feed 7402 103 po1 VWW ah_feed 1234 123 po1 VWW ah_feed 1234 123 pos2 TABLE DEPT_XREF 6365942 181866 pos2 TABLE DEPT_XREF 12758867 364521 pos2 VWW dep_f 122 2 pos2 TABLE...
  2. zanzemaj

    Hoe to check values in a file

    I am using a ksh script. Please help me read and get values from this file called stat.txt: Job information for Job ID '465' using a Traditional view Job "PD1002_predefined" - 2007-06-21 20:32:18 (ID 465) Operation: ARCHIVE TDPID: 1 Streams: 3 Stream Client...
  3. zanzemaj

    Delete data or lines in a file

    I have a file stream.txt and I need to disregard the lines STREAM TOTALS and lines after that. But I want to include all lines with ARCHIVING DATABASE and lines after that. 06/15/2007 22:18:51 ARCHIVING DATABASE "BACKUP_CONTROL_DEV" 06/15/2007 22:18:53 TABLE "ARCHIVE_DB" - 438 BYTES, 0 ROWS...
  4. zanzemaj

    Join 2 lines

    I have a textfile named table1.txt and I want to write the records in one line. If the next line do not have any date before the line or there is a blank, this line should be paste on the first line. I would appreciate any help in solving this problem. I tried to do this, but not working tr -s...
  5. zanzemaj

    How to read and manipulate file?

    I have a textfile named tmp.txt which contains the following record: 06/13/2007 23:05:23 ARCHIVING DATABASE "table1" 06/13/2007 23:05:28 "table1" - LOCK RELEASED 06/13/2007 23:05:28 06/13/2007 23:05:28 ARCHIVING DATABASE "arctab3" 06/13/2007 23:05:30 TABLE "ARCHIVE_DB" - 438 BYTES, 0 ROWS...
  6. zanzemaj

    How to remove words in a textfile

    I have a text file named tmp4.txt with sample records: MISC_INT 05/30/2007 12:14:20 TABLE xx_httj 4,150 BYTES, 63 ROWS ARCHIVED FOR THIS STORE_INT 05/30/2007 12:14:22 VIEW fret_xxfe 6,392,925 BYTES, 182,655 ROWS STORE_INT 05/30/2007 12:14:25 TABLE bkup_x 4,756,990 BYTES, 135,914 ROWS...
  7. zanzemaj

    How to compare date and time in IF statement

    Hi, I need to compare the date and time in a ksh script. The date and time are contained in variables. My code generates errors which I dont know how to solve, please help. Here is sample file named TmpFile 45e backup 2007-05-29 02:07:32 2 46e backup...
  8. zanzemaj

    How to read records and values in a file?

    I need help on a script I'm doing. I need to read a textfile named fexit.txt with sample records: job excode 1 0 2 8 3 0 4 12 obj typ sze temp tab 8,854,555 test tab 12,222,840,111 I need to check if all excode is equal to 0. If not all excode is...
  9. zanzemaj

    How to replace a comma to a semicolon in a textfile?

    Hi, I'm a UNIX scripting beginner and need some help. I now have a textfile wherein the contents come from SQL query. The number of lines will be dynamic. Here is a sample contents of the textfile named temp1.txt: (int.sars), (int.prev), (int.batchg), PROCESS DATA TABLES (int.keelj), (int), I...
  10. zanzemaj

    Performance problem on Teradata SQL query

    If anyone could assist me in making this query run any faster, I would really appreciate it. Any comments or recommendations? I'm new to Teradata and been using Oracle for 8 years. Here is Explanation 1) First, we lock a distinct stage_dev."pseudo table" for read on a RowHash to prevent global...

Part and Inventory Search

Back
Top