+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    49

    Extract a text from word and place it en excel or word?

    Hello everyone,

    Is it possible to extract a certain word or number from a text file and place it in an excel sheet?

    Example:

    I want to extract the following numbers that appear after {"planet_id":" and have just the numbers extracted and be place in an excel sheet or word document.

    var mapData = JSON.decode('{"325619":{"debris":{"32561906":{"planet_id":"32561906","r1":"14331","r2":"19008"}},"pl anets":{"32561902":{"planet_id":"32561902","player_name":null,"alliance_name":null,"alliance_id":
    null,"user_id":null,"system_id":"325619",


    Thanks in advance,
    Elegidos (Spain)

  2. #2
    Forum Moderator pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2010
    Posts
    5,141

    Re: Extract a text from word and place it en excel or word?

    Hi Elegidos
    Can you attach the text file?
    regards pike

    If the solution helped please donate
    here to the RSPCA

    Sites worth visiting;

    J&R Solutions - royUK

    AJP Excel Information - Andy Pope

    Spreadsheet Toolbox

    JBeaucaires Excel Files

    VBA for smarties - snb

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.2.0