+ Reply to Thread
Results 1 to 2 of 2

How to extract certain records froma csv file

  1. #1
    Registered User
    Join Date
    08-24-2016
    Location
    Buffalo
    MS-Off Ver
    2010
    Posts
    1

    Question How to extract certain records froma csv file

    Hi,
    First I tried posting this earlier today and do not see it, so if it is some how doubled posted I am sorry; I did not know what else AI can do here, but re-post it.
    I have a CSV file where the records are identified by a record ID. I want toe extract only the records that have two of these IDs.
    Example I can have something as follows:
    1... data
    1... data
    1... data
    1... data
    1... data
    2... data
    2... data
    2... data
    3... data
    3... data
    3... data
    4... data
    4... data
    4... data
    5... data
    5... data
    5... data
    6... data
    6... data
    6... data
    6... data

    Now lets say I only want to copy the 1 and 5. keep in mind that the file, that I work with is extremely large and each of these records goes for hundreds of rows.
    How can I find the begging and the end of each record number and just copy all the records for 1 and 5.

    Thank you

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,869

    Re: How to extract certain records froma csv file

    One easy way would be to use the autofilter, and filter for just 1 & 5

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Way to extract records from different sheets
    By isolation123 in forum Excel General
    Replies: 6
    Last Post: 01-30-2015, 09:10 AM
  2. [SOLVED] Extract records with out duplicate
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-19-2014, 08:10 AM
  3. Extract records
    By ScottXe in forum Excel General
    Replies: 5
    Last Post: 01-27-2013, 07:32 PM
  4. Extract Records without Blank
    By ischopra in forum Excel General
    Replies: 2
    Last Post: 06-20-2011, 07:34 AM
  5. extract records from file 1 that do not have a string match in file 2
    By t.o.m in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2007, 01:32 AM
  6. Extract records to another worksheet
    By thart21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2007, 01:33 AM
  7. [SOLVED] draw 999 x 8 random records from file with 8614 records
    By news.wanadoo.nl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2006, 11:10 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1