No announcements
Found 523903 threads
-
0 VotesXML With Carriage Return in ExecuteSQL task
The issue is, that the FOR XML AUTO returns the data without white spaces.Answered | 2 Replies | 2273 Views | Created by cherriesh - Friday, August 16, 2013 4:11 AM | Last reply by - Thursday, February 4, 2016 2:47 AM
-
1 Votes
Carriage return symbol is removed from XML
Hi dalong, The scenario you pointed is the behavior of the XML processor by default.Answered | 3 Replies | 10919 Views | Created by dalong - Friday, November 25, 2011 4:22 PM | Last reply by ohnobinki - Wednesday, July 16, 2014 8:50 PM -
1 Votes
carriage returns
The other part is that I want to get the current data from an sql server 2000 database into excel so that i can see where the carriage returns are in the data. ...Answered | 6 Replies | 5240 Views | Created by prib - Tuesday, April 27, 2010 10:06 PM | Last reply by Naomi N - Wednesday, April 28, 2010 12:00 PM -
0 Votes
NTEXT Carriage return corrupt
This issue may be caused by the font type discrepancy between SQL Server 2005 SP3 and PDF, to figure out it, there is one work-around: replace the carriage ...Answered | 1 Replies | 4227 Views | Created by Jefta - Tuesday, August 9, 2011 8:39 AM | Last reply by Sharp Wang - Thursday, August 11, 2011 10:17 AM -
0 Votes
BCP when a NTEXT column contains carriage returns
Best way is to replace carriage return with come character.Answered | 4 Replies | 10022 Views | Created by KenTedD - Wednesday, June 13, 2012 5:36 PM | Last reply by Erland Sommarskog - Wednesday, September 7, 2016 9:19 PM -
1 Votes
Counting Carriage returns
You can count the carriage return by the below method.CHAR(13) is the carriage return character.Answered | 2 Replies | 10001 Views | Created by ScottCollins - Wednesday, June 9, 2010 10:42 AM | Last reply by Naomi N - Wednesday, June 9, 2010 2:02 PM -
1 Votes
Remove carriage returns and then replace
£ as a replacement for the line feed and carriage returns.Answered | 10 Replies | 8027 Views | Created by james_stap - Friday, January 26, 2018 8:56 AM | Last reply by james_stap - Monday, January 29, 2018 5:02 PM -
0 Votes
Add Carriage return problem
I'm having a problem adding a Carriage return to the following.Answered | 1 Replies | 1949 Views | Created by Dave_irb - Friday, November 2, 2012 12:47 PM | Last reply by Kazun - Friday, November 2, 2012 1:29 PM -
0 Votes
Output Parameters in ADO.NET ExecuteSQL task
Hi dtl1, Please refer to the following ...Answered | 5 Replies | 6587 Views | Created by dtl1 - Friday, November 4, 2011 5:10 PM | Last reply by Eileen Zhao - Tuesday, November 8, 2011 9:54 AM -
0 Votes
Carriage return missing in webservice Lists.asmx
So we can avoid to insert Carriage Return into the textbox having “ Multiline” TextMode property or in TextArea control.Answered | 6 Replies | 7368 Views | Created by ekomsdn - Monday, June 8, 2009 11:19 AM | Last reply by elizas - Tuesday, May 11, 2010 9:23 AM -
1 Votes
Assistance Please: Carriage Returns not in production file
Inplace of Carriage return, is there anyother delimiter present ?Answered | 3 Replies | 3500 Views | Created by MSDEVTECH - Wednesday, October 12, 2011 11:51 AM | Last reply by MSDEVTECH - Wednesday, October 12, 2011 5:17 PM -
1 Votes
ExecuteSQL Task with Parameters
I am just trying to capture the return code from a stored proc, and there are no results sets, and no parameters.Answered | 22 Replies | 31695 Views | Created by ChrisKinsman - Thursday, July 14, 2005 1:37 AM | Last reply by mehmetorman - Friday, July 25, 2008 9:19 PM -
0 Votes
insert carriage return in the middle of the text
Sorry i was running it with a different text search so thats why did not see the carriage return in result set.Answered | 7 Replies | 8193 Views | Created by madhavi ajjarapu - Wednesday, September 19, 2012 3:56 PM | Last reply by madhavi ajjarapu - Thursday, September 20, 2012 5:19 PM -
0 Votes
remove carriage return between text two objects
Hi , Try like this , --To replace Carriage return =REPLACE(Fields!Answered | 1 Replies | 1783 Views | Created by rama rose - Wednesday, December 18, 2013 12:34 AM | Last reply by SathyanarrayananS - Wednesday, December 18, 2013 2:28 AM -
0 Votes
Return string with Carriage Returns (chr(13)) from BCS
Do you think that the bcs runtime is removing the carriage returns that my code inserted?Answered | 4 Replies | 3725 Views | Created by Russell_G - Thursday, April 5, 2012 1:00 PM | Last reply by Russell_G - Friday, April 13, 2012 1:56 PM -
0 Votes
How to remove carriage return to unwrap flat file
Hi LyndseyCupit0913, If you want to remove all carriage return in Flat file, please using Replace function in the Derived Column ...Answered | 2 Replies | 5316 Views | Created by LyndseyCupit0913 - Tuesday, May 24, 2016 6:15 PM | Last reply by Seif Wang - Wednesday, June 1, 2016 1:48 AM -
1 Votes
Carriage Leaf Returns
But when I do this some of my attributes end up being translated with carriage leaf return characters.Answered | 3 Replies | 3544 Views | Created by PHKofiHBSmith - Thursday, October 25, 2012 9:24 AM | Last reply by PHKofiHBSmith - Sunday, October 28, 2012 10:18 PM -
0 Votes
Carriage Return + Line Feed
I am trying to do some cleansing to this data, so that I could replace line feed + carriage spacing.Answered | 1 Replies | 5193 Views | Created by SubhashP - Wednesday, July 21, 2010 4:32 AM | Last reply by Todd McDermid - Wednesday, July 21, 2010 4:55 AM -
4 Votes
Dealing with carriage returns within flat file source fields
The only solution appears to be to scrub all of the carriage returns, etc., that occur within a text field out of the file before (or as?)Answered | 15 Replies | 15175 Views | Created by SteveElkins - Thursday, April 2, 2015 5:13 PM | Last reply by Luís Filipe Costa - Wednesday, February 8, 2017 6:14 PM -
0 Votes
Execute SQL Task with XML resultset not return properly
I tried to have FOR XML AUTO for my direct input SQL statement and got almost what I need except the same problem with having <ROOT>Answered | 2 Replies | 4617 Views | Created by MeganZ9 - Thursday, September 16, 2010 5:58 PM | Last reply by MeganZ9 - Thursday, September 16, 2010 6:31 PM - Items 1 to 20 of 523903 Next ›
No announcements
