String.Split - How to calculate slot

s h

Hello,

look im new in programming, would be awesome if u could help me.

Im reading a whole .csv File with this:

private void button3_Click(object sender, EventArgs e)
        {
            {
                var content = string.Empty;
                using (StreamReader reader = new StreamReader(@"C:/1.csv", System.Text.Encoding.Default))
                {
                    content = reader.ReadToEnd();
                    reader.Close();
                }

                content = content.Replace("\"", string.Empty);
                content = content.Replace("               ", "");
               content = content.Replace("             ", "");

                using (StreamWriter writer = new StreamWriter(@"C:/2.csv"))
                {
                    writer.Write(content);
                    writer.Close();
                }
            }
        }

1.CSV Input looks like this:

" 09000";"Catalaog 1";10148;234
" 09001";"Catalaog 2";0;345

2.CSV Outlooks like this:

09000~Catalaog 1~10148~234
09001~Catalaog 2~0~0

I need a rewrite of my Code that the last to slots 10148~234 get calculated.

String must look like this at the end:

09000~Catalaog 1~9914~234
09001~Catalaog 2~0~0

See the diffrence? The 10148 - 234 = 9914. The 10148 gets replaced with the result.

Could u rewrite my upper code and help me ?:<

20 Replies

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

Vulpes13y ago
Accepted answer
If you're using the version which allows for there being 3 or 4 columns, add this line at the top of the method (before the using statements):

string spaces = new string(' ', 15);

Now change this line:

line = String.Join("~", items, 0, len - 1);

to this:

line = spaces + String.Join("~", items, 0, len - 1);
s h13y ago
Worked all, thanks, good work, could u help me here? http://www.c-sharpcorner.com/Forums/Thread/205494/string-split-how-to-calculate-slot.aspx
s h13y ago
Problem was, i uploaded the File, before writing it to End with Streamwriter.

Now other question, how can i add 15 spaces @ the start like this @ every Line:

09000";11131;476
09001";11132;472
Vulpes13y ago
If you have the file open in another program, then I'd close that.

Also I'd check Task Manager to see whether there's still an instance of the current process running. If there is, kill it from there.
s h13y ago
I got a Result with that :

string line;
bool first = true;
while ((line = reader.ReadLine()) != null)
{
if (first)
{
first = false;
continue;
}
string[] items = line.Replace("\"", "").Trim().Split(';');
if (items.Length != 3) continue;
int i1, i2;
bool b1 = int.TryParse(items[1], out i1);
bool b2 = int.TryParse(items[2], out i2);
if (!b1 || !b2) continue;
items[1] = Math.Max(0, i1 -i2).ToString();
line = String.Join("~", items, 0, 2);
writer.WriteLine(line);
}

But i have a Problem

The process can't access the file, because it is being used by another process
for StreamWriter
Vulpes13y ago
That's more awkward as there are only 3 rather than 4 columns in the line.

However. try this (untested):

private void button3_Click(object sender, EventArgs e)
{
using(StreamWriter writer = new StreamWriter(@"C:/2.csv"))
{
using(StreamReader reader = new StreamReader(@"C:/1.csv",System.Text.Encoding.Default))
{
string line;
bool first = true;
while((line = reader.ReadLine()) != null)
{
if(first)
{
first = false;
continue;
}

string[] items = line.Replace("\"", "").Trim().Split(';');
int len = items.Length;
if (len < 3 || len > 4) continue;
int i1, i2;
bool b1 = int.TryParse(items[len - 2], out i1);
bool b2 = int.TryParse(items[len - 1], out i2);
if(!b1 || !b2) continue;
items[2] = (i1 -i2).ToString();
line = String.Join("~", items, 0, len - 1);
writer.WriteLine(line);
}
}
}
}
s h13y ago
Hey Vulpes,

how to Change ur Code that it works with this Input string:

" 09000";11131;476
Vulpes13y ago
To do that, just change this line:

items[2] = (i1 -i2).ToString();

to this:

items[2] = Math.Max(0, i1 -i2).ToString();
BASCHDI13y ago
thanks, works good, i try to understand it, seems good fast..how would be the Code without going in negative, only writing 0. ?

this one "Do you want the subtraction to give 0 rather than a negative figure?"
Vulpes13y ago
This would be the code to skip any problem lines altogether:

private void button3_Click(object sender, EventArgs e)
{
using(StreamWriter writer = new StreamWriter(@"C:/2.csv"))
{
using(StreamReader reader = new StreamReader(@"C:/1.csv",System.Text.Encoding.Default))
{
string line;
bool first = true;
while((line = reader.ReadLine()) != null)
{
if(first)
{
first = false;
continue;
}

string[] items = line.Replace("\"", "").Trim().Split(';');
if (items.Length != 4) continue;
int i1, i2;
bool b1 = int.TryParse(items[2], out i1);
bool b2 = int.TryParse(items[3], out i2);
if(!b1 || !b2) continue;
items[2] = (i1 -i2).ToString();
line = String.Join("~", items, 0, 3);
writer.WriteLine(line);
}
}
}
}
Vulpes13y ago
What do you want to do:

1. Skip them altogether; or

2. Treat the "" as though it were 0?
s h13y ago
Got one problem..i got orginally file...look

" 09000";"Catalog 1";11131;476
" 09000";"Catalog 2";11131;200
" 09000";"Catalog 3";11131;32
" 09000";"Catalog 4";11131;244
" 09001";"Catalog 5";0;""
" 09002";"Catalog 6";166;""

if there is nothing in it, there r only "" .

i get a Format Execption @

int i2 = int.Parse(items[3]);

what can i do ?
s h13y ago
Thx vulpes, thats exactly what i needed. 2 Thumbs up. Not last Time u have seen me. thx sir!
Vulpes13y ago
Incidentally, if you don't want to output the final column, just replace this line:

line = String.Join("~", items);

with this:

line = String.Join("~", items, 0, 3);
Vulpes13y ago
OK, try this revised version:

private void button3_Click(object sender, EventArgs e)
{
using(StreamWriter writer = new StreamWriter(@"C:/2.csv"))
{
using(StreamReader reader = new StreamReader(@"C:/1.csv",System.Text.Encoding.Default))
{
string line;
bool first = true;
while((line = reader.ReadLine()) != null)
{
if(first)
{
first = false;
continue;
}

string[] items = line.Replace("\"", "").Trim().Split(';');
int i1 = int.Parse(items[2]);
int i2 = int.Parse(items[3]);
items[2] = (i1 -i2).ToString();
line = String.Join("~", items);
writer.WriteLine(line);
}
}
}
}
s h13y ago
must be -345 then, not null

there is only 1 invalid line, at the start..rest goes like this:

"";"";0
" 09000";"catalog 1";10148;524
" 09001";"catalog 2";0;5225
" 09002";"catalog 3";166;522
" 09003";"catalog 4";557;4254
" 09004";"catalog 5";0;422
" 09005";"catalog 6";382;2424
" 09006";"catalog 7";0;42425

the diggits (last column) r randomly by me for now, cause no export.
Vulpes13y ago
What happens to this line:

" 09001";"Catalaog 2";0;345

as subtracting 345 from 0 gives -345.

Do you want the subtraction to give 0 rather than a negative figure?

Also do you want any invalid lines to be just skipped and not written to the output file?
s h13y ago
Vulpes it works nice the code, but only the first 2 Lines get replaced, i need whole file.

and i get outofindex exeption, i need to skip the first line, cause its everytime filled with crap

"";"";0
" 09000";"Catalaog 1";10148;234
" 09001";"Catalaog 2";0;345
" 09002";"Catalaog 3";10148;234
" 09003";"Catalaog 4";0;345
s h13y ago
The File contains 3000 Lines, goes on like this..

09000~Catalaog 1~10148~234
09001~Catalaog 2~0~0
09003~Catalaog 3~2000~300

whole file the last 2 delimited columns must b calculated like

09000~Catalaog 1~10148~234: 10148-234= 9914
09001~Catalaog 2~0~0: 0-0= 0
09003~Catalaog 3~2000: 2000-300 = 1700

File @ the end must look like this :

09000~Catalaog 1~9914~234
09001~Catalaog 2~0~0
09003~Catalaog 3~1700~300

can i do this with your code?

and thanks for the time u took for me, awesome!
Vulpes13y ago
I'm not sure how the second line is calculated so I've just replaced the '345' with '0':

private void button3_Click(object sender, EventArgs e)
{
string[] lines = File.ReadAllLines(@"C:/1.csv",System.Text.Encoding.Default);
string[] items = lines[0].Replace("\"", "").Trim().Split(';');
int i1 = int.Parse(items[2]);
int i2 = int.Parse(items[3]);
items[2] = (i1 -i2).ToString();
lines[0] = String.Join("~", items);

items = lines[1].Replace("\"", "").Trim().Split(';');
items[3] = "0";
lines[1] = String.Join("~", items);
File.WriteAllLines(@"C:/2.csv", lines);
}