How to remove characters from an excel cell in C#?

[samiarja]

I am developing an application that use SFTP to download files from a remote server to a local server, these files are then converted to .csv format which is readable by ealge.io platform.

However I found out that in one of the csv columns there is a character that need to be deleted to make the file readable.

There is a T in the middle of the time cell, this T need to be deleted to suit this format YYYY-MM-DD HH:mm:ss instead of this YYYY-MM-DDTHH:mm:ss as per eagle.io requirements. Below is the sample data from the csv data.

Local_Time
2000-03-05T03:00:59
2000-03-05T03:01:08
2000-03-05T03:01:59
2000-03-05T03:02:59
2000-03-05T03:03:59
2000-03-05T03:04:53

This is how it should be:

Local_Time
2000-03-05 03:01:00
2000-03-05 03:01:08
2000-03-05 03:01:59
2000-03-05 03:03:00
2000-03-05 03:04:00
2000-03-05 03:04:54



How to do this directly from C#?

Continue reading...