+ Reply to Thread
Results 1 to 2 of 2

Importing Text without Delimiters.

  1. #1
    Registered User
    Join Date
    01-17-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    1

    Importing Text without Delimiters.

    I receive a text file each day that has no delimiters separating the records. As far as I can tell, though, each record ends with "CURRENT TIME ##:##:##"


    What I would like to do is import this text file into Excel each day and separate the records into rows and columns. I have tried using text to columns, but it
    does not work that well because there are no delimiters, so I end up having to try to line up the columns manually. If I could just get the
    file into Excel with one record per row and the data in columns, that would save so much time for me. Any idea as to how I can do that?


    I have attached a sample of what the file looks like. Any help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Importing Text without Delimiters.

    Hi yeppy12 and welcome to the forum.

    I have tried using text to columns, but it
    does not work that well because there are no delimiters, so I end up having to try to line up the columns manually.
    Could you do just those 3 records manually from the above *.txt file and upload the Excel file to show us what you want the result(s) to look like?
    Dave

+ 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. Replies: 1
    Last Post: 10-29-2016, 01:26 PM
  2. Replies: 2
    Last Post: 04-09-2014, 11:48 AM
  3. VBA splitting Text with Delimiters?
    By Irish RayRay in forum Excel General
    Replies: 6
    Last Post: 03-14-2012, 12:54 PM
  4. Importing CSV with delimiters causes "Unparsable Record" error
    By cswale in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2011, 08:39 PM
  5. Text to columns with no delimiters
    By angies in forum Excel General
    Replies: 11
    Last Post: 08-15-2011, 08:24 AM
  6. Text to Column delimiters
    By sapling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-20-2010, 04:48 PM
  7. Importing text file with no line delimiters
    By mikewilsonuk in forum Excel General
    Replies: 4
    Last Post: 06-15-2006, 01:47 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