How to delete column in notepad

  • Thread starter Thread starter CanoIsDbo
  • Start date Start date
  • Tags Tags
    Column Delete
Click For Summary
A user is facing an issue with a LabVIEW program that outputs data to an LVM file formatted with time and strain values separated by commas. The user seeks a method to remove the time column to plot only the strain data in Excel. Suggestions include importing the LVM file directly into Excel as a CSV, which allows for easy deletion of the time column, and saving the modified file as a standard Excel document. Another recommendation is to save the file from Notepad with ANSI encoding, change the file extension to .csv, and then open it in Excel to delete the unwanted column.
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.
 
Thread 'ChatGPT Examples, Good and Bad'
I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...

Similar threads

  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 24 ·
Replies
24
Views
10K
  • · 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
3K
Replies
27
Views
4K