Hi..i am working on parsing a textfile.i am stuck at one place..i want to know how can i parse this text part of text file..i want to skip the headers(item,visa,etc..) and(No|Amt) and the headings on left side of table SALES(STD),SALES(ELC),etc.. i want to insert only the numeric values in database along with MerchantNo and OutletName
MERCHANT NO : 105838015
OutletName : Big Bazzar
ITEM VISA MASTERCARD DINERS TOTAL
------------------------------------------------------------------------------------------------------------------------------------
| NO| AMT | NO| AMT | NO| AMT | NO| AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
SALES(STD) | 0| 0.00| 0| 0.00| 0| 0.00| 0| 0.00
SALES(ELC) | 10| 16466.78| 9| 16573.86| 0| 0.00| 19| 33040.64
REFUND | 1| -371.20| 0| 0.00| 0| 0.00| 1| -371.20
DISC/STD | 0| 0.00| 0| 0.00| 0| 0.00| 0| 0.00
DISC/ELC | 10| -238.77| 9| -240.34| 0| 0.00| 19| -479.11
DISC/REF | 1| 6.12| 0| 0.00| 0| 0.00| 1| 6.12
ACCRUED | 0| 0.00| 0| 0.00| 0| 0.00| 0| 0.00
This is the part of code which i have wriiten for the textfile for parsing other data in textfile..
foreach (string item in str)
{
if (item.Trim().Contains("MERCHANT NO :"))
{
string MNo1 = item.Substring(15, 23).Trim();
MNo = Convert.ToInt32(MNo1);
}
if (item.Contains("XXXX"))
{
char[] separators = new char[] { ' ' };
string[] rec = item.Trim().Split(separators, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < rec.Length; i++)
{
if (!String.IsNullOrEmpty(rec[i]))
{
string Date = rec[0].ToString();
AuthDate = Convert.ToDateTime(Date);
BNo = rec[1].ToString();
SNo = rec[2].ToString();
CardNo = rec[3].ToString();
TranType = rec[4].ToString();
RefNumber = rec[5].ToString();
AuthCode = rec[6].ToString();
string Amount = rec[7].ToString();
TranAmount = Convert.ToDecimal(Amount);
SqlConnection con = new SqlConnection("Data Source=COMPUTER-8EB749;Initial Catalog=TRMSDB;Integrated Security=true");
con.Open();
string columnnames = "MerchantNo,AuthDate,BTNo,SeqNo,CardNo,TranType,RefNo,AuthCode,TranAmt";
string InsertQuery = String.Format("insert into TblBank ({0}) values ('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", columnnames, MNo, AuthDate, BNo, SNo, CardNo, TranType, RefNumber, AuthCode, TranAmount);
SqlCommand cmd = new SqlCommand(InsertQuery, con);
cmd.ExecuteNonQuery();
}
break;
}
}
if(item.StartsWith)
{
char[] separators = new char[] {'|'};
string[] amount = item.Trim().Split(separators);
for (int j = 0; j < amount.Length; j++)
{
if (!String.IsNullOrEmpty(amount[j]))
{
}
}
} }
Do help..