Split string between two characters from Serial data & insert split data in to a table

Question

0.00/5 (No votes)

See more:

I need to split string between '┐' '└' which is capture from serial port. In the application I have developed I'm using serialport.readexisting(); to capture data & insert data in to a data base table for processing. Device passes the data to serial port like I given in Sample String as a data series.

Sample String:

XML

┐1 1.26582 0.0088└┐1 1.26682 0.0093└┐1 1.26922 0.0089└┐1 1.27172 0.0084└..............

Required Format

C#

┐1 1.26582 0.0088└
┐1 1.26682 0.0093└
┐1 1.26922 0.0089└
┐1 1.27172 0.0084└.
.
.
.
.

This is my code:

C#

Data = Port1.ReadExisting();
display.Invoke(new Action(() =>
{
    display.AppendText(Data);
        }));

com.CommandText = "insert into RawData (datetime,data) values('" +DateTime.Now.ToString() + "','" + Data + "')";
com.ExecuteNonQuery();

Posted 12-Jun-14 0:03am

Member 10337840

Updated 12-Jun-14 0:10am

Thanks7872

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-06-12T00:56:00

That probably won't work: you are looking for specific byte values, which may (or may not) get the characters correctly: the chances are that they are control codes, which do not convert nicely to Unicode characters (and may convert differently depending on the locale).

Instead, read the data from your serial port as bytes, and look for the specific control code bytes which the device is transmitting. Extract the data between the bytes, convert that to Unicode characters and then save it to your DB.

Playing with strings from external devices that aren't sending string based data is a recipe for horrible problems later.