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)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks