Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: tushar
  Where is tushar?
 Panaji
 India
 tushar
 To: mike N
  Where is mike N?
 Balt
 Maryland - United States
 mike N
 Tags
Subject: RE: Visual Foxpro .CSV code help needed.
Thread ID: 210129 Message ID: 210148 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Saturday, January 03, 2009 4:59:49 PM         
   


Is the figure you are showing of the CSV file as it looks in notepad , or as it looks when opened in Excel?

I am assuming that its a CSV with no header. So you can load it with

lcStr=FILETOSTR(YourFileName)
*Add a headline
lcStr="a,b,c"+chr(13)+chr(10)+lcStr
*Create a temp csv file 
STRTOFILE(lcStr,'temp.csv')

and then use the code Anders has given you

Regards
Tushar
>
> Sub ok()
> Dim a As Range
> Dim rng As Range
>
> Set rng = Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp))
> For Each a In rng
> If a.Value = "0125" And a.Offset(0, 1).Value = "FDC" Then
> a.Offset(0, 1).Value = "IDC"
> End If
> Next
> End Sub
>
> Thank you, Thank you



COMPLETE THREAD
Visual Foxpro .CSV code help needed. Posted by mike N @ 1/3/2009 2:35:59 PM
RE: Visual Foxpro .CSV code help needed. Posted by Anders Altberg @ 1/3/2009 3:21:29 PM
RE: Visual Foxpro .CSV code help needed. Posted by Cetin Basoz @ 1/3/2009 3:33:23 PM
RE: Visual Foxpro .CSV code help needed. Posted by mike N @ 1/3/2009 4:37:31 PM
RE: Visual Foxpro .CSV code help needed. Posted by mike N @ 1/3/2009 4:41:39 PM
RE: Visual Foxpro .CSV code help needed. Posted by Cetin Basoz @ 1/3/2009 5:22:19 PM
RE: Visual Foxpro .CSV code help needed. Posted by mike N @ 1/3/2009 8:02:06 PM
RE: Visual Foxpro .CSV code help needed. Posted by Anders Altberg @ 1/3/2009 8:22:47 PM
RE: Visual Foxpro .CSV code help needed. Posted by Cetin Basoz @ 1/3/2009 10:08:08 PM
RE: Visual Foxpro .CSV code help needed. Posted by mike N @ 1/7/2009 8:57:19 PM
RE: Visual Foxpro .CSV code help needed. Posted by Cetin Basoz @ 1/8/2009 1:52:17 AM
RE: Visual Foxpro .CSV code help needed. Posted by tushar @ 1/3/2009 4:59:49 PM