The User has some text files of trend data from the building EMS. Has uploaded it into UT with the date and time in the first two columns and the measured value in the third column. Date, time and value are seperated by commas, however the units follow the value reading. So when User goes to process or graph the data there is an error. Is there a way to get the units removed from the file before processing? Or???
try fixed field file
In this instance try importing the file as a fixed field file instead.