Correct file number values of untouched submission CSV

department-of-veterans-affairs / va.gov-team

Public resources for building on and in support of VA.gov. Visit complete Knowledge Hub:

https://depo-platform-documentation.scrollhelp.site/index.html

281 stars 197 forks source link

Correct file number values of untouched submission CSV #84153

Closed freeheeling closed 3 months ago

freeheeling commented 3 months ago

Emily reported on 5/28 that all the leading 0s were dropped from the File number/SSNs in the provided signed link CSV of untouched submission work. The column needs to be reformatted to include any leading 0s and resent to Emily.

freeheeling commented 3 months ago

Created a formula to prepend the appropriate number of 0s for any file_number field to ultimately contain exactly 9 digits, replacing the initial values with the result of the executed formula.

Sent modified Excel sheet to Emily.

lisacapaccioli commented 3 months ago

@freeheeling Is this still in progress or should it be considered completed since you sent the Excel per the description?

freeheeling commented 3 months ago

@lisacapaccioli This appears in the "Done in sprint :)" pipeline on my board. Work is complete.