ASCII import - new line character

I am importing ascii text files to tables in an whatcom 4 db.
For some big text fields i need to put a "newline" character
in order to get a new line in i.e varchar fileds.

I have tried � ~n with no success.

any postings will be appreciated.



Per H. Kleppe

Try using \n.  Watcom/SQL Anywhere reads the C special print characters,
sometimes when you don't want it to.
-- 
Jim Egan [TeamPS]
Dealer Solutions, LLC
Houston, TX

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BCD822.8928C750
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Jim,
You suppose the replication address in DBREMOTE will suffer from the same C
character interpretation for '\n' ?(sinking feeling : )

-Aditya


--
http://www.softra.com

Jim Egan wrote in article <[email protected]>...

>Try using \n.  Watcom/SQL Anywhere reads the C special print characters,
>sometimes when you don't want it to.
>--
>Jim Egan [TeamPS]
>Dealer Solutions, LLC
>Houston, TX

------=_NextPart_000_0005_01BCD822.8928C750
Content-Type: text/x-vcard;
	name="Aditya Bhushan [SOFTRA - NT, Sybase, PowerBuilder].vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="Aditya Bhushan [SOFTRA - NT, Sybase, PowerBuilder].vcf"

BEGIN:VCARD
N:Bhushan [SOFTRA - NT, Sybase, PowerBuilder];Aditya
FN:Aditya Bhushan [SOFTRA - NT, Sybase, PowerBuilder]
EMAIL;PREF;INTERNET:[email protected]
END:VCARD

------=_NextPart_000_0005_01BCD822.8928C750--

It is possible.  However, I don't do any remote development so I'm really
not one to say.
-- 
Jim Egan [TeamPS]
Dealer Solutions, LLC
Houston, TX

Jim Egan wrote:
> 
> Try using \n.  Watcom/SQL Anywhere reads the C special print characters,
> sometimes when you don't want it to.
> --
> Jim Egan [TeamPS]
> Dealer Solutions, LLC
> Houston, TX

In my PB4 appl. the \n shows as � character.

I'm exporting ASCII DOS text files and want to put in
"new line" characters to control the text format
in varchar fields after importing to a PB4/whatcom4 appl.

Before importing to whatcom4,
i'm doing the file conversion like this
DOS ASCII -> MS Excel -> Windows ANSI -> Whatcom DB

Conversion from DOS(ASCII) to WIN(ANSI) char.set by using MS Excel.

I still can't get the new line character right.

Any ideas ? :)




Per H. Kleppe