Warren Rosenbaum
New Member
I have a csv that has ip addresses in a column in the following format. I am importing it into power pivot, using From other sources - Test file method
It is being imported as a decimal number, 10.1121.
How can i import it and leave it as an ip address?
timestamp,server,location,environment,application,instance,tier,entity_type,status,name,msg_type,os_type,ip_addr,cpu_count,cpu_percent_used(%),cpu_warn_threshold(%),cpu_err_threshold(%),mem_size,mem_percent_used(%),mem_warn_threshold(%),mem_err_threshold(%)
2023-01-26T13:22:00-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,21.75,85,90,15955,15.99,50,75
2023-01-26T13:22:30-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,22.67,85,90,15955,16.00,50,75
2023-01-26T13:23:00-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,17.46,85,90,15955,15.99,50,75
It is being imported as a decimal number, 10.1121.
How can i import it and leave it as an ip address?
timestamp,server,location,environment,application,instance,tier,entity_type,status,name,msg_type,os_type,ip_addr,cpu_count,cpu_percent_used(%),cpu_warn_threshold(%),cpu_err_threshold(%),mem_size,mem_percent_used(%),mem_warn_threshold(%),mem_err_threshold(%)
2023-01-26T13:22:00-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,21.75,85,90,15955,15.99,50,75
2023-01-26T13:22:30-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,22.67,85,90,15955,16.00,50,75
2023-01-26T13:23:00-0500,copuvlpoca01,co,Dev,ERT,,Application,server,success,copuvlpoca01,server,Linux,10.112.100.16,4,17.46,85,90,15955,15.99,50,75