Results 1 to 3 of 3
  1. #1
    bom is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    1

    Unorganized text data into table

    Hello,

    I have crazy unorganized data that I need to convert into tables for report. I will attach an example of my data here. I tried both Excel (removing blanks and query) and access but I had no luck this far. I am pretty sure that Access would be the best course of action here I just don't really know how to do it. Can someone please, help me to solve this one? By far the hardest MS related issue/challenge I've ever encountered. Thank you in advance! Below is the crazy data.

    ý
    #
    DATE: 11/04/19 1
    TIME: 7:19 pm TICKET REPORT
    TICKET SHIP TO/FR TIC SHIPMENT ENTRY STOR VEHICLE
    GROSS TARE NET
    NUMBER NAME ID LOC DATE DATE CM/VARIE BIN ID
    BILL/LADING# ORGDST WEIGHT WEIGHT WEIGHT
    ------------------------------------------------------------------------------------
    ------------------------------------------------
    AP AP APPLY APPLY APPLY SHEET STLMNT STLMNT GROSS NET DOLLAR TICKET
    No TY DESCRIPTION REFERENCE NAME ID No. No. DATE QUANTITY QUANTITY PRICE DISCOUNT TOTAL
    ------------------------------------------------------------------------------------
    ------------------------------------------------
    C470189 0001000065 IR 010 11/04/19 11/04/19 CN0003 Z042 CENTURY T 0001000065 85580 26360 59220
    GRADES: 54.90 TW 13.90 MO 5.10 DM 1.90 FM
    01 B BASIS 0032450-02 0001000065
    1057.50 1057.50 3.90000 19.08 4,105.17
    $$: 10.58 DM 8.50 IF
    .....INBOUND/OUTBOUND:.I..YELLOW.CORN..CENTURY.ACRES.INC....... .....................
    ................................................
    1 0001000065 I
    85580
    26360 CN
    59220
    GRADES: 54.90 TW


    B BASIS
    13.90 MO 5.10 DM 1.90 FM
    1057.50 1057.50 3.90000
    $$: 10.58 DM
    19.08
    8.50 IF
    4,105.17
    -----INBOUND/OUTBOUND:-I--YELLOW-CORN-----------------------------------------------
    ------------------------------------------------
    1 I CN
    85580 26360 59220
    GRADES: 54.90 TW 13.90 MO 5.10 DM 1.90 FM B BASIS

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Couldn't make much sense of this due to formatting. Suggest you create a nice looking format in WORD, than attach that as a file, or take a screenshot of the WORD document and insert that as an image.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by bom View Post
    I have crazy unorganized data that I need to convert into tables for report.
    We need more info.

    Is the "crazy" data in a text file, CSV, or ???
    What do you want to do with the data?
    What data do you want to convert into tables?

    It is possible to parse a file line by line to grab the data if the data will be in the same place every time (in the file). But you need to be explicit about that data and what the table design will be.


    I did copy the example on the screen and past it into a text file (NotePad) so it doesn't look as bad as displayed in the post, but I'm not sure if the formatting is correct...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-24-2018, 09:23 AM
  2. Replies: 14
    Last Post: 01-12-2012, 05:03 PM
  3. Getting text box data into a query/table
    By kman42 in forum Access
    Replies: 1
    Last Post: 04-01-2011, 01:09 PM
  4. HELP! how to send data from table to text file
    By daveofgv in forum Import/Export Data
    Replies: 11
    Last Post: 02-14-2011, 01:22 AM
  5. Replies: 2
    Last Post: 04-29-2009, 11:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums