Child pages
  • NSF format (.nsf)

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


When an NSF csv file is read, the following actions are performed:

Code Block

Convert NSF file into a table
Remove Marks NSF file as "pre-2014" or "current" depending on format of headers
Handle duplicate columns
Replace '\"' with '""' (more standard method of escaping quotes in csv files)
Normalize CO-PI column (makehandle themexcessive |spaces separated)
Normalize Primary PI column (make it looks like CO-PI format)
in names)
If it is a "current" format NSF:
	Normalize dollar amounts (go from strings to floats)
Else if it is a "pre-2014" format NSF:
	Normalize PI names (put it in "first name first" format with no comma
Create "All Investigators" Column (merge CO-PI and Primary PI column)