Solved

transform the CR/LF characters to \r\n

Posted on 2004-09-14
14
1,342 Views
Last Modified: 2008-02-01
I have text data from FoxPro (memo).  There are a few paragraphs in a single transaction that I pull back into a WIN FORM dataset to present in a textbox.  No edit here, just read only.

What is the best way to repalce the CR/LF with the escape sequences that my WinForms will use?

Im pretty green at reqular expressions if that is the best way to handle this.

TIA



0
Comment
Question by:srussell705
  • 8
  • 4
  • 2
14 Comments
 
LVL 14

Expert Comment

by:AvonWyss
ID: 12054647
CR==\r
LF==\n
Therefore, if the sequence is CRLF, you should not need any conversion.
0
 
LVL 1

Author Comment

by:srussell705
ID: 12055517
Thanks but trust me.  This is not the answer.

When I fill my textbox, I see two boxes butted next to one another for CR & LF in my display.  If I were to copy the text here it would break according to CR&LF.  

0
 
LVL 14

Expert Comment

by:AvonWyss
ID: 12055532
Could it be that the data is LFCR instead of CRLF? Because if it IS CRLF, you'll not see boxes...
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 14

Expert Comment

by:AvonWyss
ID: 12055552
You can try this:

string output=Regex.Replace(input, @"\r\n|\n\r|\r|\n", "\r\n", RegexOptions.SingleLine);
0
 
LVL 11

Expert Comment

by:Agarici
ID: 12056223
i suggest replacing "\r\n" with Environment.NewLine

i guess your problem is because the textbox does not convert tex text corectly to unicode


hth.
A.
0
 
LVL 11

Expert Comment

by:Agarici
ID: 12056257
btw you wont need regular expressions to do that
all you need is : YourTextBox.Text = YourTextBox.Text.Replace( "\r\n", Environment.NewLine );

hth.
A.
0
 
LVL 14

Expert Comment

by:AvonWyss
ID: 12056726
Agarici, on Windows, Environment.Newline is always \r\n, so that you suggestion will just reproduce the string which was already present without changing anything.
0
 
LVL 1

Author Comment

by:srussell705
ID: 12057277

Thanks.  I was trying to figure out how to do the same but replace the \r\n with CHR(13) + CHR(10)

I'm playing with :
Char[] chars;
Byte[] bytes = new Byte[] {13,  10 };

ASCIIEncoding ascii = new ASCIIEncoding();


chars = ascii.GetChars(bytes,0,1) ;

But I'm not there yet.

any ideas?
0
 
LVL 14

Expert Comment

by:AvonWyss
ID: 12057359
\r\n IS CHR(13) + CHR(10) - there is nothing to replace!
0
 
LVL 1

Author Comment

by:srussell705
ID: 12057408
Not getting funny now :(

my code:
                  Char[] chars;
                  Byte[] bytes = new Byte[] {13,  10 };

                  ASCIIEncoding ascii = new ASCIIEncoding();


                  chars = ascii.GetChars(bytes,0,2) ;//  " characters used to decode bytes." ;

                  int ln1 = 0;
                  string lcd ="";
                  foreach (Char c in chars)
                  {
                        lcd += chars[ln1] ;//Console.Write("[{0}]", c);
                        ln1 ++;
                  }
                  
                  mmTextBox2.Text = mmTextBox2.Text.Replace( lcd, Environment.NewLine );

lcd translates to "\r\n", and does no real work in the replacement as iI step through the code :(


0
 
LVL 14

Expert Comment

by:AvonWyss
ID: 12057466
That's what I said, right?
0
 
LVL 14

Accepted Solution

by:
AvonWyss earned 200 total points
ID: 12057601
Did you even bother to see what line endings you get? And to try if the given regex works?
0
 
LVL 1

Author Comment

by:srussell705
ID: 12058485
I went back to the regEx example and bingo.  I wanted to work harder and not smarter I guess.

Thanks to all!!!
0
 
LVL 14

Expert Comment

by:AvonWyss
ID: 12058541
Good to hear it worked for you. So there were other line breaks than \r\n in the string... ;-)
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question