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
![]() |
0 |
![]() |
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
![]() |
0 |
![]() |
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--
![]() |
0 |
![]() |
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
![]() |
0 |
![]() |
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
![]() |
0 |
![]() |