Re: [R] Data Cleaning -New user coming from SAS

2012-11-29 Thread arun
  Tata Espr 10/26/2007 Advance: Principal A.K. - Original Message - From: arum To: r-help@r-project.org Cc: Sent: Thursday, November 29, 2012 3:25 PM Subject: [R] Data Cleaning -New user coming from SAS Hello, this is my first post. I have a large CSV file where I need to fill in the 1

Re: [R] Data Cleaning -New user coming from SAS

2012-11-29 Thread Jean V Adams
Other readers of this list may have better suggestions for how to read in data with interspersed header rows, but here's a work-around to do specifically what you requested ... # find the rows where "Loan" is in the Date column sel <- grep("Loan", dat$Date) # create a new vector with these row

[R] Data Cleaning -New user coming from SAS

2012-11-29 Thread arum
Hello, this is my first post. I have a large CSV file where I need to fill in the 1st and 2nd column with a Loan # and Account name that would be found in a line of text : like this: ,,Loan #:,ML-113-07,Account Name:, Quilting Boutique,,, I would like to place the Loan #: ML-113-07 in the f