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 Rhinorhino 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

    Thanks Annihilannic, it looks like this could the thing. Meanwhile i've managed to convince the source of the file to opt for another format.
  2. maxtektips6

    Converting MS Access mdb file

    Avoiding using windows alltogether is the goal (sounds familiar?). The idea is to have a script on the unix machine to download the mdb file from the internet then process it. Currently the preliminary export to txt on windows is an overhead and requires a manual intervention.
  3. 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
  4. maxtektips6

    Left padding

    nice one
  5. maxtektips6

    Left padding

    Thanks PHV. This seems to work: awk '{ printf "%010d\n",$1}'
  6. maxtektips6

    Left padding

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

    Extraction problem with performance in mind

    In order to compare the different solutions i've been using a big file which is not in the average. It has 39,359,150 lines (1.1G / 1132930175 bytes). Using a smaller test file may not have provided a clear cut answer about the performance.
  8. maxtektips6

    Date conversion

    Yep you're entirely correct, there is no conversion at all taking place. It's definitely not the best solution but it'll do until i can get my hand on some proper documentation. Cheers
  9. maxtektips6

    Date conversion

    I wish i could do anything about the data types. It's just given, can't change it. This format is indeed providing dates with a precision to the tenth of second and the time is UTC. What comes after the + sign is the offset from GMT. And "substr" is not available .. a pain to have such limited...
  10. maxtektips6

    Date conversion

    Thanks Hoinz. Your suggestion runs indeed fine in Oracle but doesn't in the timesten table: Yes the T is always there. Unfortunately what comes after the "." changes so apart from the T and the punctuation everything else is variable in that column. Command> select...
  11. maxtektips6

    Date conversion

    Forgot to add: i can't use substr to just take the date - as i don't actually need the time part that comes after the "T" character-; that's because this has to run in a timesten database which has limited oracle functionalities.
  12. 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...
  13. maxtektips6

    Extraction problem with performance in mind

    The results are nearly equivalent (yes it's solaris). Here's how a record really is if you'd like to give it a try. A would be "calling_number", B "dialled_number" and C "EL_ANM_TIMEPOINT_RECEIVED" RECORD #input_id 1202842387x001_23 #output_id #input_type end_of_call_cdb #output_type B2B_CDR...
  14. maxtektips6

    Extraction problem with performance in mind

    Guess it must be the amount of data to filter out that makes the difference. The results above are obtained with "real" data, containing lots of unwanted rows. I've run tests similar to yours (test file obtained by concatenating the first record until over 1M lines are reached), here are the...
  15. maxtektips6

    Extraction problem with performance in mind

    It still takes approximately 5 mins
  16. maxtektips6

    Extraction problem with performance in mind

    Hi, The input to be filtered out can be considered as a stream. Well, in reality the routine produces files which have over 1M lines in average. And there's always lots of them (100 000's at a time). The benchmarking with a single file gives the following: grep+paste -> 30 sec. awk regexp ->...
  17. 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