ansaurus

Question

Answer 1

+6 A:

Since that appears to be a JSON file rather than a plain text file, use one of the JSON modules on CPAN. This is slightly complicated by the fact that you appear to have data encoded as JSON then stored as strings in a larger object which has then been converted to JSON — so you will have to parse the file, extract the strings, parse them as JSON in turn and then extract the URIs from them.

David Dorward 2010-10-10 09:20:04

Oh..thanks a lot..I got a bunch of big log files from a machine crash and thanks to you experts who could read machine txt and say this is json!!

iceman 2010-10-10 09:35:26

@David..if the given text i quoted was a .txt file, would you tell me the script to your solution?

iceman 2010-10-12 18:32:54

Answer 2

+1 A:

if Perl is not a must ,

$ sed 's|\\||g' file| awk -vRS='"url":' -F"," '{print $1}' | grep -E "http|ftp"
"http://www.altova.com/xmlspy/xml-schema-editor.html"
"http://www.altova.com/xmlspy/xml-code-generation.html"
"http://www.altova.com/videos.asp?type=0&amp;video=xmlspy"
"http://www.altova.com/solutions/exchange_ratecasestudy.html"
"http://www.altova.com/xml-editor/"
"http://manual.altova.com/XMLSpy/spystandard/index.html?xmlschemasstd.htm"
"http://manual.altova.com/XMLSpy/spystandard/xmlspy_content_dyn.html"
"http://manual.altova.com/XMLSpy/spystandard/xmlschemasstd.htm"
"http://www.altova.com/schemaagent.html"

ghostdog74 2010-10-10 09:27:31

Tried this on a Windows machine with MSYS installed..got an error: '\\' is not recognized as an internal or external command,operable program or batch file.

iceman 2010-10-12 18:36:28

on windows, change all the single quotes to double quotes and escape all double quotes inside `awk`, because cmd.exe sucks

ghostdog74 2010-10-12 23:29:14

ansaurus

tags:

views:

answers:

How can I extract URLs from JSON data?

related questions