How to delete column in notepad

  • Thread starter CanoIsDbo
  • Start date
  • #1
CanoIsDbo
12
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

  • example.txt
    86.7 KB · Views: 553

Answers and Replies

  • #2
MATLABdude
Science Advisor
1,664
5
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.
 
  • #3
OmCheeto
Gold Member
2,257
2,713
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.
 

Suggested for: How to delete column in notepad

Replies
6
Views
2K
Replies
24
Views
5K
Replies
36
Views
1K
Replies
4
Views
360
  • Last Post
Replies
3
Views
606
Replies
5
Views
321
  • Last Post
Replies
16
Views
743
  • Last Post
Replies
10
Views
535
  • Last Post
Replies
10
Views
1K
Top