Hello,
I made a reports with some data for DB 1 which i want to import in DB 2.
For importing the data in DB 2 we use a .csv file with a fixed protocol
for example:
"I";84860;"KALKOENROLLADE GEG 45 GR HAL B"; 2; 2; 2
"I";82886;"KIPPENJUS B "; 67; 70; 74
"I";83222;"SPRUITJES B "; 190; 200; 210
"I";83021;"AARDAPPELEN GEK B "; 238; 250; 263
When i export the data from DB 1with CR as an CSV file the positions jump everytime and it doesn't corresponds to the protocol
for example
"I";84860;"KALKOENROLLADE GEG 45 GR HAL B";2;2;2
"I";82886;"KIPPENJUS B";67;70; 74
"I";83222;"SPRUITJES B";190;200;210
"I";83021;"AARDAPPELEN GEK B";238;250;263
Does someone know how to define the lengt of a field? So the length of a field will be always the same (string and number) and when the results is shorter it wil be filled with space
thnx