Example: Google Outstanding Shares are 670,000,000 and this value is collected in a txt file from Yahoo Finance API via the below script. The issue is; that numbers WITH commas or spaces are a bloody nightmare for Excel's delimiter to understand when I pull this txt file into Excel.
NB: I need the script to bring this value and all others values back WITHOUT commas OR spaces. I need 670000000 so that Excel antiquated delimiter can put the data into columns.
I have asked this a few times. Can someone put me out of my misery please before the hernia goes again and the mac gets launched out of the window. Thank you.
cd desktop/quoteUpdate
while true
do
curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=nsl1c1p2j2r"
sed -i '.bak' 's/,/ /g' quotes.txt # replace commas with spaces
echo UPDATED:
date
sleep 10
done