KTiger

May I ask what the numbers in parameter 2 is, and does it require to have 11 numbers?
Albert ferrer,00000000003,albert@tm.com.my

I would recommend for parameters that are string to use "-char (or another split-char), like this:
"Albert ferrer",3,"albert@tm.com.my"

__________________
To sell your own books it's like selling a piece of your soul. Kim

pastalover

yes,it have 11 numbers

pastalover

yes,it have 11 numbers.how to do that?

pastalover

DaWei,
the problem is after all i need to load all the data into server..the server can only read the data (.txt file) which is in arrange position

DaWei

I would question the accuracy of that statement, but you may be correct. The server may be poorly designed or written. It's unlikely that it needs to perform multitudinous seeks here and there for a file such as you show.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

jim mcnamara

if you access to awk

nindoja

I think you misunderstand how the server is reading data in. If you were to print a tab character between each parameter, the data base should read it in fine. Databases tend to read in tab-delimeted files, which is how they determine where the data is split.