RE: [SPAM]Question on delimiters [13485]

Art, Thanks for the quick suggestion and that will work by pre-processing the file. Roberto, I agree with you if it were a unloaded file. Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bruce Simms Sent: Thursday, September 25, 2008 7:57 AM To: ids@iiug.org Subject: [Warning: Sender Impersonated] [SPAM]Question on delimiters [13485] IDS Version is 9.4.FC9 OS is Solaris 8 We received a file we are trying to load to a temp table to process and has "||" as the field delimiter has anyone work with multiple character delimiters or any suggestions, tried tr but then if you have a blank field then we get wrong number of arguments. Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.