How to delete column in notepad

  • Thread starter Thread starter CanoIsDbo
  • Start date Start date
  • Tags Tags
    Column Delete
Click For Summary
SUMMARY

The discussion focuses on deleting a time column from an LVM file generated by LabVIEW, which is opened in Notepad. Users suggest importing the file into Excel as a CSV, where the unwanted column can be easily removed. One participant recommends saving the file with ANSI encoding and changing the extension to .csv before opening it in Excel for further manipulation. This method allows users to plot only the strain data effectively.

PREREQUISITES
  • Understanding of LabVIEW data output formats
  • Familiarity with LVM file structure
  • Basic knowledge of Excel functionalities
  • Experience with file encoding and extensions
NEXT STEPS
  • Learn how to manipulate LVM files in LabVIEW
  • Research CSV file handling in Excel
  • Explore file encoding options and their implications
  • Investigate data visualization techniques in Excel
USEFUL FOR

Data analysts, LabVIEW users, Excel users, and anyone needing to manipulate and visualize data from LVM files.

CanoIsDbo
Messages
12
Reaction score
0
Hi, I was running a labview program and it wrote my data to an lvm file, which can be opened with notepad. The problem I am having is the way labview outputted my data. It has the time and the strain separated by a comma. I attached the file, so everyone can see. What I want to do is somehow delete the time column so I can just plot the strain in excel. Anyone have an idea how to do this?

Thanks
 

Attachments

Computer science news on Phys.org
What would you plot the strain against? Or are you plotting a histogram?

If you wanted just the strain data, you can import csv (comma separated value) files in Excel (I don't think you even need to rename it from .txt to .csv) and then just delete the offending column. You can also save the resulting data as a standard Excel file, along with your graphs, etc.
 
CanoIsDbo said:
Hi, I was running a labview program and it wrote my data to an lvm file, which can be opened with notepad. The problem I am having is the way labview outputted my data. It has the time and the strain separated by a comma. I attached the file, so everyone can see. What I want to do is somehow delete the time column so I can just plot the strain in excel. Anyone have an idea how to do this?

Thanks

I don't think it can be done.

I would save the file from notepad with ANSI coding, change the extension to .csv, open the file in excel, and delete the unwanted column.
 

Similar threads

  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 24 ·
Replies
24
Views
11K
  • · Replies 17 ·
Replies
17
Views
3K
  • · Replies 11 ·
Replies
11
Views
2K
  • · Replies 6 ·
Replies
6
Views
3K
Replies
7
Views
3K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 14 ·
Replies
14
Views
4K
  • · Replies 3 ·
Replies
3
Views
2K