Sage 100

What's a quick and dirty way to VI into the IM1 file to blank out Category 1 when there's already data in Category 1? I know I could import a value like ""x"" -- but I would ideally like to wipe out the field to leave it blank. There are 18,000 so I can't go one by one.

Looks like if I do a Replace and point to a field that doesn't exist -- such as column 10 in a two column CSV that this is doing the trick.

I believe there is an option not to skip blank field. you can import 10 spaces with an assign.

Thanks that worked