Skip to content
Home » unix – merging of csv information has modified the date format of date column

unix – merging of csv information has modified the date format of date column


I’m utilizing a under script to mix a number of information into one.

awk '(NR == 1) || (FNR > 1)' InterfaceStatistics*.csv > /dwelling/vikrant_singh_rana/nfv/merge/InterfaceStatistics_merge_file.csv

information are getting merged however the date format is being modified.. see column collectTime

circle,collectTime,merchandise,collint,beginTime,period,endTime,ifIn
Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE
Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE
Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE
Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE
Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE
Malaysia,20240519131607,PLMN-PLMN/CBIS-A0110PEXP12/COMPUTE


circle,collectTime,merchandise,collint,beginTime,period,endTime,ifIn
Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE
Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE
Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE
Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE
Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE
Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP12/COMPUTE
Malaysia,2.02405E+13,PLMN-PLMN/CBIS-A0112PEXP15/COMPUTE

Searching for some assist to maintain the date column format intact.

I’m operating this script on cloud shell atmosphere.

Leave a Reply

Your email address will not be published. Required fields are marked *