Hi All,
My sample data from csv file is as below, I am reading csv file and writing to excel, but " not getting removed, however, I pasting same to data in excel and just spiting (text to column) by '^', excel is not showing any " character.
script output
My sample data from csv file is as below, I am reading csv file and writing to excel, but " not getting removed, however, I pasting same to data in excel and just spiting (text to column) by '^', excel is not showing any " character.
from openpyxl import Workbook import csv import re lines = [] wb = Workbook() ws = wb.active with open('netcool.csv', 'r') as csvfile: data = csv.reader(csvfile, delimiter='^', quotechar='|') for row in data: #row = re.sub('"', '', row) print((row)) ws.append(row) wb.save('netcool.xlsx')sample data
Quote:IDENTIFIER^LASTOCCURRENCE^ALERTGROUP^FMS_OFF_TIME^FMS_ON_TIME^NODE^NE_ON_TIME^NE_OFF_TIME^REGION^CIRCLE^CITY^ALERT_NAME^ALERT_COUNT^MANAGER^TECHNOLOGY^ALARM_CATEGORY^EQUIPMENT_TYPE^CLEARED_BY^CLEAREDTIME_TEXT^OPERATOR^TTNUMBER^TT_STATUS^LOCATIONID^AMO^ACKNOWLEDGED^FRIENDLY_NAME^SEVERITY^SERIAL^SUMMARY
"UE62-LUC_TP_Nagar_Card=r01sr1sl09_PTP=02_DEGRADED_SIGNAL-MsTTP^""2019-03-28-16.14.09.000000""^""AlarmClear""^""1970-01-01-05.30.00.000000""^""2019-03-28-16.14.09.000000""^""UE62-LUC_TP_Nagar""^""2019-03-28-16.14.24.000000""^""1970-01-01-05.30.00.000000""^""""^""""^""""^""DEGRADED_SIGNAL-MsTTP""^319^""UP_LUCK_IOO_FM""^""TXN_ALCATEL_NM""^""""^""""^""""^""""^""OSPUN185""^""11551840""^""""^""""^""UE62-LUC_TP_Nagar_Card=r01sr1sl09_PTP=02""^1^""UE62-LUC_TP_Nagar""^3^13215461^""000:"""
"OR62_ANG_HINDOL_RD_Card=r01sr1sl15_PTP=01_LOSS_OF_SIGNAL-OpS^""2019-03-28-12.21.35.000000""^""AlarmRaise""^""2019-03-28-16.27.49.000000""^""2019-03-28-12.21.35.000000""^""OR62_ANG_HINDOL_RD""^""2019-03-28-12.21.19.000000""^""2019-03-28-16.27.48.000000""^""EAST""^""ORISSA""^""DHENKANAL""^""LOSS_OF_SIGNAL-OpS""^72^""NULL""^""TXN_ALCATEL_NM""^""COMMUNICATIONSALARM""^""SDH""^""""^""""^""BA80542248""^""11477261""^""RESOLVED""^""ORCUTDHE1450VI0003""^""OR62_ANG_HINDOL_RD_Card=r01sr1sl15_PTP=01""^1^""OR62_ANG_HINDOL_RD""^0^2118297644^""No Description"""
"PB60_BTD_BSC_02_Card=r01sr1sl09_PTP=003_AIS-MsTTP^""2019-03-28-17.58.54.000000""^""AlarmClear""^""1970-01-01-05.30.00.000000""^""2019-03-28-17.50.26.000000""^""PB60_BTD_BSC_02""^""2019-03-28-17.50.18.000000""^""1970-01-01-05.30.00.000000""^""NORTH""^""PUNJAB""^""BATHINDA""^""AIS-MsTTP""^131255^""PB_MOHA_IOO""^""TXN_ALCATEL_NM""^""""^""SDH""^""""^""""^""""^""""^""""^""PJBATBATBHATVI0004""^""PB60_BTD_BSC_02_Card=r01sr1sl09_PTP=003""^0^""Bhatinda BSC""^4^16456317^""No Description"""
script output
Output:['"UE62-LUC_TP_Nagar_Card=r01sr1sl09_PTP=02_DEGRADED_SIGNAL-MsTTP', '""2019-03-28-16.14.09.000000""', '""AlarmClear""', '""1970-01-01-05.30.00.000000""', '""2019-03-28-16.14.09.000000""', '""UE62-LUC_TP_Nagar""', '""2019-03-28-16.14.24.000000""', '""1970-01-01-05.30.00.000000""', '""""', '""""', '""""', '""DEGRADED_SIGNAL-MsTTP""', '319', '""UP_LUCK_IOO_FM""', '""TXN_ALCATEL_NM""', '""""', '""""', '""""', '""""', '""OSPUN185""', '""11551840""', '""""', '""""', '""UE62-LUC_TP_Nagar_Card=r01sr1sl09_PTP=02""', '1', '""UE62-LUC_TP_Nagar""', '3', '13215461', '""000:"""']
['"OR62_ANG_HINDOL_RD_Card=r01sr1sl15_PTP=01_LOSS_OF_SIGNAL-OpS', '""2019-03-28-12.21.35.000000""', '""AlarmRaise""', '""2019-03-28-16.27.49.000000""', '""2019-03-28-12.21.35.000000""', '""OR62_ANG_HINDOL_RD""', '""2019-03-28-12.21.19.000000""', '""2019-03-28-16.27.48.000000""', '""EAST""', '""ORISSA""', '""DHENKANAL""', '""LOSS_OF_SIGNAL-OpS""', '72', '""NULL""', '""TXN_ALCATEL_NM""', '""COMMUNICATIONSALARM""', '""SDH""', '""""', '""""', '""BA80542248""', '""11477261""', '""RESOLVED""', '""ORCUTDHE1450VI0003""', '""OR62_ANG_HINDOL_RD_Card=r01sr1sl15_PTP=01""', '1', '""OR62_ANG_HINDOL_RD""', '0', '2118297644', '""No Description"""']
['"PB60_BTD_BSC_02_Card=r01sr1sl09_PTP=003_AIS-MsTTP', '""2019-03-28-17.58.54.000000""', '""AlarmClear""', '""1970-01-01-05.30.00.000000""', '""2019-03-28-17.50.26.000000""', '""PB60_BTD_BSC_02""', '""2019-03-28-17.50.18.000000""', '""1970-01-01-05.30.00.000000""', '""NORTH""', '""PUNJAB""', '""BATHINDA""', '""AIS-MsTTP""', '131255', '""PB_MOHA_IOO""', '""TXN_ALCATEL_NM""', '""""', '""SDH""', '""""', '""""', '""""', '""""', '""""', '""PJBATBATBHATVI0004""', '""PB60_BTD_BSC_02_Card=r01sr1sl09_PTP=003""', '0', '""Bhatinda BSC""', '4', '16456317', '""No Description"""']