samedi 17 janvier 2015

Using cURL, How can I fetch a numerical string which contains commas and spaces and convert such to a NON COMAFIED string


Example: Google's Outstanding Shares are 670,000,000 and this value is collected in a txt file from Yahoo Finance API using the below script.


The issue is; that numbers WITH commas or spaces are near impossible for the text wizard and Excel to delimit when I pull this txt file into Excel to complete my work.


Ie the delimiter wants to break 670,000,000 into three separate values AND spread this across three columns which is a joke and renders my work futile.


Thus: I need the prospective script to bring all numerical strings that originally contained commas and spaces back to the txt file WITHOUT such. Ie no commas or no spaces.


So rather than 670,000,000 being brought into the txt file, I need 670000000 so that Excels antiquated delimiter may render the data into columns properly.


I have asked this question 4 times on here and each time the code provided by the super user has not worked.


cd desktop/quoteUpdate while true do curl -o quotes.txt -s "http://ift.tt/17UnUFi" echo UPDATED: date sleep 10 Done



Aucun commentaire:

Enregistrer un commentaire