Hi,
I have a problem extracting data from my text file.
The file looks like this:
******************************************
#Textlimiter=;
#Decimalsign=.
#Provadm
Column1, Column2...ColumnX;
"Value1";"Value2"...""ValueX";
"Value3";""Value4"..."ValueY";
#Provdat
ColumnA, ColumnB...ColumnZ;
"ValueXX","ValueYY"..."Value11";
"ValueQQ","ValueRR"..."Value22";
#End
******************************
The ProvAdm-section can contain one or more rows
The ProvDat section can also conrtain one or more rows
I want to read ProvAdm section into one table (SQL Server) and ProvDat into one table (SQL Server) but I dont reaaly understand how to find out where ProvAdm section ends (how many rows should be read) or where ProvData starts (where should I start reading)
An additional dimension to the problem is that I need to read multiple files at one go...
Perhaps my explanation is not complete but please ask and I will try to explain a little more 🙂
//Magnus