Open Phatkone opened 1 year ago
fields that have say up to around 4 commas in them are getting the commas stripped, but fields with more (8 is my reference point) are being retained.
reading the sheet with pandas: svcs = pd.read_excel(file, engine='openpyxl', sheet_name = svc_sheet)
svcs = pd.read_excel(file, engine='openpyxl', sheet_name = svc_sheet)
example field: service-http TCP 808080 should be 80, 8080
service-http TCP 808080
80, 8080
but, 4172,8443,443,80,4002,8009,8530,22443,32111 retains all the commas.
4172,8443,443,80,4002,8009,8530,22443,32111
fields that have say up to around 4 commas in them are getting the commas stripped, but fields with more (8 is my reference point) are being retained.
reading the sheet with pandas:
svcs = pd.read_excel(file, engine='openpyxl', sheet_name = svc_sheet)example field:
service-http TCP 808080should be80, 8080but,
4172,8443,443,80,4002,8009,8530,22443,32111retains all the commas.