using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; namespace AQCConsolidator1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnGetData_Click(object sender, EventArgs e) { List<String> list1 = new List<String>(); string req =@"TST00003 DCA1S211E AD/18APR M 1 LD 20APR13 OD SDFSDF SI T-E FXP/R,U 1.MCKEEL/WESLEY C 2.MCKEEL/MATTHEW M 3.SMITH/ALEXANDER P 1 SDF AA 3273 Q 17MAY 1245P OK QLW0N8B1 CDTP 17AUG 2PC 2 X DFW AA 399 Q 17MAY 345P OK QLW0N8B1 CDTP 17AUG 2PC 3 X SFO AA 5815 Q 17MAY 705P OK QLW0N8B1 CDTP 17AUG 2PC 4 HND ARNK 5 O NRT AA 176 Q 30MAY 1130A OK QLX0N8B1 CDTP 20MAY17AUG 2PC 6 X DFW AA 830 Q 30MAY 320P OK QLX0N8B1 CDTP 20MAY17AUG 2PC SDF FARE F USD 488.00 TX001 X USD 580.00YRVB TX002 X USD 5.50YCAE TX003 X USD 17.20USAP TX004 X USD 17.20USAS TX005 X USD 5.00XACO TX006 X USD 7.00XYCR TX007 X USD 10.00AYSE TX008 X USD 21.08SWAE TX009 X USD 5.17OISE TX010 X USD 18.00XF TOTAL USD 1174.15 GRAND TOTAL USD 1174.15 SDF AA X/DFW AA X/SFO AA TYO M257.60QLW0N8B1/CDTP AA X/DFW AA SDF M230.00QLX0N8B1/CDTP NUC487.60END ROE1.000000 XF SDF4.5DFW 4.5SFO4.5DFW4.5" string Req1 = @"FXP/R,U,CL-MBT 1.JAYAPAL/HEMACHANDRA 1 ORD UA 940 T 21MAY 610P OK TKX6NCE CN10 21MAY21MAY 1PC 2 X FRA LH 758 T 22MAY 1100A OK TKX6NCE CN10 22MAY22MAY 1PC 3 O MAA 9W 470 H 17JUN 710P OK TKX6NCE CN10 17JUN17JUN 1PC 4 X BOM LX 155 T 18JUN 050A OK TKX6NCE CN10 18JUN18JUN 1PC 5 X ZRH LX 2608 T 18JUN 955A OK TKX6NCE CN10 18JUN18JUN 1PC ORD FARE I USD 711.00 TX001 X USD 540.00YQAC TX002 X USD 5.50YCAE TX003 X USD 17.20USAP TX004 X USD 17.20USAS TX005 X USD 5.00XACO TX006 X USD 7.00XYCR TX007 X USD 2.50AYSE TX008 X USD 25.92RAEB TX009 X USD 8.71DESE TX010 X USD 3.65WOMU TX011 X USD 25.66CHAE TX012 X USD 4.50XF TOTAL USD 1373.84 GRAND TOTAL USD 1373.84 CHI UA X/FRA LH MAA M/IT TKX6NCE/CN10 9W X/BOM LX X/ZRH LX CHI M/IT TKX6NCE/CN10 END XF ORD4.5 55.FE REFTHRUAG/NONEND/NONRERTE/LH/UA/AC/OS/SN/LX ONLY -BG:LH 59.FM *M*0 60.FP CHECK"; list1.Add(Req); list1.Add(Req1); DataTable dt = mc.GetDetail(list1); dataGridView1.DataSource = dt;
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Text.RegularExpressions; namespace AQCConsolidator1 { class MyClass1 { string output; string subs; DataTable dt = new DataTable(); DataRow dr = null; public DataTable GetDetail(List<string> request) { dt.Columns.Add("PAX", typeof(string)); foreach (string data in request) { string item = data; dr = dt.NewRow(); Regex regexs = new Regex(@"(FXP/R\s+(.+?)+\s)|(FXP/R.\S{0,10}\s\S{0,10}\s+(.+?)+\s)"); foreach (Match m in regexs.Matches(item)) { output = m.ToString(); } dr["PAX"] = output; dt.Rows.Add(dr); } return dt; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)