Thanks for your replay... I resolve the problem with sed before i post the question. But a really want to know if i can handle all with posgre script.
Mariano -----Mensaje original----- De: Richard Huxton [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 24 de Septiembre de 2003 14:19 Para: Montervino, Mariano; '[EMAIL PROTECTED]' Asunto: Re: [SQL] Especial delimiters caracter On Tuesday 23 September 2003 15:56, Montervino, Mariano wrote: > running the following script > > select ('cabal\\' || user_name) into temporary user_access from > tbl_user_access where access_profile_id = 4; > copy user_access to '/temp/users.txt' delimiters '|'; > > The result of the output file is... > domain\\users > but the field in the temp table is... > domain\users > > I need the same result like temp table. How could i do it?? > RGDS $ cat fakedump.txt C:\\Windows\\system32\\drivers|this\ttabbed\ttext\n $ perl -p -e 's/\\\\/\\/g;' fakedump.txt C:\Windows\system32\drivers|this\ttabbed\ttext\n As you can see, this only handles \\ not \t=tab. You could also do this in sed: $ sed -e 's/\\\\/\\/g' fakedump.txt HTH -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
