Explanation Point as Field Delimiter

[Julie]

Hi all,

I need to use an exclamtation point as a field delimiter. When I try to do this in the foolowing command I get an error:

Code: Select all

bash-3.2$ vsql -c "COPY rpt.schedule FROM '/usr/home/dbadmin/schedule.txt' NULL AS '' DELIMITER '!' EXCEPTIONS '/usr/home/dbadmin/schedule.log';"
bash: !: event not found

Any idea how I can get this to run?

[JimKnicely]

Try:

Code: Select all

vsql -c "COPY rpt.schedule FROM '/usr/home/dbadmin/schedule.txt' NULL AS '' DELIMITER E'\!' EXCEPTIONS '/usr/home/dbadmin/schedule.log';"