Results 1 to 13 of 13
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Copying selected records

    I have a spreadsheet that contains one field. Unfortuneately, is was designed this way, so I'm stuck with what I have. In the field are records (sections) that look like this, and each is followed by an empty row:

    RECORD: 3
    hash_sha1: 00DB857B79857FB5DCD7FCA3EE891A529E3F1DC3
    title: my file
    artist:
    album:
    category:
    language:
    year:
    comment:
    url:
    filedate: 6/14/2012 3:48:55 AM
    shared: TRUE
    corrupt: FALSE


    Is there an easy way to to copy out every record that begins with hash_sha1: so I can paste those records in another field? I can do a "find all," but I don't think that I can copy out the records from that operation. Thanks.
    JimmyW
    Helena, MT

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Jimmy,

    When you say one field do you mean a single column, i.e. all that you have above would be in a single cell e.g. A1 ?

    If so would you like it to separate the values into different columns when you copy the records?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thanks, partner. Yes, everything is in A1-A19097. I'd just like a column that contains the hash_sha1: 00DB857B79857FB5DCD7FCA3EE891A529E3F1DC3 record, and there are about 1,300 of them.
    JimmyW
    Helena, MT

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Jimmy,

    Could you possibly upload a spreadsheet with say a hundred records for testing purposes?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Do you mean you want to extract the 2nd row, then the 16th, etc.?

  6. #6
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    I want to extract every cell that contains hash_sha1: 00DB857B79857FB5DCD7FCA3EE891A529E3F1DC3. The data in the those cells vary, except they all start with hash_sha1: I attached a sample spreadsheet.
    Attached Files Attached Files
    JimmyW
    Helena, MT

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Is this what you're looking for or do you want all of the related lines for each hash_sha1 pulled out also?
    Attached Files Attached Files

  8. #8
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Yes, that is perfect! I don't need the other lines. Thanks!
    JimmyW
    Helena, MT

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    See the attached (again) with a new tab
    Attached Files Attached Files

  10. #10
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Duh!

    I was off programming while you solved it! I thought he wanted all the lines if the hash tag matched the one posted.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  11. #11
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thanks again! I think i got it.
    JimmyW
    Helena, MT

  12. #12
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Hey, RG...I thought that initially, then he indicated he just wanted the main indicators.

  13. #13
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Another option might be to have a sheet with column A:

    2
    =14+A1

    and fill down.

    Then, in column B: =INDIRECT("Original!A"&A1) and fill down.

    This assumes each "hash" section has 14 lines and the hash codes are in the 2nd line of each block.

Posting Permissions

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