How to pull the number of items in a string array

scott oliver

Hello all first off I want to thank everyone who has assisted me on this project. I am now at a point I am trying to get how many items are in this string[].

Another user on this board helped me with the following code. It uses restsharp to download a csv file and it puts the values in an array to insert into a sqlite db. There is about 12,000 items, and at the end of the file I get an error about an out of bounds value. Its because its blank. What I think I need to do is get the number of items then break the foreach loop. If there is 12500 items I probably need to break on the 12499 item. I also want to add a progress bar. Here is the code the other user assisted with.

In the Locals Watch I see there are 12294 items

{string[12294]}

Thank you again for any help. I have not programmed in years, and it seems my memory is not what it used to be.

//the csv request
IRestResponse response = restSharpClient.Execute(downloadRequest);
//adding the csv to string array
string[] strSeparators = new string[] { "\r\n" };
string[] Lines = response.Content.Split(strSeparators, StringSplitOptions.None);
//start sqlite insert
foreach (var line in Lines.Skip(1))

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R5y ago
Hi Scoot,
please try this code:
IRestResponse response = restSharpClient.Execute(downloadRequest);

//adding the csv to string array
string[] strSeparators = new string[] { "\r\n" };
string[] Lines = response.Content.Split(strSeparators, StringSplitOptions.None);

//Skip Blank Values
Lines=  Lines.Where(x => !string.IsNullOrEmpty(x)).ToArray();
  //start sqlite insert
foreach (var line in Lines.Skip(1))
Sachin Singh5y ago
sir try this

And FYI your last 2 lines have no values in coulmns (so you will get 12292 records)

Method 1.Takewhile string have length greater than 0.

Method 2.Check each line are not empty.
YourDbContext db = new YourDbContext();
var restSharpClient = new RestClient("https://www.otcmarkets.com");
var downloadRequest = new RestRequest("research/stock-screener/api/downloadCSV?pageSize=20",
Method.GET);
IRestResponse response = restSharpClient.Execute(downloadRequest);
//Console.WriteLine(response.Content);
string[] strSeparators = new string[] { "\r\n" };
string[] Lines = response.Content.Split(strSeparators, StringSplitOptions.None);
string[] Fields;
List dataList = new List();
foreach (var line in Lines.Skip(1).TakeWhile(x => x.Length > 0))
{
    try
    {
        Fields = line.Split(new char[] { ',' });
        CsvData dt = new CsvData();
        dt.Symbol = Fields[0];
        dt.Security_Name = Fields[1];
        dt.Tier = Fields[2];
        dt.Price = Fields[3];
        dt.Change = Fields[4];
        dt.Vol = Fields[5];
        dt.Sec_Type = Fields[6];
        dt.Country = Fields[7];
        dt.State = Fields[8];
        dataList.Add(dt);
    }
    catch (Exception ex)
    {
    }
}
db.CsvDatas.AddRange(dataList);
db.SaveChanges();
Console.WriteLine("finsihed" + dataList.Count());
Method 2.
var restSharpClient = new RestClient("https://www.otcmarkets.com");
var downloadRequest = new RestRequest("research/stock-screener/api/downloadCSV?pageSize=20",
Method.GET);
IRestResponse response = restSharpClient.Execute(downloadRequest);
//Console.WriteLine(response.Content);
string[] strSeparators = new string[] { "\r\n" };
string[] Lines = response.Content.Split(strSeparators, StringSplitOptions.None);
Lines = Lines.Where(x => !string.IsNullOrEmpty(x)).ToArray();
string[] Fields;
List dataList = new List();
foreach (var line in Lines.Skip(1))
{ }
scott oliver5y ago
Never mind it is Lines.Length is what I am looking for. I was thinking it was .Count.