Hi All
Please help me out :-
How to read blank spaces while converting a CSV file to a Datatable.
When I try to convert a CSV file to a Data Table, it converts but if some
columns are blank, then they shift to the next position and Data Table doen
not come with proper positioning.
The Regex I am using is given below :
Regex re = new
Regex("((?<field>[^\",\\r\\n]+)|\"(?<field>([^\"]|\"\")+)\")(,|(?<rowbreak>\\r\\n|\\n|$))");
Thanks
Sandy
PvdG42 - 10 Jan 2008 12:49 GMT
> Hi All
>
[quoted text clipped - 13 lines]
>
> Sandy
This group is nor frequented by many regex gurus, so if you want answers I
suggest you post in an applicable .NET language group. There are no
Microsoft public groups dedicated to regular expressions, so try:
microsoft.public.dotnet.languages.csharp
or
microsoft.public.dotnet.languages.vb
Another possibility, as you're working with a Datatable:
microsoft.public.dotnet.framework.adonet