Results 1 to 5 of 5

Thread: filtering data

  1. #1
    Member
    Join Date
    Sep 2007
    Location
    Denmark
    Posts
    920
    Thanks
    57
    Thanked 113 Times in 90 Posts

    filtering data

    i have a log file like this

    Code:
    hsT62uQY_EWLu3KaYSrCXT:98787:VTABLE.DAT
    JR6vrxChVpIakLkQUlm@OA:514224:ROM/0/0.DAT
    KpL28h_WHfkEHPbOsZCHV7:3555312:ROM/0/1.DAT
    zERK9AfMa8iHwvXRRuuO8A:1048576:ROM/0/10.DAT
    3m8HU_cz4ukGvmZdbG4@5A:6358160:ROM/0/100.DAT
    Jcxy_6KJ336vVVcpb40siT:13899792:ROM/0/101.DAT
    U7LLxbJxFV2n1b11VVKhpA:11164496:ROM/0/102.DAT
    as you can see it consist of a checksum : filesize : Filepath/filename
    i wish to remove all data that is not the filepath/filename so i should lend up with just a list of filepath/filenames.
    however i cant find any utility that can do this easily for me
    Last edited by SvenBent; 8th May 2013 at 22:11.

  2. #2
    Member
    Join Date
    Sep 2007
    Location
    Denmark
    Posts
    920
    Thanks
    57
    Thanked 113 Times in 90 Posts
    for alternativ suggestion to my work method i can inform that i trying to make a list of files that i need to copy out from a folder/subfolder structure to a backup folder with the same sub folder structure.

    so if any suggestion to do this with this file as the lsit of files i would lappreciate

  3. #3
    Member FatBit's Avatar
    Join Date
    Jan 2012
    Location
    Prague, CZ
    Posts
    190
    Thanks
    0
    Thanked 36 Times in 27 Posts
    Dear SvenBent,

    simple use regular expresion

    Find: [a-zA-Z0-9]{character number in checksum}:[0-9]{5,8}:
    Replace: nothing

    Best regards,

    FatBit

    PS: Numbers 5 and 8 are examples for file size lenght "string"

  4. #4
    Member m^2's Avatar
    Join Date
    Sep 2008
    Location
    Ślůnsk, PL
    Posts
    1,610
    Thanks
    30
    Thanked 65 Times in 47 Posts
    awk?
    Code:
    awk -F: '{print $3 }'

  5. #5
    Member
    Join Date
    Sep 2007
    Location
    Denmark
    Posts
    920
    Thanks
    57
    Thanked 113 Times in 90 Posts
    thank you for the help sadly i figured out the list was a complete list of all files and not just the changed one. so it was useless for me

    i found another and way better way to the entire work processes though

Similar Threads

  1. loseless data compression method for all digital data type
    By rarkyan in forum Random Compression
    Replies: 244
    Last Post: 23rd March 2020, 16:33
  2. ECM filtering makes MMA compresssion worse ?
    By SvenBent in forum Data Compression
    Replies: 8
    Last Post: 25th January 2009, 02:21

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •