+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 28

Extracting DATA

  1. #1
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Extracting DATA

    OK so for some reason Walmart.com has no way to export you receipts to a CSV, or anything for that matter, at least not that I'm aware of. I had a sheet that used to clean up my receipts, but I never really understood the formulas, and now it got messed up and I don't know how to fix it. Attached is the sheet I just deleted all the formulas cause I thought I'd start from scratch so I could understand them, but I'm at a loss here, can anyone help? As you could see in the attached sheet the 1st column is the raw data from the receipt copy/pasted from the website, the next 2 columns are the cleaned up DATA, i want to be able to just paste the raw DATA and gave it automatically clean up said DATA so then I could paste it on the second TAB.
    Attached Files Attached Files

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    BE
    MS-Off Ver
    PC: 97 / 2016 (PQ/PP)
    Posts
    5,847

    Re: Extracting DATA

    Maybe easier will be with Data - From Web (paste url of your receipts) - select table to import etc etc...
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  3. #3
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    No offense but I don't want to paste my receipt URL because it contains personal information, I could post a screenshot of the receipt without the personal info, would that help? But all I did was just straight copy/paste directly from the online receipt and pasted it without formatting into the RAW column
    Last edited by AliGW; 01-03-2018 at 11:57 AM. Reason: Unnecessary quotation removed.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    13,360

    Re: Extracting DATA

    Are there always exactly four lines per item?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    BE
    MS-Off Ver
    PC: 97 / 2016 (PQ/PP)
    Posts
    5,847

    Re: Extracting DATA

    I didn't say I want your personal info.
    Simply try it yourself, maybe after import data will be in any "correct order"

  6. #6
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by AliGW View Post
    Are there always exactly four lines per item?
    Well, yes and no, I could make it always 4 lines, it wouldn't really be that much more effort

  7. #7
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by sandy666 View Post
    I didn't say I want your personal info.
    Simply try it yourself, maybe after import data will be in any "correct order"
    I'm not sure what you are trying to say, "Simply try it yourself, maybe after import data will be in any "correct order""

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    13,360

    Re: Extracting DATA

    I'll take that as a 'no', then. The whole idea is that you want a way of dealing with the raw data in one fell swoop. Can you supply sample data that has all possible variants?

  9. #9
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    BE
    MS-Off Ver
    PC: 97 / 2016 (PQ/PP)
    Posts
    5,847

    Re: Extracting DATA

    Just simply try and see what you got.
    If you don't like result - delete file and try another way

  10. #10
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by AliGW View Post
    I'll take that as a 'no', then. The whole idea is that you want a way of dealing with the raw data in one fell swoop. Can you supply sample data that has all possible variants?
    I've attached the same DOC updated with other results
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by sandy666 View Post
    Just simply try and see what you got.
    If you don't like result - delete file and try another way
    You mean import from the source DATA on the site?

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    13,360

    Re: Extracting DATA

    Sorry to seem dim, but where do the dates on the second worksheet come from?

  13. #13
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    BE
    MS-Off Ver
    PC: 97 / 2016 (PQ/PP)
    Posts
    5,847

    Re: Extracting DATA

    I mean import data from the web site
    maybe it will help: Connect to a web page

    try 1 or 2. These are two different ways.

    fromweb.jpg
    Last edited by sandy666; 01-03-2018 at 12:21 PM.

  14. #14
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by AliGW View Post
    Sorry to seem dim, but where do the dates on the second worksheet come from?
    They are the dates from the receipt, I don't mind pasting them in cause it's really just 2 simple steps

  15. #15
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by sandy666 View Post
    I mean import data from the web site
    maybe it will help: Connect to a web page

    try 1 or 2. These are two different ways.

    Attachment 554405
    OH, I see, I'm new to this Power query, I just found out about it a few minutes ago on another forum, thanks I'll give it a try!

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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