File reading

Sign in to answer this question.

• 

  Jignesh Trivedi13y agoPosted Apr 25, 2013, 11:44 PM

  Accepted answer

  hi

  try..

  DataTable newDt = new DataTable();
  newDt.Columns.Add("paperTitle");
  newDt.Columns.Add("Authors");
  newDt.Columns.Add("Year");
  newDt.Columns.Add("publicationvenue");
  newDt.Columns.Add("othervalue");
  var stringdata = File.ReadAllText(@"E:\newText.txt").Replace("\r\n", "");
  var strings = stringdata.Split(new string[] { "#*" }, StringSplitOptions.None);
  foreach (string mystring in strings)
  {
      DataRow dr = newDt.NewRow();
      var str1 = mystring.Split(new string[] { "#@" }, StringSplitOptions.None);
      dr["paperTitle"] = str1[0];
      if (str1.Length > 1)
      {
          var str2 = str1[1].Split(new string[] { "#t" }, StringSplitOptions.None);
          dr["Authors"] = str2[0];
          if (str2.Length > 1)
          {
              var str3 = str2[1].Split(new string[] { "#c" }, StringSplitOptions.None);
              dr["Year"] = str3[0];
              if (str3.Length > 1)
              {
                  var str4 = str3[1].Split(new string[] { "#%" }, StringSplitOptions.None);
                  dr["publicationvenue"] = str4[0];
                  if (str4.Length > 1)
                  {
                      dr["othervalue"] = string.Join("#%", str4.Skip(1).ToArray());
                  }
              }
          }
      }
      newDt.Rows.Add(dr);
  }

  there is also "#!" what is meaning of this and are you do anything with this?

  hope this will help you.
• EJ

  emma johnson13y agoPosted Apr 26, 2013, 5:10 AM

  Hi!
     I want to create adjacency matrix for the given dataset.
  for example:
  
  

  #*Active Database Systems.

  #@Umeshwar Dayal,Eric N. Hanson,Jennifer Widom

  #t1995

  #cModern Database Systems

  #%995520

  
  

  #*Specification and Execution of Transactional Workflows.

  #@Marek Rusinkiewicz,Amit P. Sheth

  #t1995

  #cModern Database Systems

  #%26682

  #%807142

  #%1065531

  #%855968

  
  
  

  #*Foundations of Databases.

  #@Serge Abiteboul,Richard Hull,Victor Vianu

  #t1995

  #c

  #%1118192

  #%189

  #%1088975

  #%971271

  #%832272

  #%544788

  #%1137947

  #%597921

  #%160032

  #%641879

  #%303893

  #%929563

  #%160519

  #%1118157

  #%2246

  #%641813

  #%621173

  #%1118169

  #%544814

  #%544798

  #%641851

  #%949603

  #%209741

  #%1118135

  #%1118137

  #%597931

  
  
  In above dataset, 3 records are given. Each record starts with "#*" and ends with "#%".
  
  #*  is "paper title"
  #@ is "Authors"
  #t   is "Year"
  #c   is "publication Venu "
  #% is " paper citations"
  
  I want to create adjacency matrix against authors and the paper citations from each record , that is the number of times the author is cited.
  
• EJ

  emma johnson13y agoPosted Apr 26, 2013, 5:09 AM

  Hi!
     I want to create adjacency matrix for the given dataset.
  for example:
  
  

  #*Active Database Systems.

  #@Umeshwar Dayal,Eric N. Hanson,Jennifer Widom

  #t1995

  #cModern Database Systems

  #%995520

  
  

  #*Specification and Execution of Transactional Workflows.

  #@Marek Rusinkiewicz,Amit P. Sheth

  #t1995

  #cModern Database Systems

  #%26682

  #%807142

  #%1065531

  #%855968

  
  
  

  #*Foundations of Databases.

  #@Serge Abiteboul,Richard Hull,Victor Vianu

  #t1995

  #c

  #%1118192

  #%189

  #%1088975

  #%971271

  #%832272

  #%544788

  #%1137947

  #%597921

  #%160032

  #%641879

  #%303893

  #%929563

  #%160519

  #%1118157

  #%2246

  #%641813

  #%621173

  #%1118169

  #%544814

  #%544798

  #%641851

  #%949603

  #%209741

  #%1118135

  #%1118137

  #%597931

  
  
  In above dataset, 3 records are given. Each record starts with "#*" and ends with "#%".
  
  #*  is "paper title"
  #@ is "Authors"
  #t   is "Year"
  #c   is "publication Venu "
  #% is " paper citations"
  
  I want to create adjacency matrix against authors and the paper citations from each record , that is the number of times the author is cited.
  
• EJ

  emma johnson13y agoPosted Apr 26, 2013, 4:51 AM

  thanks :)
• 

  Vulpes13y agoPosted Apr 25, 2013, 9:44 AM

  If you want (in effect) to transfer all lines beginning with #% to the second file as well, then you just need to add a further line.StartsWith to the others :
  
  

                  if (line.StartsWith("#*") ||

                      line.StartsWith("#@") ||

                      line.StartsWith("#t") ||

                      line.StartsWith("#c") ||
                      line.StartsWith("#%")

                  {
• EJ

  emma johnson13y agoPosted Apr 25, 2013, 8:05 AM

  Hi !
    In the above dataset i want all records that are starting from "#*" and ends with "#%".
    For example:
  
  #*Foundations of Databases.
  #@Serge Abiteboul,Richard Hull,Victor Vianu
  #t1995
  #c
  #%1118192
  #%189
  #%1088975
  #%971271
  #%832272
  #%544788
  
  what modifications are needed for that?
  
  
• EJ

  emma johnson13y agoPosted Apr 25, 2013, 7:56 AM

  Thanks :) it works :)
• 

  Jignesh Trivedi13y agoPosted Apr 25, 2013, 7:28 AM

  hi,

  try following code

  DataTable newDt = new DataTable();
  newDt.Columns.Add("paperTitle");
  newDt.Columns.Add("Authors");
  newDt.Columns.Add("Year");
  newDt.Columns.Add("publicationvenue");
  var stringdata = File.ReadAllText(@"E:\newText.txt").Replace("\r\n", "");
  var strings = stringdata.Split(new string[] { "#*" }, StringSplitOptions.None);
  foreach (string mystring in strings)
  {
      DataRow dr = newDt.NewRow();
      var str1 = mystring.Split(new string[] { "#@" }, StringSplitOptions.None);
      dr["paperTitle"] = str1[0];
      if (str1.Length > 1)
      {
          var str2 = str1[1].Split(new string[] { "#t" }, StringSplitOptions.None);
          dr["Authors"] = str2[0];
          if (str2.Length > 1)
          {
              var str3 = str2[1].Split(new string[] { "#c" }, StringSplitOptions.None);
              dr["Year"] = str3[0];
              if (str3.Length > 1)
              {
                  dr["publicationvenue"] = str3[1];
              }
          }
      }
      newDt.Rows.Add(dr);
  }

  your data has also "#%" what is it?

  hope this will help you.
• 

  Vulpes13y agoPosted Apr 25, 2013, 6:31 AM

  Try this:
  
  

  using System;

  using System.IO;

  
  

  class Program

  {

      static void Main()

      {

          using (StreamReader sr = new StreamReader("emma.txt"))

          {

             using (StreamWriter sw = new StreamWriter("emma2.txt"))

             {

                string line;

                while ((line = sr.ReadLine()) != null)

                { 

                  if (line.StartsWith("#*") ||

                      line.StartsWith("#@") ||

                      line.StartsWith("#t") ||

                      line.StartsWith("#c"))

                  {

                     sw.WriteLine(line);

                  }

                }        

             }

          }

      }

  }

  
  If you don't want the first 2 characters of each line to be written to the second file, then replace this line:
  
     sw.WriteLine(line);
  
  with this one:
  
     sw.WriteLine(line.Substring(2));