how to split CSV file - C# Discussion Boards

Best way remove item from array list

28-Jul-06 1:32

You can search in google for "VirtualDub".
There is also with source code in it. But in C++.

El'Cachubrey28-Jul-06 0:50

El'Cachubrey

28-Jul-06 0:50

Hi

What is the best way for remove item from System.Collections.ArrayList (most rapid) :
Remove(object Obj) or
RemoveAt(int Index)
Confused | :confused:

Thank

stancrm28-Jul-06 0:57

28-Jul-06 0:57

What dou you mean with the "best way" ?

If you have the object, the best way is Remove(object obj);
If you have the index, the best way is Remove(int index);

gnjunge28-Jul-06 1:00

gnjunge

28-Jul-06 1:00

RemoveAt(int Index) faster, look at the following code of Remove(object Obj):

<br />
public virtual void Remove(object obj)<br />
{<br />
      int num1 = this.IndexOf(obj);<br />
      if (num1 >= 0)<br />
      {<br />
            this.RemoveAt(num1);<br />
      }<br />
}<br />

As you can see Remove(object obj) actually calls to RemoveAt(int Index)

El'Cachubrey28-Jul-06 1:45

El'Cachubrey

28-Jul-06 1:45

Thank

Ravi Bhavnani28-Jul-06 2:38

Ravi Bhavnani

28-Jul-06 2:38

RemoveAt() is safer in case the ArrayList contains duplicate objects.

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

how to split CSV file

YogeshRT27-Jul-06 23:59

YogeshRT

27-Jul-06 23:59

Hello I have a CSV file which contains matters like

"Title","First Name","Last Name","Address","City"
"Mr.","Yogee","Talokar","007,A-Wing,M.G road","Pune"
"","Radhika","Talokar","007,A-Wing,M.G road","" etc.
I wana to split it & seperate First Name,Last Name,Address,City etc,.
I tryed it by using delimiter ","
but it also split "007,A-Wing,M.G road" like
007
A-Wing
M.G road

I dont want to split "007,A-Wing,M.G road" ,bcos I have to count no. of strings.

is there is any other way to split it Like

"Yogee""Talokar""007,A-Wing,M.G road"
"Radhika""Talokar""007,A-Wing,M.G road"

-- modified at 5:59 Friday 28th July, 2006

Yogesh_T

gnjunge28-Jul-06 0:44

gnjunge

28-Jul-06 0:44

Why don't split it by ","?
Then you will have an array like:
"Mr.
Yogee
Talokar
007,A-Wing,M.G road
Pune"

Now you only have to delete the first and last " and you're finished. or if you want to add the ", you can simply add them to every one of them (except for the first and the last one) in the beginning and the end of the string.

YogeshRT28-Jul-06 0:57

YogeshRT

28-Jul-06 0:57

is there any way to split by string like ", not by char ,

Yogesh_T

gnjunge28-Jul-06 1:07

gnjunge

28-Jul-06 1:07

You can use the string.Split(string[] seperator, StringSplitOptions options) version of split. Use StringSplitOptions.None in the second parameter, and in the first parameter you put you delimiter.

stancrm28-Jul-06 0:45

28-Jul-06 0:45

You have used the wrong delimiter. That means in your text, you must write something but not delimiter. Just take another delimiter, like ";".

Re: how to split CSV file [modified]

darkelv28-Jul-06 2:54

darkelv

28-Jul-06 2:54

I use this regex:
Regex regExp = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");

YogeshRT1-Aug-06 21:54

YogeshRT

1-Aug-06 21:54

Hello Sir Its nice one ,Its working properly.
Thanks for this.
but I am unable to understand this code ,could u plz explain it or give me site referance for this.
bcoz I have a file like

"G.H.",,"","","",,,"Company Friend
Office
Lute

",,,,"Normal","False",,,"Normal"

//my code is
StreamReader r=File.OpenText(file_location);
strUserInfo = r.ReadLine();
if( strUserInfo != null)
{
Regex reg = new Regex(",(?=(?:[^\"]*\"[^\"]*\"])*(?![^\"]*\"))");
string[] split = reg.Split(strUserInfo);
//code
}

in this it read above code as 5 lines(in CSV file it seperate "notes" field) but it should be only one line,what should I do for this?

Thank you again

-- modified at 4:00 Wednesday 2nd August, 2006

Yogesh_T

Computer Impersonation

Baz27-Jul-06 23:54

Baz

27-Jul-06 23:54

Hi there - hope someone can help with this

I've read a little about impersonating users in .Net, but is it possible to impersonate a different PC?

In other words, is it possible to make it look like I am logged in on "PC 1" when actually I am logged in on "PC 2"?

Cheers!

Baz

P.S. I know this sounds kinda dodgy - but it's not at all!!! I do have a legitimate reason for wanting to know this info!!!

Re: Computer Impersonation

J4amieC28-Jul-06 0:17

J4amieC

28-Jul-06 0:17

Baz wrote:
I do have a legitimate reason for wanting to know this info

Such as?

---

How to get answers to your questions[^]

How to suppress a scroll bar

jjansen27-Jul-06 23:54

jjansen

27-Jul-06 23:54

I noticed that when the XP visual styles are on, the Panel control sometimes adds a horizontal scroll bar when it is not necessary. The controls in the Panel fit the visible area fine (including the scroll margin and vertical scroll bar). This does not happen when the visual styles are off, i.e. in the Windows classic style Dead | X|

! It doesn't matter if the AutoScroll property is set to true or false.

To fix this problem I wanted to hide the horizontal scroll bar manually. I tried to use the HScroll property. The MSDN documentation on the ScrollableControl (from which Panel is derived) class says:
"To manually override which scroll bars are visible, set the VScroll and HScroll properties. If either property is set to false, the corresponding scroll bar is not visible, even if the AutoScroll property is set to true."

This simply isn't true Mad | :mad:

. You can set the property HScroll to false, but the horizontal scroll bar is still there and remains functional. The method SetScrollState doesn't work either.

Does anyone know how I can suppress a horizontal scroll bar in a panel?
Thanks.

Re: How to suppress a scroll bar

jjansen30-Jul-06 20:38

jjansen

30-Jul-06 20:38

I still haven't been able to suppress the scroll bar. The panel totally ignores the property HScroll and other scroll bar methods Mad | :mad:

. However, I can now hide the scroll bar using the Interop function ShowScrollBar, although it doesn't prevent the scroll bar to appear briefly.

Re: How to suppress a scroll bar

amymarie318-Sep-06 10:04

amymarie3

18-Sep-06 10:04

Could I get an example of how to do this, I have never used Interop before.

invoke php script with c#

Legolas_Bilbao27-Jul-06 23:51

Legolas_Bilbao

27-Jul-06 23:51

Can i do this??, i make a pdf with php library but can i open it from c# application?,How can i do? thanks for all

Dios creo un equipo perfecto a los demas los lleno de extranjeros

How to upload video

saurabh.sharma27-Jul-06 23:50

saurabh.sharma

27-Jul-06 23:50

I want to upload video files throguh my ASP.Net application. Want to save uploaded videi files in project folder and path of video in database.

Smile | :)

Saurabh

Re: How to upload video

stancrm28-Jul-06 0:24