erc Also der Screenshot sieht nicht nach fixed-length bezüglich der Namen aus ... oder die Namen sind ein wüstes Datenagglomerat ...
PS
SUBSTR(@raw,1,24)
PS
SUBSTR(@raw,1,24)
<?php
LOAD DATA LOCAL INFILE '//ntserver1/bde/Mobatime/JBMv5/Data/PTG/Pip-TXT.TXT' INTO TABLE mobatime
(@raw)
SET
Name=TRIM(SUBSTR(@raw,1,23))
Anwesend=IF(TRIM(SUBSTR(@raw,24,26) != "", 1, 0))
?>
LOAD DATA LOCAL INFILE '//ntserver1/bde/Mobatime/JBMv5/Data/PTG/Pip-TXT.JBM' INTO TABLE mobatime
(@raw)
SET
Name=TRIM(SUBSTR(@raw,1,23))
Anwesend=IF(TRIM(SUBSTR(@raw,24,26)) != "", 1, 0)
Anwesend = IF( TRIM( SUBSTR(@raw, 24, 26) ) != "", 1, 0 )
LOAD DATA LOCAL INFILE '//ntserver1/bde/Mobatime/JBMv5/Data/PTG/Pip-TXT.JBM' INTO TABLE mobatime
(@raw)
SET
Name=TRIM(SUBSTR(@raw,1,23)),
Anwesend=IF(TRIM(SUBSTR(@raw,24,26)) != "", 1, 0)
TRUNCATE TABLE mobatime;
LOAD DATA LOCAL INFILE '//ntserver1/bde/Mobatime/JBMv5/Data/PTG/Pip-TXT.JBM' INTO TABLE mobatime
(@raw)
SET
Name=TRIM(SUBSTR(@raw,1,23)),
Anwesend=IF(TRIM(SUBSTR(@raw,24,26)) != "", 1, 0)
Kommentar