Results 1 to 7 of 7

Thread: Need Sample Data For Sorting

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2009
    Location
    Anywhere I want to.
    Posts
    97

    Need Sample Data For Sorting

    Where can I find sample data for sorting.

    At least 20rows.
    At least 4 columns.

    In .csv or tsv format.
    Thank you.

  2. #2
    PowerPoster
    Join Date
    Nov 2017
    Posts
    3,243

    Re: Need Sample Data For Sorting

    You can always write code to generate it yourself in whatever format and type of data you see fit. Or you could try something like ChatGPT.

    Taking your post at face value, no one can really suggest anything specific since you didn't even take the time to explain what type of data you are looking for (numeric, alpha-numeric, etc.)

  3. #3
    PowerPoster cafeenman's Avatar
    Join Date
    Mar 2002
    Location
    Florida
    Posts
    2,657

    Re: Need Sample Data For Sorting

    A great place to get lists is the US Census Bureau. If they collect data on it you can download a list of that thing. I've used it lots of times to generate names for databases while testing development or to show people when the real data is sensitive and I can't just show it to people (like medical info, for example).

  4. #4
    PowerPoster Elroy's Avatar
    Join Date
    Jun 2014
    Location
    Near Nashville TN
    Posts
    10,266

    Re: Need Sample Data For Sorting

    Code:
    Option Explicit
    
    Private Sub Form_Load()
    
        Dim h As Long
        h = FreeFile
        Open App.Path & "\ToSort.csv" For Output As h
        Dim i As Long
        Randomize
        For i = 1 To 20
            Print #h, CStr(CLng(Rnd * 100000)); ","; _
                      CStr(CLng(Rnd * 100000)); ","; _
                      CStr(CLng(Rnd * 100000)); ","; _
                      CStr(CLng(Rnd * 100000))
        Next
        Close h
        
    
    
    End Sub
    Call me grumpy, but isn't this something that a 101 programmer should be able to figure out on their own? I hammered that out in something like 5 minutes, and it ran flawlessly the first time I ran it.
    Any software I post in these forums written by me is provided "AS IS" without warranty of any kind, expressed or implied, and permission is hereby granted, free of charge and without restriction, to any person obtaining a copy. To all, peace and happiness.

  5. #5
    Fanatic Member
    Join Date
    Aug 2011
    Location
    Palm Coast, FL
    Posts
    544

    Re: Need Sample Data For Sorting

    Here's a cool site that you can use to design and create mock data: https://www.mockaroo.com/

  6. #6
    Fanatic Member BenJones's Avatar
    Join Date
    Mar 2010
    Location
    Wales UK
    Posts
    685

    Re: Need Sample Data For Sorting

    here is one site i found to http://www.randat.com/

  7. #7

    Thread Starter
    Lively Member
    Join Date
    Aug 2009
    Location
    Anywhere I want to.
    Posts
    97

    Re: Need Sample Data For Sorting

    That looks very interesting. Thank you.

Posting Permissions

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



Click Here to Expand Forum to Full Width