suggestion on best practice to scrub an import.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

suggestion on best practice to scrub an import.

BJ Freeman
thinking out loud about the best flexible structure to scrub an import file.

for instance the Description has <ul> and </ul>
now a regex and string replace works fine to do these.
Now say you have a list of different things you want to scrub/replace

so would a properties file be best, or some other structure?
I was thinking along he lines of the lanquage xml idea

file name (would match the import file name)
allow wildcard in file name (allow Myfile*.csv)
scrub
  regex
  regex
/scrub
replace
  regex
  newstring
or
  oldstring
  newstring
/replace

hope that is clear enough without the xml format.