Click here to Skip to main content
15,606,752 members
Home / Discussions / C#
   

C#

 
QuestionVlookup a Value on a CSV file C# Pin
Member 1457406731-Aug-19 9:52
Member 1457406731-Aug-19 9:52 
AnswerRe: Vlookup a Value on a CSV file C# Pin
OriginalGriff31-Aug-19 19:55
mvaOriginalGriff31-Aug-19 19:55 
AnswerRe: Vlookup a Value on a CSV file C# Pin
BillWoodruff1-Sep-19 12:00
professionalBillWoodruff1-Sep-19 12:00 
Questionreading text file as an array by using streamreader Pin
Member 1457152028-Aug-19 19:37
Member 1457152028-Aug-19 19:37 
AnswerRe: reading text file as an array by using streamreader Pin
OriginalGriff28-Aug-19 19:56
mvaOriginalGriff28-Aug-19 19:56 
AnswerRe: reading text file as an array by using streamreader Pin
Richard MacCutchan28-Aug-19 21:27
mveRichard MacCutchan28-Aug-19 21:27 
QuestionRe: reading text file as an array by using streamreader Pin
Maciej Los28-Aug-19 21:42
mveMaciej Los28-Aug-19 21:42 
AnswerRe: reading text file as an array by using streamreader Pin
Maciej Los28-Aug-19 22:32
mveMaciej Los28-Aug-19 22:32 
If the file content has always got the same structure, you can to grab data into specific class. For example:
C#
public class MyData
{
    private System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-US");
    public string Name {get; set;}
    public string Institute {get; set;}
    public int X {get; set;}
    public int Y {get; set;}
    public string[] Headers {get; set;}
    public double[][] DataMatrix {get; set;}
    public MyData(string sFileName)
    {
        if(!File.Exists(sFileName))
            throw new FileNotFoundException($"File '{Path.GetFileName(sFileName)}' does not exist!");

        string[] lines = File.ReadAllLines(sFileName);
        Name = lines[0];
        Institute = lines[1];
        X = Convert.ToInt32(lines[5].Split(' ')[0]);
        Y = Convert.ToInt32(lines[5].Split(' ')[1]);
        Headers = lines[7].Split(new string[]{" : "}, StringSplitOptions.RemoveEmptyEntries);
        DataMatrix = lines.Skip(9)
            .TakeWhile(l=>l.Length>0 && !l.StartsWith("."))
            .Select(l=>l.Split(' ').Select(d=>Double.Parse(d, ci)).ToArray())
            .ToArray();
    }
}

Then usage will be very easy:
C#
string filename= "C://user//abc.txt";
MyData md = new MyData(filename);
Console.WriteLine(md.Name);
Console.WriteLine(md.Institute);
Console.WriteLine("X = {0}, Y = {1}", md.X, md.Y);
double[] allMasses = md.DataMatrix.Select(m=>m[0]).ToArray();
foreach(double d in allMasses)
    Console.WriteLine(d);
//on the same manner you can get Weight, Time, Velocity, Acceleration and Distance

Good luck!
AnswerRe: reading text file as an array by using streamreader Pin
BillWoodruff28-Aug-19 23:04
professionalBillWoodruff28-Aug-19 23:04 
AnswerRe: reading text file as an array by using streamreader Pin
Gene M10-Sep-19 14:48
Gene M10-Sep-19 14:48 
AnswerRe: reading text file as an array by using streamreader Pin
Lutosław12-Sep-19 9:35
Lutosław12-Sep-19 9:35 
QuestionTool to add code in my existing class Pin
Bastien Vandamme28-Aug-19 5:48
Bastien Vandamme28-Aug-19 5:48 
AnswerRe: Tool to add code in my existing class Pin
Richard MacCutchan28-Aug-19 5:54
mveRichard MacCutchan28-Aug-19 5:54 
AnswerRe: Tool to add code in my existing class Pin
Richard Deeming28-Aug-19 7:47
mveRichard Deeming28-Aug-19 7:47 
AnswerRe: Tool to add code in my existing class Pin
BillWoodruff28-Aug-19 18:35
professionalBillWoodruff28-Aug-19 18:35 
QuestionValidating textbox value against an excel worksheet and append to datagridview Pin
Member 1457117728-Aug-19 4:51
Member 1457117728-Aug-19 4:51 
AnswerRe: Validating textbox value against an excel worksheet and append to datagridview Pin
ZurdoDev28-Aug-19 5:20
professionalZurdoDev28-Aug-19 5:20 
AnswerRe: Validating textbox value against an excel worksheet and append to datagridview Pin
OriginalGriff28-Aug-19 5:23
mvaOriginalGriff28-Aug-19 5:23 
GeneralRe: Validating textbox value against an excel worksheet and append to datagridview Pin
BillWoodruff28-Aug-19 18:49
professionalBillWoodruff28-Aug-19 18:49 
AnswerRe: Validating textbox value against an excel worksheet and append to datagridview Pin
BillWoodruff28-Aug-19 18:46
professionalBillWoodruff28-Aug-19 18:46 
GeneralRe: Validating textbox value against an excel worksheet and append to datagridview Pin
Member 1457117728-Aug-19 21:21
Member 1457117728-Aug-19 21:21 
GeneralRe: Validating textbox value against an excel worksheet and append to datagridview Pin
BillWoodruff28-Aug-19 22:57
professionalBillWoodruff28-Aug-19 22:57 
QuestionRead Portion of text from Text File Pin
Member 1398003226-Aug-19 19:39
Member 1398003226-Aug-19 19:39 
AnswerRe: Read Portion of text from Text File Pin
OriginalGriff26-Aug-19 20:27
mvaOriginalGriff26-Aug-19 20:27 
GeneralRe: Read Portion of text from Text File Pin
Member 1398003226-Aug-19 20:41
Member 1398003226-Aug-19 20:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.