6 {{ upvoteCount | shortNum }}
6 {{ upvoteCount | shortNum }}

Extract User names from Text File

by mike2468
5 replies
Is it possible to extract usernames from a text file and save in csv format or another text file? The text leading up to the file name is standard so there must be some way.

Example:"from":{"username":"USERNAMEHERE","profile _picture":"https:\/\/igc

I have pages and pages of this code so I'd like to avoid doing this by hand.
#extract #file #names #text #user
  • Profile picture of the author JosephI
    I'm sure you can do it in Notepad++
    Its very versatile and has a lot of pluigns available.
    I've used it to do similar many times.
    Excel will also work if you're a wiz with it.
    Fiverrr may be your solution.
    Cheers
    {{ DiscussionBoard.errors[9823350].message }}
  • Profile picture of the author mike2468
    Josephl- can you go into more detail how I would go about this?
    {{ DiscussionBoard.errors[9828594].message }}
    • Profile picture of the author JosephI
      Originally Posted by mike2468 View Post

      Josephl- can you go into more detail how I would go about this?
      A lot depends on the structure of your file. Easy if all your entries are the same structure for each line.
      My approach has been to use the commands from the programs to remove all unwanted till you're left with the desired results and convert it/save it to csv.
      Need to be a little creative and have some knowledge in using both those programs together.

      I'm not a wiz at it but I've managed to get by with that method.
      However, when I've had difficult documents with large lists, I've hired a Fiverr to make an Excel formula to do that particular conversion.

      I know there are programs for different types of extractions but never tried any.

      Hope that helps you. Let me know how you do.
      {{ DiscussionBoard.errors[9829585].message }}
  • Profile picture of the author JosephI
    Hi Mike
    Some time ago in a quest like yours I ran into this website and just found the link on my drive.
    I did not use them but they do have a bunch of tools and a trial option, but also if you poke around you may get some ideas from their content as to what may be possible.
    Hope its of some help to you.

    Download - Online Data Extractor - Extract Email, Phone, Fax, URL, Meta Tag from Website, Search Engine
    {{ DiscussionBoard.errors[9850336].message }}
  • Profile picture of the author AtifRizwan
    It seems like json data, you can search google for json to csv
    {{ DiscussionBoard.errors[9850532].message }}

Trending Topics