CVS2Strings.sh

#!/bin/bash

# given a spreadsheet, create a Localizable.strings file for a given language

cat localized.csv |

    while IFS=',' read devConst devValue englishValue spanishValue; do

        if [[ $devValue ]]; then
            devConst=`echo "$devConst" | tr -d '/* '`
            # key=`echo $devValue | cut -d " = " -f 1 | tr -d '"'`
            key=`echo $devValue | cut -d "=" -f 1 | sed -e 's/\"//g' | sed -e 's/ $//'`
            echo "/* $devConst */"
            echo \"$key\" = \"$spanishValue\"\;
            echo
        fi    
    done