Hi team,
Please help me on this
I am using this code to convert multiple columns genral format to Number but some of the values are getting ##### hash values
Hi @anilkumar_raj ,
You can use the format cells activity . Hope the attached documentation url helps you learn more about the activity.
Try comfiguring this activity as per your need.
Hope this helps.
Thanks,
Gautham
@anilkumar_raj Can you share the excel file, or the screenshot? if it is confidential then dummy data.
Regards,
Ajay Mishra
What are those numbers exactly getting ####. I will try to recreate the issue.
Thanks,
Ashok 
Actually it’s genral amount values in 2 columns.
Once downloaded the file from application I have to convert 3 column values from genral to number format and then save .CSV file.
While converting to number format getting hashes instead of amount values.
I have checked clearly it’s genral format only.
Yes I tried but no luck
Yes it’s a confidential banking data please check the screenshot
@anilkumar_raj It is a csv file? then try to open it from Notepad Application. Is the values are able to get there?
Share a screenshot if possible!
Regards,
Ajay Mishra
It’s clearly file format behavior. Whenever you have a file in .csv it contains raw data (comma separated values/text ) no formatting attached but, here you are trying to attach format to it and save it back to .csv which is not the right way or I would say the problem.
Once you open any csv with excel, excel modifies raw data of the csv file to look it prettier in excel and if you save this csv even without any change, the original csv never will be the original anymore.
Solution:
- Use Read CSV activity to read data untouched or raw into DataTable
- Use LINQ query to Round the amount column as per your business logic. Here is sample thread for doing this. Linq to math round 3 decimals column of string
- Write back the Amount format updated DataTable back to same CSV or different as per your requirement.
Hope this would be helpful.
Thanks,
Ashok
No it’s a zip files…once unzipped it will create to .xls files
Open .xls files and convert general format to number
No it’s a zip files…once unzipped it will create to .xls files
Open .xls files and convert general format to number
Anyone can please help