Hi
I am quite new to this so please bear with.
I am bringing in a .csv file into a Collection for input into an application.
One of the columns (Unit Price) is in a format using a dot seperator eg. 2.16. The application requires this data to use a comma seperator i.e. 2,16.
How do I convert the data in the collection to a comma seperator?
Where in the process would I have to do the conversion? Before passing the data to the Collection or before writing the data into the application.
Please help.
I am quite new to this so please bear with.
I am bringing in a .csv file into a Collection for input into an application.
One of the columns (Unit Price) is in a format using a dot seperator eg. 2.16. The application requires this data to use a comma seperator i.e. 2,16.
How do I convert the data in the collection to a comma seperator?
Where in the process would I have to do the conversion? Before passing the data to the Collection or before writing the data into the application.
Please help.