Dear Community,
I Have a csv file with no timestamp with the data, I only have a timestamp on the beggining of the file (Line 3). So, How do I capture the date on line 3 of a csv file, while the header fields begin on line 5 and following data begins on line 6?
See the data as follow:
CHILLER_01
slot:/Drivers/NiagaraNetwork/TA_WEB2_CAG/points/ARQUITETURA/POC$2dCHILLERS/CHILLER_01
02-Jun-20 2:55 PM BRT
?NOME DO PONTO,VALOR
"ALARME,""0.00"""
"CAP_TOTAL,""0.00"""
"CAP_TOTAL_A,""0.00"""
"CAP_TOTAL_B,""0.00"""
SEDCMD-headertrim=s/(?ms).*VALOR//
if header is fixed, try SEDCMD and EXTRACT with props.conf
Header is fixed.
Thanks....I am not really good with SEDCMD. I would really appreciate if you could provide the step by step procedure.
Thanks in Advance