+ Reply to Thread
Results 1 to 1 of 1

Txt File Data Parsing

  1. #1
    Registered User
    Join Date
    05-11-2020
    Location
    Ohio
    MS-Off Ver
    2016 Suite
    Posts
    1

    Txt File Data Parsing

    Hello all,

    I have a data file that is output into a txt. However when importing the file, all data is placed in a single column. I am trying to separate and group the data together by type so that I can graph each type on a calendar to view the time of each instance. I have attached an example text file and picture of the graph I am attempting to make from this data. I have tried using delimiter functions to try to parse out the data but have not had success. The solution has to be able to be applied over a huge list of data points (>1000 rows in single column) otherwise I could manipulate by hand easily. Let me know if you have any suggestions!

    Thanks!
    Attached Images Attached Images
    Attached Files Attached Files

+ 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. Filter while parsing xml file
    By doctorcpu in forum Excel General
    Replies: 0
    Last Post: 01-07-2017, 02:27 PM
  2. Parsing data from text file to create scatter plot
    By johnmcclure in forum Excel General
    Replies: 3
    Last Post: 01-12-2014, 08:49 PM
  3. Parsing text file
    By handerson0603 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2014, 12:14 PM
  4. Problems parsing data from text file to excel columns
    By combsrj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2013, 08:11 AM
  5. Triple Loop-Parsing data to new file
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2012, 09:59 AM
  6. Parsing data from text file
    By grumps in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2009, 05:59 AM
  7. Parsing the file name
    By Mitch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2006, 03:15 PM

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