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: joeroe3380
  • Content: Threads
  • Order by date
  1. joeroe3380

    print and append!!

    HI group, im trying to do the following: print a statement "im learning unix" append the contents of a file print another line at the end. ---all into one single file. expected output: im learing unix --- contents from a file-------- 1 2 3 4 ------conetnts from the line ends-- lastline " >...
  2. joeroe3380

    Appending trailing commas!

    HI gurus! I have a input file as follows: nvl(BIN_NBR, ' ') , ACTN_CD , nvl(NBR, ' ') , DC_ACTN_CD , SORT_ID ...
  3. joeroe3380

    substitution error

    I have the following numerous line in input file: nvl(MP_MID_INIT_TXT, ' ') || 'M-G' || lpad(nvl(MP_SEQ_IMS_ID, 0), 3, 0) || lpad(nvl(MP_IMS_ID, 0), 7, 0) || 'M-G' || from which i need to delete the || 'M-G' || and ||...
  4. joeroe3380

    SED ERROR

    i have the sed statement to change to_char(BASE_DT, 'YYDDD')to to_char(CYC_DT, 'YYDDD')BASE_DT. The sed that i have is : sed 's/to_char\(BASE_DT, \'YYDDD\'\)/to_char\(CYC_DT, \'YYDDD\'\) BASE_DT/g' outdat.sql > osql.sql However this gives an error. Please advice on the right syntax. Thanks a...
  5. joeroe3380

    SED script - modification

    Futurlet, Thanks alot for the superb script. Though the above awk does most of the tasks required, it however doesnt change the occurance of B. to " " as required. Also i need to replace the occurance of '(B.In_DT,'YYDD')' to '(OT_DT,'YYDDD')In_DT'. Please advice on modifying the awk for the...
  6. joeroe3380

    SED script

    Hi group, i was trying to accomplish the following; read file1 untill the line "B_comb" is encountered and not including the phrase "B_comb".(say line 181 has sql_seq_num B_comb; B_comb should be removed while reading all the lines upto "B_comb" and retainig 'sql_seq_num' but removing...
  7. joeroe3380

    SED statement

    Hi group, ( sed '$d' infile1 ; sed '1d'infile2 ; sed -n '$p'infile2) > outfile.dat I tried the above script to concatenate 2 files stripping the last line of first file, appending the second file after stripping the first line of second line. In the process as the last line of the second file...
  8. joeroe3380

    concat two files

    Hi Group, I need to concatenate two files; read in the first file to a new file delete the last line from the new file. append the second file to this new file stripped of last line from the first file. I tried working arround with two cat command and tail-n1 /dev/null 2>&1 to strip off the...
  9. joeroe3380

    Help in AWK statement Extract and condition

    i have in directories /prod/test/data*(01-24)/testr -rw-rw-rw- 1 1976 Nov 25 00:41 20030117estats.001 -rw-r--r-- 1 32768 Nov 26 11:43 b2030411nlod.001 -rw-r--r-- 1 8192 Nov 26 11:43 a2030411nlod.001 -rw-r--r-- 1 8192 Nov 26 11:43 b1030411nlod.001...
  10. joeroe3380

    permission denied error

    Hi i have a script as below .when i excecute the script it gives an erroe of permission denied in making directory. i have chmod to 777. set -vx export X=$@ export JOB_NAME="${JOB_NAME}" . /usr/local/bin/abi_global_setup uda # Generated under GUI v1.12.5.2 # set -- $X set -...
  11. joeroe3380

    ERROR in basic script format!!

    HI Gurus!! I have written thie basic script.. awk '{for(i=0;i<=NR;i++) count=i}'< ${fileip} # count no of lines in fileip# export env count echo $count case ${findsp} in "r") export env sp="6" ;; "m") export env sp="2" ;; "l") export env sp="2" ;; *) print "\n\n Warning - ASSIGNMENT...
  12. joeroe3380

    format error in AWK script!!

    HI group !! i was executing this awk script ..but it throws an error..which im not able to figure ..plzz advice me on how to go about this error $ awk '{for(i<=$3;i<=$4;++i) printf("%04d\t%s%s\t%s\n",i,$1,$2,$5)}'/in.parms > /out.dat syntax error The source line is 1. The error context is...
  13. joeroe3380

    ERROR:: &quot;literal does not match format string&quot;

    Hi group , im trying to extract table from oracle table using select .. but i encounter the following error... SQL> SELECT * FROM TABLE_RPT WHERE CYC_DT = '20030303' AND ROWNUM<10; SELECT * FROM TABLE_RPT WHERE CYC_DT = '20030303' AND ROWNUM<10 *...
  14. joeroe3380

    exporting variable from a file

    HI group, I have an output file with a single row and 24 fields seperated by spaces as shoen below: 000 156 317 441 605 800 156 316 441 605 800 999 00009 15659 31709 44119 60519 80029 15649 31699 44109 60509 80019 99999 i want to export (as an environment variable), each of the column, to be...
  15. joeroe3380

    date format manipulation error

    HI, I want to extarct a date field from the table and transform into a different date format("yyddd")..say if the input date is 20010201..outut date format should be 01032. i have tried with following queries but have encountered the following errors.. sql>describe tabledate DATA_DATE...

Part and Inventory Search

Back
Top