Computing.Net > Forums > Database > Newline character in data field of sybase

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Newline character in data field of sybase

Reply to Message Icon

Name: uny
Date: September 3, 2009 at 02:14:21 Pacific
OS: Unix
Product: Cisco Ciscosecure access control servers for unix
Subcategory: Non-specific SQL code
Comment:

I got a difficult scenario below:
some data of an existing table consist of newline character in one of the remark fields which when i bcp out using new line '\n' as row delimiter, the 1 row of data split into two rows when hit to the remark field. Anyone how to solve this problem, coz i need to upload the data to another database using this bcp file.



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


colmn width in oracle 9i SQL Server Reporting Serv...


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links

Ads by Google


Results for: Newline character in data field of sybase

ACT!6 Data dictionary www.computing.net/answers/dbase/act6-data-dictionary/163.html

fill in field automatically based on other 1 www.computing.net/answers/dbase/fill-in-field-automatically-based-on-other-1/626.html

Access - Form Control for field www.computing.net/answers/dbase/access-form-control-for-field/43.html