Hello,
I need to upload a text file with seven columns into my database which i have already finished but the problem is my text file has whitespaces between each column for which i have separeted using a tab.Since my text file cannot be changed manually everytime i upload the file, i need to terminate the columns by just specifying the white space between columns while uploading!Can anyone can me in finding the solution for this!
I am even sending my text file with only few columns .
01:33:49:90:02:92 ON 533698 3835311 2277479 3530766 6714043
01:33:49:90:07:40 OFF 778681 93056 742644 612857 10178599
01:41:30:00:05:85 ON 2243539 17600529 15190881 32434234 34223444
Can anyone please help me with a solution1
Well Thanks in advance!
Sandhya
I need to upload a text file with seven columns into my database which i have already finished but the problem is my text file has whitespaces between each column for which i have separeted using a tab.Since my text file cannot be changed manually everytime i upload the file, i need to terminate the columns by just specifying the white space between columns while uploading!Can anyone can me in finding the solution for this!
I am even sending my text file with only few columns .
01:33:49:90:02:92 ON 533698 3835311 2277479 3530766 6714043
01:33:49:90:07:40 OFF 778681 93056 742644 612857 10178599
01:41:30:00:05:85 ON 2243539 17600529 15190881 32434234 34223444
Can anyone please help me with a solution1
Well Thanks in advance!
Sandhya