hi people i have a problem
i have a text file that is padded into columns using white spaces
i want to know how can i define the delimiter in the
DataSet ds = TextToDataSet.Convert("c:\test.txt", "MyNewTable", "????????")
so that the delimiter takes all the white spaces between the columns as a delimiter
the problem now is the white spaces isn't all the same amount of spaces
every row in the file has different amount of spaces
can anyone assist me please
the ?????? is what i1m looking for the \t doesn't work the "\s*" doesn't work tried to create a regex but doesn't work either?
i need a delimiter to ignore all the white spaces between data
and the amount of white spaces aren't the same in each row row one has like lets say 5 and row 2 has like 10 or 20 between the data so now i need to know how to define that delimiter so that it uses any amount of white spaces as the delimiter?