Hi all, I’m currently reading a csv file which has a title page in the first two rows. I’m using the assign and AsEnumerable function to skip the title page and read in the data. The data contains 57 columns where four of the columns are string dates in (“MM/dd/yyyy hh:mm:ss”) format. I need to cha…

@jose.a.silvestre - In that case, you have to handle the empty rows first…by removing it… Once datatable in cleaned up you can use the above invoke code… [image] Remove Empty Rows From DataTable Help Hi @Joshikumarav , Use this code DataTableName=DataTableName.Rows.Cast…

Reading large csv file and need to change the date formats on output

Help Studio

prasath17 (Guru) March 30, 2021, 6:46pm 6

@jose.a.silvestre - In that case, you have to handle the empty rows first…by removing it…

Once datatable in cleaned up you can use the above invoke code…

Topic		Replies	Views
Change data column date format Academy Feedback datatable , activities , question , lp_developer_fnd	7	1948	January 25, 2021
Change format column from "General" to "Date" Studio studio , question , activities_panel	12	2942	July 31, 2021
How to replace date format quickly for two columns in data table variable? Something Else feedback	26	516	June 10, 2023
Problem Changing Date Format Help studio , question	5	1014	January 14, 2021
Date Format Conversion in Linq Studio studio , question , activities_panel	6	3313	December 12, 2022

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Reading large csv file and need to change the date formats on output

Related Topics