Proseries 2021 Hombase View export to csv has bug

[lefty]

The format of the .csv file exported by Homebase->Export View is incorrect.

The correct format for csv is:

field1,field2,field3 

Not 

field1, filed2, field3

The space is critical and is therefore a bug. Anyone who knows the basics of csv format know why this doesn't work. 

space and double quote are both delimiters

The problem arises when  you try to dump Client Street and Apt Address

This field contains a comma that is escaped with double quotes "101 Main St, Apt 1"

The problem is that the csv written as such with space comma double quote will read in as

Col1                Col2

"101 Main St   Apt 1"

The solution is to use notepad to search and replace

Search: space comma double quote 

Replace: comma double quote

This is not an Excel issue. I tried Libreoffice as well and neither can read the current .csv format that PS21 is writing.

INTUIT PLEASE FIX THIS BUG. 

[IntuitAngela_13]

@lefty Thank you for making us aware of this issue. 

I will report this issue to our engineering team.

[IntuitAngela_13]

@lefty This issue has been resolved in today's program update.