Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #cut --complement -d, -f1,2 < EURUSD0.csv | sed -e 's/"//' -e 's/"//' -e 's/:00.000//' > EURUSD.10
- function formatDataTime {
- while read; do
- echo "${REPLY:7:4}"-"${REPLY:1:5}" "${REPLY:12:5}"
- done
- }
- function c2p {
- PP=${SROD%%\,*}
- ZP=${SROD#\,}
- echo -n $PP,$ZP
- }
- function splitReply {
- while : ;do
- POCZ=${REPLY%%\"*}
- REPLY=${REPLY#\"*}
- SROD=${REPLY%%\"*}
- REPLY=${REPLY#*\"}
- if [[ $POCZ == $SROD ]]; then
- echo $REPLY
- break
- fi
- echo -n $POCZ
- c2p
- done
- }
- function formatFloat {
- while read; do
- REPLY=${REPLY:26}
- splitReply
- #echo "$REPLY"
- done
- }
- cut -d , -f3- < EURUSD0.csv > EURUSD1.csv
- formatDataTime < EURUSD1.csv > EURUSD2.csv
- formatFloat <EURUSD1.csv > EURUSD3.csv
- paste '-d ' EURUSD2.csv EURUSD3.csv | sed 's/,/ /g' > EURUSD4.csv
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement