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 Chriss Miller 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: *

  1. dstxaix

    VB Task Scheduler

    Plan on writing a console application instead of event driven form. The console application can be scheduled to run on windows task scheduler
  2. dstxaix

    nhibernate error - The type initializer for 'NHibernate.Cfg.Configuration' threw an exception.

    I am trying my first vb.net + nhibernate + mysql project using vb 2010 express on windows 8 I am getting below error in my log file 2013-05-15 11:00:27,312 [8] INFO - [Log4NetAssembly1] Form1_Load() - Start 2013-05-15 11:00:27,402 [8] ERROR - [Log4NetAssembly1] Form1_Load() - The...
  3. dstxaix

    EXTERNAL tables Oracle 11G

    Hello All I have been asked to load data in oracle table using External Tables "approach" instead fof SQL Loader utility. I have been told External tables will be faster and I should not use SQL Loader for this work. Do the data file and the script loading the data into Oracle 11 G need to...
  4. dstxaix

    need some quick scripting help

    proggybilly, Here at tek-tips we thank by awarding STARS.
  5. dstxaix

    Programmatically load CSV file into oracle table using VB.Net

    You could use ADO.NET with VB.NET
  6. dstxaix

    How to find out if the FTP file is finished loading in unix

    One of the things we always recommend our customers is to FTP the large files with a temporary name and then rename upon completion.
  7. dstxaix

    Sort fullname by lastname

    Don't people have middle initials like John M. Doe
  8. dstxaix

    Batch nae change name

    Is this what you are looking for? mv *parts.* *score.* mv *parts-1.* *violin.* mv *parts-2.* *flute.* mv *parts-3.* *oboe.* mv *parts-4.* *clarinet.* mv *parts-5.* *debug.*
  9. dstxaix

    SUBSTR/INSTR Help.

    If REC_SUPPLIER will only contain number and * and then just words or spaces then you could try the following select TRANSLATE(rec_supplier, '*0123456789', ' ') as tidyname I am sure some of the gurus here may have a better solution
  10. dstxaix

    Oracle create function and return ref_cursor

    Maybe someone at the VB.NET forum can give you some pointers?
  11. dstxaix

    Korn shell script question

    I am assuming the values will be in sorted order. Else, sort the file in ascending order and lets call it mylogfile.txt. Then you can write a sequence generator as given below and generate a file of sequences and call it seqs.txt. #!/bin/ksh awk -v START=$1 -v FINISH=$2 'BEGIN { for...
  12. dstxaix

    Expect question

    I got an expect script as below. I dont remember the poster. See how using set and [lindex] you can pass parameters. Is this what you were looking for? #! /usr/bin/expect spawn passwd [lindex $argv 0] set password [lindex $argv 1] set npasswor [lindex $argv 2] expect "password:" send...
  13. dstxaix

    Filename

    For the first file, I believe your ETL tool was run under a different ID and it did not give read or execute permission to your ID or group. In teh second case, you created teh file, so obviously you can do anything with it. You can send the ls -l output for that filename and some of teh...
  14. dstxaix

    newbie question about OracleExpress

    Mufasa - Your post shows very clearly that you are a good "teacher" (or instructor).
  15. dstxaix

    Extracting daa from XML file

    I know you asked in Awk forum, but this uses all UNIX utilities :) tr ">" "\n" < input|grep -v '^<'|cut -d"<" -f1|paste - - and it gives the output you need:)
  16. dstxaix

    Awk, sed and grep unable to handle special character in a file

    Hi, I have a file with many records of the same length. One type of record contains some special characters. I get it from another system. When I try to remove some unwanted records from the file, I am facing a problem. The problem is, that AWK thinks the special character is teh end of teh...
    • dstxaix
    • Thread
    • Replies: 1
    • Forum: AWK
  17. dstxaix

    parse file AND parse column with diff delimiter

    Albert Assuming your filename is list1 this should work for your example cat list1 | tr "/" "|" | awk -F"|" '{print $1"|"$8}'
  18. dstxaix

    Need Scripting Help

    Hi, Here is a solution using cut, sed, and grep mv user_list user_list.bak cut -f 2 -d, Edit_new | sed 's/CN=/^/g' > memonly grep -f memonly user_list.bak > user_list rm memonly rm user_list.bak Tested on AIX 5.3 using ksh
  19. dstxaix

    PIVOT query

    I understand this question is asked in Oracle forum. But, I thought I will anyway suggest that data formatting be done before loading into a database. An awk/Perl script or a C or Java program or VB.NET (depending on operating system) can do the transformation.
  20. dstxaix

    AIX 5.3: need help removing zeroes using sed or any other method

    Anni This is perfect. It works for me. Have a STAR

Part and Inventory Search

Back
Top