Pick up certain values from Richtext box1 to Datagridview C#

Question

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.

Amit Gupta · Answer

The question you are asking has a broad answer. Without looking to the files it cannot be determine the optimized way to solve it.

Amit Gupta · Answer

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

Sheriff · Answer

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.

Sheriff · Answer

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 "/"

Abdalla Elawad · Answer

can i deploy exe file on IIS ? Is there another way to work on the web?

Sheriff · Answer

Are these lines are separated with a new line (i.e 
 ) a escape sequence character? NO. It is not. I need to separate as per parameter wise

Amit Gupta · Answer

Okay !! Let you answer a simple question. Are these lines are seperated with a new line (i.e 
 ) a escape sequence character

Amit Gupta · Answer

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

Amit Gupta · Answer

Is that number 589 is common in all the lines and the remaining? futher files (if any)?

Sheriff · Answer

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