Populating Created Ms sql server management studio data with text file with no field name
Dear Axel, Thank you so much for your valuable help. This information does helps a lot for sure. Will try that and let you know how it went. Best of regards, Paul El jun 2, 2014 4:06 AM, "Axel Klenk" <axel.klenk at actelion.com> escribi??:
Dear Paul, if I had to do that, I would look at function read.fwf() for importing your fixed width formatted text file and at package RODBC for connecting to your database (or function write.csv() for exporting as a CSV file). Hope this helps, - axel On Fri, May 30, 2014 at 4:40 PM, Paul Bernal <paulbernal07 at gmail.com> wrote:
Hello everyone,
I have a text file which has no field name, however, I have a document
that
says how the fields are sepparated (for example, field ship number goes
from position 1 to position 5, field vessel name goes from position 7 to
position 15, and so on).
I need to populate already created tables (contained in microsoft sql
server management studio) with the data contained in this text file .
Either that or convert that text file into a csv file so that it can be
read in easily.
Does R has a function that helps doing this or is there a way that R can
help? What options do I have?
Best regards,
Paul
[[alternative HTML version deleted]]
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
-- Axel Klenk Research Informatician Information Management Drug Discovery Actelion Pharmaceuticals Ltd. ??? Gewerbestrasse 16 ??? CH-4123 Allschwil ??? Switzerland H91.O1.W01.2 axel.klenk at actelion.com ??? www.actelion.com Address for visitors: Hegenheimermattweg 91 The information of this email and in any file transmitted with it is strictly confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any copying, distribution or any other use of this email is prohibited and may be unlawful. In such case, you should please notify the sender immediately and destroy this email. The content of this email is not legally binding unless confirmed by letter. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorised to state them to be the views of the sender's company. For further information about Actelion please see our website at http://www.actelion.com