You need to sign in to do that
Don't have an account?
SANKAR N
Salesforce reports Scheduled using Java, decimal field from event object csv separator issue.
Hi,
I wrote java program to send email with salesforce report csv attachment. the salesforce report generate using activity object and have one of field Duration in hours.
Everything working fine. But, the attached csv file Duration field column values like "25,0000"(Comman separator) instead of "25.000"(Dot). if I export from salesforce the separator shows as .(dot) but in csv attachment the value is ,(comman).
it is very difficult to delimit based on separator (comma) into excel file.
Any idea,how to fix this issue ? Thanks in advance.
I wrote java program to send email with salesforce report csv attachment. the salesforce report generate using activity object and have one of field Duration in hours.
Everything working fine. But, the attached csv file Duration field column values like "25,0000"(Comman separator) instead of "25.000"(Dot). if I export from salesforce the separator shows as .(dot) but in csv attachment the value is ,(comman).
it is very difficult to delimit based on separator (comma) into excel file.
Any idea,how to fix this issue ? Thanks in advance.
gsmithfarmer
I suspect thatt this is locale setting issue for the SFDC account being used.