Currencies from this: https://gist.github.com/Fluidbyte/2973986
Vim regex:
%s/"\([A-Z]\+\)":\s{\n\s*"symbol":\s\(.\+\),/case \2:\r\treturn \1/g
g/name\|symbol\|decimal\|rounding\|code\|}/d
- Regex:
- vim:
%s/.*=\s\([0-9]\+\);/\1,/g
- sed:
sed -i 's/.\+\s=\s\([0-9]\+\);/\1,/g' <file>
- Input:
UPDATE schools SET point = POINT(10.806061,106.7293748) WHERE school_id = 1;
UPDATE schools SET point = POINT(10.7896527,106.699409) WHERE school_id = 2;
...
- Output:
1,
2,
...