Pick up certain values from Richtext box1 to Datagridview C#

Sheriff

8y845Visual Basic .NET

Hello Expert C#,

i have a Richtextbox1 with 100 lines. it is mixed with alphanumberic lines.

i only wanted lines which is meeting following parameters.

1st 3 letters are Numeric

4th letter should be dash "-"

from 5th to 12 letters are numeric

from 13th to 18 letter are alphabet

19th letter is forward slash "/"

example lines - 789-12123434LHRMUC/

i only need lines to Richtexbox2 which meet above parameters.

kindly help to sort this.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdalla Elawad8y ago
can i deploy exe file on IIS ? Is there another way to work on the web?
Amit Gupta8y ago
Then you have to try some hard work to achieve this.

1. Find the index of - (hyphen) and next search for / (slash).

2. Take 3 character back (hyphen-3) for 589 or any numeric value.

3. Loop through the lines and repeat step 1 and 2 until you reach end of line.

4. For accuracy count the total characters from 589 to /.

You can achieve this using richtextbox.Find function
Or
String.IndexOf function
Sheriff8y ago
Are these lines are separated with a new line (i.e \n ) a escape sequence character?

NO. It is not.

I need to separate as per parameter wise
Amit Gupta8y ago
Okay !!

Let you answer a simple question.
Are these lines are seperated with a new line (i.e \n ) a escape sequence character
Sheriff8y ago
Thanks Amit for your reply. i am not experiance man in C#, i am learning C# through online only. to be frank Regex codes for bit complicated for me.

is there any way to split the richtextbox each lines into another boxes and check each line by required parameters.

how am doing in excel is I filter each Row by LEFT and MIDFormula. if parameters are met then I keep entire cell text in near cells. this is the method in excel.
Amit Gupta8y ago
I am not very sure but you can do this using Regex class. Here is an example link for the usage. https://stackoverflow.com/questions/6844785/how-to-use-regex-with-find-command
Sheriff8y ago
Dear Amit,

No, it is not common, thats why i need to put the parameters. each charactors positions will be common.

589-11112222BKKFRA/
1st 3 letters are Numeric
4th letter should be dash "-"
from 5th to 12 letters are numeric
from 13th to 18 letter are alphabet
19th letter is forward slash "/"
Amit Gupta8y ago
Is that number 589 is common in all the lines and the remaining? futher files (if any)?
Sheriff8y ago
Dear Amit,

thanks for your feedback. below is my data. from this i need to pickup only few lines which has above parameters. there are 12 lines below and i need only 3 line which meet my parameters.

589-11112222BKKFRA/T1K2282MC10.00/CONSOLIDATION/TRUMGA
DIM/K0/CMT122-102-122/5
/UPS SCS SERVICES /9W222/31MAR/BKK/H
SSR/TTL PLTS ONLY ONE POUCH OF DOCUMENT ATT D

589-33334444KULFRA/T1K14MC0.08/CONSOLIDATION A/QRTEPA
DIM/K0/CMT45-30-35/1
/DHL GLOBAL FORWAR/9W333/01APR/KUL/H
SSR/EXPRESS HANDLING
OSI/EHU

589-55556666NRTFRA/T22K2461.4MC9.98/CONSOL PNA/EPA
DIM/K0/CMT129-109-94/2
/K0/CMT202-110-115/1
Amit Gupta8y ago
The question you are asking has a broad answer. Without looking to the files it cannot be determine the optimized way to solve it.