Hello,
I have been following the description of the exercise but I can't get the same result in my import data, for the fields to match. I have changed in control panel my setting in "Region" to "list separator" with a comma, but I can't see where I could do this format:
1,234,567.89 - my "Digit Grouping" does not give me this option.
and I have my advanced option activated on excel for the "use system separator"
Would anyone know? I am stock on this exercise.
exercise:
Hi ,
This are consideration while importing data from CSV file in salesforce.
https://help.salesforce.com/articleView?id=000313396&type=1&mode=1
https://help.salesforce.com/articleView?id=000331030&type=1&mode=1Most probably your excel setting changes the delimiter to semi-colon (;) instead of comma (,). To resolve this issue:
- Go to your file and right click on it.
- Select Open with and select notepad
- Once the file open in notepad, click on the Edit Tab.
- Select replace
- On the "Find what" field enter the value (;) semi-colon
- On the "Replace with" field enter the value (,) comma
- Click on the Replace all button.
- Save the file and add the .CSV on the end of the file name. Once done with the last step, don't open again the save file on excel. This will ensure that the delimiter of the file is save as comma delimited. The file should be good for import. Please let me know if this answer your query or you can mark it as solved.
https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007T45bySAB
