Re: HOW in the HECK can we import comma quote delimited ASCII !!!????
Posted in 1995
You can try this. It will get ALMOST all situations. # usage: undoit in-file out-file # << stuff removed for file testing >> cat $1 | sed -e "s/\\",\\"/|/g" | \\ sed -e "s/,\\"/|/g" | \\ sed -e "s/\\",/|/g" | \\ sed -e "s/\\([0-9]\\),\\([0-9]\\)/\\1|\\2/g" | \\ sed -e "s/^\\"//g" | \\ sed -e "s/$/|/g" > $2 # The first sed changes "," to | # The second sed changes ," to | # The third sed changes ", to | # The fourth sed changes [0-9],[0-9] to [0-9]|[0-9] # The fifth sed removes ^" # The sixth sed changes $ to | Robert Minter |Data Systems Support| \\\\\\_/// Programmer, Software Development | Orange, CA | ( _ _ ) rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) De Colores - Emmaus OC-13 | Fax: 714.771.3028 | \\`-'/ #include <disclaimer.h> SURF'S UP \\_/