C#•3mo ago

✅ Program csv extraction

I created a program but when it extracts as a csv file its got a Â symbol and one of the values extract into two separate cells

36 Replies

Angius•3mo ago

For the first issue, my bet is encoding differences. Make sure the encodings match, or convert them if needed. Could be the CSV is encoded in ASCII, and the output wants UTF8, for example. Or the other way around. For the other issue, could it be that a comma is used for a thousands separator? 1,400? Because "CSV" stands for "comma-separated values", so

rent,300.00
food,300.00
remaining,1,400.00

rent,300.00
food,300.00
remaining,1,400.00

will be treated as

rent      | 300.00 |
food      | 300.00 |
remaining | 1      | 400.00

rent      | 300.00 |
food      | 300.00 |
remaining | 1      | 400.00

Mist•3mo ago

i tried removing the comma but it made it so it would all be in the first cell

leowest•3mo ago

rent,300.00
food,300.00
remaining,"1,400.00"

rent,300.00
food,300.00
remaining,"1,400.00"

Mist•3mo ago

Oh so just making it a quote would work

leowest•3mo ago

yes because its one way CSV uses to ignore a comma within a column ideally you should use a library like CSVHelper it will make your life easier

Mist•3mo ago

Thank you I don’t really do a lot of projects where they extract

MODiX•3mo ago

Use the /close command to mark a forum thread as answered

Mist•3mo ago

what would i do about the A as i have no idea what that is even ment to be

leowest•3mo ago

its probably currency symbol you're not using the right encoding so without more details about how you're writing that file hard to tell

Mist•3mo ago

can i share my code on this thread

leowest•3mo ago

$paste to the site below if possible

MODiX•3mo ago

If your code is too long, you can post to https://paste.mod.gg/ and copy the link into chat for others to see your shared code!

leowest•3mo ago

you can also add multiple files to it if u have to no zippped files

Mist•3mo ago

https://paste.mod.gg/basic/viewer/mwphqrmsvsaf/0

BlazeBin Basic - mwphqrmsvsaf

A tool for sharing your source code with the world!

MODiX•3mo ago

leowest

REPL Result: Success

CultureInfo cultureInfo = CultureInfo.CreateSpecificCulture("en-US");
Thread.CurrentThread.CurrentCulture = cultureInfo;
var v = 1400.00m;
v.ToString("C2")

CultureInfo cultureInfo = CultureInfo.CreateSpecificCulture("en-US");
Thread.CurrentThread.CurrentCulture = cultureInfo;
var v = 1400.00m;
v.ToString("C2")

Result: string

$1,400.00

$1,400.00

Quoted by

<@1102729783969861782> from #bot-spam (click here)

Compile: 326.461ms | Execution: 44.050ms | React with ❌ to remove this embed.

leowest•3mo ago

as you can see C2 is a currency formatter, it adds the symbol so I assume your streamwriter is not using the proper encoding for it to display are you using .net framework?

Mist•3mo ago

yea on visual studio oh no sorry im just doing console app

leowest•3mo ago

try changing this

StreamWriter(fileName))

StreamWriter(fileName))

StreamWriter(fileName, Encoding.UTF8))

StreamWriter(fileName, Encoding.UTF8))

Mist•3mo ago

on visual studio

leowest•3mo ago

yes but if u right click your project in the solution explorer of visual studio and click properties does it say .net framework or .net 8

Mist•3mo ago

oh it says net framework

leowest•3mo ago

ok, try what I said above

Mist•3mo ago

will do thank you its now saying it cant convert from string to system.io.stream

leowest•3mo ago

can you show your new code

Mist•3mo ago

https://paste.mod.gg/basic/viewer/tuplkyyxevwx/0

BlazeBin Basic - tuplkyyxevwx

A tool for sharing your source code with the world!

Mist•3mo ago

this is it now

leowest•3mo ago

ah right my bad you're on .net framework it is

StreamWriter(fileName, false, Encoding.UTF8))

StreamWriter(fileName, false, Encoding.UTF8))

sorry needs to be false in your case u also need to change writer.WriteLine($"{expense.Key},\"{expense.Value:C2}\"");

Mist•3mo ago

i changed it its all worked but the remaining ballance is still messing up where it displays like this

Mist•3mo ago

https://paste.mod.gg/basic/viewer/tefvworjmsog/0

BlazeBin Basic - tefvworjmsog

A tool for sharing your source code with the world!

Mist•3mo ago

leowest•3mo ago

well yeah u'r not adding "" for the remaining and its also missing a comma

Mist•3mo ago

oh i thought i was changing it to that what you sent

leowest•3mo ago

u did but did u forgot what we talked about

leowest•3mo ago

you're not adding neither the comma nor the quotes for the remaining so how do u expect it to print right I pushed u half way u need to push your self the other half 🙂

Mist•3mo ago

i will do my best thank you for the help

Gaming

Programming

✅ Program csv extraction