Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts

    HELP converting .txt to excel with certain data stripped out and reorganized

    Hey everyone, I don't have the skills to write a macro to do what I need with converting this txt file for use in Excel. I attached a screen shot with highlighted data that I need and the actual txt file itself, all the other stuff in the txt is useless to me. I sure would be grateful if anyone knows how to assist me, thanks!!
    Last edited by spencearini; 2013-09-27 at 11:34.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    With some brute force I moved some of the data could probably do the rest, but this txt file isn't conveniently structured for easily opening with Excel.
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    KWEAVER, Thanks for the look over on this, I need a way to continue to load a few of these .txt's and convert them in the future so I'm looking to learn how to do this or have a macro that will assist. I would still need the following bits of data to come over as well seen in the attached.
    Last edited by spencearini; 2013-09-27 at 11:54.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In these case I would suggest going to the source of the output and request that they rearrange in a more useful fashion for your needs. The coding should be easier from the source data than would be in trying to creating coding after the fact to fix output problems

    Steve

  5. #5
    New Lounger
    Join Date
    Aug 2010
    Location
    New Zealand
    Posts
    13
    Thanks
    11
    Thanked 1 Time in 1 Post
    Could you post your xl files as the jpg are a bit hard to read

  6. #6
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Steve, thanks, but that's not possible at this time and has already been discussed prior to my entering this request for assistance in the forum, I don't want to come off too strong in my feedback to you but if I had the ability to extract this data differently I wouldn't be here now. Thanks.

  7. #7
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks Motivated
    Last edited by spencearini; 2013-09-27 at 11:55.

  8. #8
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Here's the info in a little better form to see:
    Last edited by spencearini; 2013-09-27 at 11:57.

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If you really can't solve the problem and must resort to just working around the real issue, I would suggest at a minimum that you provide an example TEXT file (with at least 2 "sections") [the before] and an excel file of exactly what you want the results of the conversion of the sample file to be [The after]. If you want to provide an excel file of the samples you already provided, that is fine, but I think smaller rpresenative ones woule be sufficient and easier to manually create the excel after files.

    Since the JPGs are difficult to read, I would also suggest that you list in the post, or in the example file, the various requirements. The before file should be representative of any oddities that might creep up in real-life so that those things can be taken care of.

    Steve

  10. #10
    New Lounger
    Join Date
    Aug 2010
    Location
    New Zealand
    Posts
    13
    Thanks
    11
    Thanked 1 Time in 1 Post
    Hi, can you confirm that the only rows you wish to retain are the ones containing "CS". That could be a starting point to delete all the rest of the rows?

  11. #11
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I'm not sure I understand where "CS" is coming from, where are you seeing that?

  12. #12
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks
    Last edited by spencearini; 2013-09-27 at 11:59.

  13. #13
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I will be back to post a file for discussion once I complete some additional stripping with TextPad, thanks.

  14. #14
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Macro .csv/txt to Excel worksheet assistance

    Hello, I need a macro or other method that can take the csv attached (it's actually in a .txt. form Windows secret doesn't allow .csv uploads) and conform it to the layout of the Excel worksheet attached--"Future". Thanks in advance!
    Product 23 - Copy.txt
    Product 23-Future.xlsx

  15. #15
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    What is the logic of the future file? Why is Baker Hill and Orlando not in the data set? Why are there some blank rows in the dataset? How is the code supposed to know these things?

    If the "future file" is wrong and those items are supposed to be there and the blanks are not supposed to be there, you don't need a macro at all. You can imprort the file. Add an autofilter to the Unit column and filter on everything that is NOT "CS". Then delete all those rows, then remove the filter.

    Steve
    PS forgot to mention, then delete the unwanted columns as well
    Last edited by sdckapr; 2013-09-28 at 05:38.

  16. The Following User Says Thank You to sdckapr For This Useful Post:

    spencearini (2013-09-28)

Page 1 of 2 12 LastLast

Posting Permissions

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