General information
Category:
Coding, syntax & commands
Don't know whether this is any help but here is some code i came across that seaches string in cvs, you might be able to adapt it.
k
cFile = Filetostr("C:\myfile.CSV") && Read file
For i = 0 To 32 && Loop through control characters
IF INLIST(i,10,13) && Skip Line Feed and Carriage Return
LOOP
ENDIF
cFile = Strtran(cFile,Chr(34),"") && Replace " ntrol Characters with Empty
cFile = Strtran(cFile,Chr(61),"") && Replace = ntrol Characters with Empty
cFile = Strtran(cFile,Chr(150),"") && Replace - ntrol Characters with Empty
cFile = STRTRAN(cFile,CHR(i),"") && reokace variabe i (Integer character) with empty
Endfor
= Strtofile(cFile,"C:\myfileCLEAN.CSV") && Convert back to file
*************************************************************************************************
APPEND CLEAN FILE INTO DATABASE
Use newdatabase
Zap
Append From c:\myfileclean.Csv Type Delimited
Locate &&go top
Delete &&delete headings
pack
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only