unformatted data

[gogaak]

hello evryone

Is there any way that I can read a customer details like name, age, sex etc...
from a .doc file and feed the data into a database directly..
all these is to be done automatically with no human intervention...

can it be done

please help

[sms_solver]

It depend upon how u have saved data in yr .doc file

but you may need to write macro for that instance

tell something more about yr .doc

[gogaak]

well thats the catch...
i just want the user to enter his personal details into a .doc or .txt file
and a computer program should take the task of trying to make sense of what is written.....
And take the information and categorize it and store it in a database ...according to the fields.. like name , age, profession etcc...
it sounds wierd ...but is there something remotely possible whic would atleast give me a 60% of the result i want..

chao


"Here comes the Age of Loneliness"

[sms_solver]

if u can become consistent then it is possible

Example

"Rajesh Kumar","Manager","20","4700"
"Amit Raj","Director","15","5200"
"Kuber","Sec","20","5200"

You you follow above pattern, then it is possible to importi in database

[gogaak]

yes, a pattern would definitely make it easier.
But to get a little out of bounds.......How do we humans make sense of anything thats written in a document....we make a meaning of it based on huge database of words and meanings we have learnt all these years.....
Also the grammar used to understand a sentence meaning....
is there is any remote possible way to make this process computerised....at least for a small extent..
we could categorise data based on their type and meaning and use algorithms to understand the grammar.....(just like we have in MS Word)...

Is it Possible!!!

[prasathvishnu]

i dont have any idea now.
but this is good thinking m8.
let me search and tell if i can

[gogaak]

Related to the above problem.....how does the MS word application is able to determine the grammar or the structure of the sentence....
is there some of sort of algorithm used for this purpose......this would be helpful



Nothing is Impossible...