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. maxtektips6

    Converting MS Access mdb file

    Hi, Is there any way to convert an MS Access file before doing some processing on a Unix system ? Tried using strings but some information gets lost, particularly dates. Thanks for help
  2. maxtektips6

    Left padding

    Hi, Is there any easy way to do left padding on an unknown length of strings ? examples: 2856 -> 0000002856 12 -> 0000000012
  3. maxtektips6

    Date conversion

    Hi, How do i convert a string like 2007-14-11T11:45:47.0+0100 into a date ? I've tried the follwoing: SQL> select to_date(f1,'yyyy-dd-mmTHH24:MI:SS.S+0100') from mx_tmp; select to_date(f1,'yyyy-dd-mmTHH24:MI:SS.S+0100') from mx_tmp * ERROR at line 1: ORA-01821: date format...
  4. maxtektips6

    Extraction problem with performance in mind

    Hi all, With a routine producing a flow like this header 01 0 X 52 0 G 78 0 T 44 0 B 42 0 Q 70 .. 0 A 77 .. 0 C 48 0 M 67 0 F 12 .. trailer 01 header 02 0 M 24 0 R 45 .. 0 A 45 .. 0 C 36 .. trailer 02 etc. the desired output is like that: 77,42,48 45,,36 etc. It's basically an extraction of...

Part and Inventory Search

Back
Top