Import iz velikog .txt-a u mysql - više pitanja

Code:

1000039 PONTIN drustvo s ogranicenom odgovornoscu za ribarstvo,preradu ribe, trgovinu, turizam i usluge     PONTIN D.O.O.     0600888913 1999070613Zadarska  5207 Zadar  71951 Zadar  23000Gazenicka Cesta  32 5190019950217 999

Code:
LOAD DATA INFILE 'importfile.txt'
INTO TABLE table_name
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
(field1, filed2, field3, ...)

Code:

... usluge     PONTIN D.O.O.     0600888913...

Code:

0600888913 1999070613Zadarska  5207 Zadar  71951 Zadar  23000Gazenicka Cesta  32 5190019950217 999

Code:

preg_match('#[\d]+#', $NoviNiz[$i], $matches); // Gde  je $i = 1 ili 6
//$matches[0]; // Brojevi koji ti trebaju
preg_match('#[A-Za-z]+#', $polja_1[$i], $matches1); // Gde  je $i = 1 ili 6
//$matches1[0]; // Slova ....

Code:

0 => 1000039 
1 => PONTIN drustvo s ogranicenom odgovornoscu za ribarstvo,preradu ribe, trgovinu, turizam i usluge
2 => PONTIN D.O.O.
3 => 0600888913
4 => 1999070613
5 => Zadarska
6 => 5207
7 => Zadar
8 => 71951
9 => Zadar
10 => 23000
11 => Gazenicka
12 => Cesta
13 => 32
14 => 5190019950217
15 => 999

Code:

1000039 PONTIN društvo s ograničenom odgovornošću za ribarstvo,preradu ribe, trgovinu, turizam i usluge                                                                                                                                                                PONTIN D.O.O.                                                                                                                                   0600888913 1999070613Zadarska                                          5207 Zadar                                             71951 Zadar                                             23000Gaženička Cesta                                   32      5190019950217                    999
1000101 B I R O M A  D.O.O. ZA TRGOVINU UREDSKOM OPREMOM I KANCELARIJSKIM MATERIJALOM                                                                                                                                                                                  B I R O M A  D.O.O.                                                                                                                             080295620  1999052722Grad Zagreb                                       1333 Grad Zagreb                                       72150 Zagreb                                            10000ČIKOŠEVA                                            8     5248119950213                    999
1000217 OPORTUN d.o.o. za informatiku i trgovinu                                                                                                                                                                                                                       OPORTUN d.o.o.                                                                                                                                  0700381833 199902185 Varaždinska                                       2895 Novi Marof                                        46442 Paka                                              42220Paka                                               16     7222019950213                    999
1000241 PERFETA D.O.O. ZA UNUTARNJU I VANJSKU TRGOVINU, ZASTUPANJE I POSREDOVANJE                                                                                                                                                                                      PERFETA D.O.O.                                                                                                                                  040088309  199709038 Primorsko-goranska                                3735 Rijeka                                            55174 Rijeka                                            51000KAMPANJA                                           21     5190019950217                    999
1000250 JERKUNICA, društvo s ograničenom odgovornošću za računovodstvene poslove, trgovinu i turizam                                                                                                                                                                   JERKUNICA d.o.o.                                                                                                                                0600905491 1998010917Splitsko-dalmatinska                              4090 Split                                             59200 Split                                             21000Table                                              10     7412019950217318673    318673    999
1000268 UNISOFT D.O.O. ZA INFORMATIČKI INŽENJERING                                                                                                                                                                                                                     UNISOFT D.O.O.                                                                                                                                  040094970  1997100718Istarska                                          4685 Umag                                              66761 Umag                                              52470VLADIMIRA NAZORA                                    5     7222019950217                    999
1000420 PREMIK društvo s ograničenom odgovornošću za trgovinu, graditeljstvo i ugostiteljstvo                                                                                                                                                                          PREMIK d.o.o.                                                                                                                                   0801854972 200007031 Zagrebačka                                        345  Brdovec                                           25976 Javorje                                           10291Nova ulica                                        19      5190019950213                    999
1000438 TERNO društvo s ograničenom odgovornošću za građevinarstvo i usluge                                                                                                                                                                                            TERNO d. o. o.                                                                                                                                  08128328 2 199804171 Zagrebačka                                        3620 Pušća                                             15512 Dubrava Pušćanska                                 10294Dubrovačka Cesta                                  49      4521119950213                    999
1000454 JAGER D.O.O. ZA TRGOVINU I UGOSTITELJSTVO                                                                                                                                                                                                                      JAGER D.O.O.                                                                                                                                    040104006  199803028 Primorsko-goranska                                3735 Rijeka                                            55174 Rijeka                                            51000RADIĆEVA                                           14     5190019950213                    999
1000489 MADENA društvo s ograničenom odgovornošću za trgovinu i usluge                                                                                                                                                                                                 MADENA d. o. o.                                                                                                                                 0400203444 200010048 Primorsko-goranska                                3735 Rijeka                                            55174 Rijeka                                            51000Janka Polića Kamova                               101     5190019950213450099    450200    999
1000560 GO - MO, D.O.O. ZA UGOSTITELJSTVO,TURIZAM I TRGOVINU                                                                                                                                                                                                           GO - MO, D.O.O.                                                                                                                                 040043892  1997011618Istarska                                          4685 Umag                                              66761 Umag                                              52470MATTEA BENUSSIA                                     1     5540019950216                    999
1000586 LITUS, društvo s ograničenom odgovornošću za proizvodnju, trgovinu i usluge                                                                                                                                                                                    LITUS, d.o.o.                                                                                                                                   0601255692 1999060518Istarska                                          3484 Poreč                                             50849 Poreč                                             52440Pulska                                            9       5190019950213434603    434603    999
1000632 NEAPOLIS, društvo s ograničenom odgovornošću za projektiranje, gradnju, upravljanje, prodaju i iznajmljivanje objekata, turizam, trgovina i export-import                                                                                                      NEAPOLIS  d.o.o.                                                                                                                                0400915408 2004021618Istarska                                          2917 Novigrad                                          43982 Novigrad                                          52466Ulica Gradska Vrata                                29     7420019950216                    999
1000675 PRAGMA društvo s ograničenom odgovornošću za poslovne usluge                                                                                                                                                                                                   PRAGMA d.o.o.                                                                                                                                   04006197 3 200003208 Primorsko-goranska                                3735 Rijeka                                            55174 Rijeka                                            51000Bačvarska                                         1       4532019950214                    999
1000713 VIZUAL d.o.o. za trgovinu i usluge                                                                                                                                                                                                                             VIZUAL d.o.o.                                                                                                                                   0300181282 2004022014Osječko-baranjska                                 3123 Osijek                                            45691 Osijek                                            31000Stjepana Radića                                   32      5190019950213                    999
1000756 ŽE-PA, D.O.O. ZA PROIZVODNJU, TRGOVINU, UGOSTITELJSTVO I USLUGE                                                                                                                                                                                                ŽE-PA, D.O.O.                                                                                                                                   020019744  199611289 Ličko-senjska                                     3131 Otočac                                            46094 Otočac                                            53220KRALJA ZVONIMIRA                                   95     6024019950215                    999
1000853 COMMERCE KLJAJIĆ D.O.O.ZA IZGRADNJU, TRGOVINU, USLUGE I UVOZ-IZVOZ                                                                                                                                                                                             COMMERCE KLJAJIĆ D.O.O.                                                                                                                         050018602  1996050912Brodsko-posavska                                  108  Bebrina                                           72982 Zbjeg                                             35254                                                      bb  4521119950216                    999
1000870 URKA d.o.o. za trgovinu, turizam i usluge.                                                                                                                                                                                                                     URKA d.o.o.                                                                                                                                     0600270103 2005060719Dubrovačko-neretvanska                            981  Dubrovnik                                         15709 Dubrovnik                                         20000Andrije Hebranga                                   33     5190019950214                    999
1000993 EGMOND proizvodnja i promet robom, d.o.o.                                                                                                                                                                                                                      EGMOND d.o.o.                                                                                                                                   0400816193 199910298 Primorsko-goranska                                698  Delnice                                           10634 Delnice                                           51300Kamenita                                          7       3110019950213812520    812520    999
1001019 MAKROSISTEM - INŽINJERING društvo s ograničenom odgovornošću za proizvodnju, unutrašnju i vanjsku trgovinu i usluge                                                                                                                                            MAKROSISTEM - INŽINJERING d.o.o.                                                                                                                0802794961 1999031122Grad Zagreb                                       1333 Grad Zagreb                                       72150 Zagreb                                            10000Male Putine broj 2                                        7222019950213                    999
1001027 MARLES KUĆE  građevinarstvo, trgovina i usluge d.o.o.                                                                                                                                                                                                          MARLES KUĆE d.o.o.                                                                                                                              0600335904 2001010822Grad Zagreb                                       1333 Grad Zagreb                                       72150 Zagreb                                            10000Zrinjevac                                         16      4521119950213