Software :: Manipulate Text File To Allow Import To Excel?
Jun 11, 2010
Have managed to create a simple script to poll the various printers we have at our company for a page count via SNMP. At the moment the script echos the printer name to a text file and then the snmp output is appended to the next line. In my rush I thought by using sed to add a comma to the end of each line would mean it would import in to excel nicely. So rather than having:
Printer 1,
45536,
Printer 2,
[code]...
View 3 Replies
ADVERTISEMENT
Oct 5, 2010
I have a file with ".tgff" format that a piece of it, is as below (this file is for describing a benchmark in hardware design):
Code:
# AMD ElanSC520-133 MHz
@PROC 0 {
[code]....
View 1 Replies
View Related
Oct 5, 2010
I have a file with ".tgff" format that a piece of it, is as belowthis file is fordescribing a benchmark in hardware design)
Code:
# AMD ElanSC520-133 MHz
@PROC 0 {
[code]...
View 5 Replies
View Related
Sep 22, 2015
I'm working in a school and we have a Apple server, we have many problem with it. So, I would install a linux server instead.
Anyway, there is just one big problem (or I miss a simple tip to do it )
We have 1300 students. If I must create them one by one, that will take a lot of time. Actually with the apple server, we can go on a web interface & import an excel list with theses columns :
"Name", "Login", "Password", "Class", "Group", "HDD Space", "Print quota", "Internet access or not", etc ...
Due to this tool, I can upload an excel files with my 1300 students & a couple hours after, they have an account with a personal space & a shared space with their class.
My question is : This tool exist on Debian/Linux world ?
View 7 Replies
View Related
Mar 25, 2010
Is there any Linux tool to create new or modify exiting key/value pairs in text configuration files? For example, to change a setting in xorg.conf, or change something in etc/networking/interfaces? I know it could be done by sed or by perl scripts, but it could be easier to have a program for this purpose. There are many difficulties for this job that the program should consider, and I am facing nearly all of them:
- Some configuration files may have sections. Like in Windows-type INI files (for example: "[something]"), or like Section in xorg.conf. More sections with the same name can occur, like in xorg.conf.
- If the key/value pair originally does not exist, then the program should add it. But not to the end of the file, but tothe end of a predefined section.
- Config files can have remark lines. Remark text can be even at the same line than the key/value pair. After modifying the value, the original remark text should not change at the end of the line. The remark-starting symbol is not always.
- The values in configuration files are not always simple numbers or simple words, but in rare cases, they are composed by more words, for example: item=name address phone
And of course, we can have remark at the end, like this: item=name address phone # remark text
- The key-value separator depends on the file. Some files use "key=value" format, some other use "key value" format, or even "key1 key2 value", like xorg.conf. The as separator can also occur.
- Case sensitivity can also be an issue.
- Sometime to desired task is not to modify a value, but to add or remove a line beginning remark to a certain line.
I think that managing all these possible cases by a perl or sed program is nearly impossible. I begun to write a C program, but maybe there is already one?
View 6 Replies
View Related
Feb 3, 2010
I have been using sed to manipulate a csv file but I have one problem that I can't solve. The csv file has many line and many columns. If in a particular line column 2 has a certain value I want to replace that value with the value in column 5 in the same line.
View 5 Replies
View Related
Nov 16, 2009
My latest rpm package building project is a ham radio program called rmsgw. The source code tarball is a "make" and "make install" affair. It's Debian style Linux format fails badly on a Fedora install, so some tweaking of a configuration file is needed.I presume sed is the right tool for this job. I have no experience with sed and I don't want to spend a week or more in 'info sed' and doing endless trial and error if I can avoid it. I need to change one line in a text file named rmsgw.mk with a command(s) in the spec file.The original line:
Code:
PKG_LIBS := -lwl2k -lrms -lmysqlclient -lxml2
The line as it needs to be for 'make' to succeed to build the binaries:
[code]...
View 5 Replies
View Related
Aug 23, 2010
I have an application which looks in a particular directory for it's settings. For example varsetting.txt. These settings are stored in a text format and can be edited easily. I would prefer to keep this setting.txt file on a USB stick rather than the HDD for portability so that I can easily use the same settings on two linux PC's without having to redit them everytime. I have tried but cannot manipulate the application to look in a different location for this file, do you know if it is possible to "point" linux to another location when looking for the file?
View 2 Replies
View Related
Dec 21, 2010
How to attach an ordinary file as well as Excel file while sending mail to a particular user in red hat.
View 1 Replies
View Related
May 26, 2011
I wonder capability of awk to manipulate data in consecutive multi files by read one batch file.for example I have files: data1.dat, data2.dat,data3.dat and listfile.txt
cat data1.dat
23 34 54
43 45 76
[code]...
View 4 Replies
View Related
Jul 2, 2010
What Linux software can repair a corrupted excel file? I can't find anything useful in google or searching with synaptic.
View 5 Replies
View Related
Nov 14, 2010
view WINDOW excel file without using GUI
View 1 Replies
View Related
Feb 15, 2011
I would like to find a tools to change csv file to excel , I tried google , there are some tools can do it , but the file have some specical character and Chinese character , can advise what tools is good for it ?
another that , I have one specical requirement , I would like the tools can change the date format of a specific column ( eg. from mm-dd-yy to dd/mm/yy ) , is there any tools can do that ?
View 12 Replies
View Related
Jan 15, 2010
I am having trouble getting some code to work. It takes an input file (csv) and converts it to an XLS. The problem is that I can't seem to get a header to be printed first...
Code:
use Spreadsheet::WriteExcel;
my $input = $ARGV[0];
[code]...
View 5 Replies
View Related
May 20, 2011
I want to use LaTeX text in Inkscape. Just a simple thing like $$x_i$$. There is an extension called textext with installation manual. Basically one have to copy four files into /usr/share/inkscape/extensions and one more option appears in Extensions menu. So far so good.
If I try to use that extension I get an error message:
Traceback (most recent call last):
File "/usr/share/inkscape/extensions/inklatex.py", line 7, in <module>
import xml.dom.ext.reader.Sax2
ImportError: No module named ext.reader.Sax2
Googling you can find several topics about that error from 2004 or earlier saying to install PyXML and providing a link to it, where it is said "Out of date. Do not use it." I have tried to build that PyXML though -- without success (lots of compile errors).
View 4 Replies
View Related
Oct 22, 2010
I have started using Evolution because I gave up tying to get Thunderbird or Eudora work. I kept getting "unable to locate mail spool file" when trying to receive mail. I was able to import my mailboxes from my Windows Eudora. But in those mailboxes, about half of those emails had the headers but no body text. What is causing this and can it be fixed.
More importantly tho', when I import my contacts from Eudora, they are a mess, and pretty much unusable. I see a series of rectangles with "alias" on top and "real name" underneath and then when I click on it, expanded below is the alias and email address. There are two of these alias/names per rectangle and they scroll across. Any idea how I can fix that other than manually typing in each address.
View 3 Replies
View Related
Jan 14, 2011
We would like to use linux tools to convert csv file to excel file , can advise any simple tools can do that ?
View 8 Replies
View Related
Mar 16, 2011
I am working on telnet session and excuting commands. I am able to redirect or store expect output to log file but now i want to store in excel file like ispreadsheet showing details of commands and its responses
View 2 Replies
View Related
Feb 6, 2011
im trying to output a list of running processes via a shell script. At the moment i got this which outputs the processes to a text file called out.
echo $(ps aux) >>out
The problem is though, the processes are all just one big block of text which makes it hard to read. Does anyone know how to sort the output to a text file so that it prints to the text file at 1 process per line? I know its probably simple but im very new to linux.
View 5 Replies
View Related
Mar 2, 2011
Looking for an open source solution to convert pdf file to excel document.
View 1 Replies
View Related
Jan 28, 2009
I have a text file called file1.txt containing many lines eg.
line1
line2
line3
line4
line5
line6
Then i have another text file called file2.txt contains
3
5
6
Is there a command to remove the lines in file1.txt based on the keywords in file2.txt? note: It should remove line3,line5,line6 based on 3,5,6
View 10 Replies
View Related
Apr 2, 2011
I put a text file on my desktop and added a couple lines of text with gedit. File type shows text/plain. Double-click opens the file in gedit which is what I want. I'm using the file to temporarily hold some snips of code that I copy from file to file, but when I copy some html into the file and save it, now file properties show it's text/html and a double-click opens the file in firefox, which isn't what I want. Is there some way to keep the file type from changing itself?
View 6 Replies
View Related
Apr 28, 2010
How could I replace text in one file with text from another file using sed?
The text in each of the files would be surrounded by a starting and ending delimiter or a starting tag, say like /* */ so to easily find them.
View 8 Replies
View Related
Jun 1, 2010
Can I use sed to include a text file in the beginning of other text files inside a folder and its subfolders? So it should be recursive.
View 4 Replies
View Related
Jan 19, 2009
I need to insert 3-4 lines of text to the beginning of a text file. The file is a largish MYSQL dump, the result of a backup shell script. This shell script should insert the required text.I've wrestled with sed, but lost.
View 2 Replies
View Related
Jan 13, 2010
I have to delete a certain line of text from the a textfile via ubuntu's shell scripting.I have done research, and it seems that most people advocate the usage of sed /d option. sed makes does not edit the text file. Hence, most options I discovered involved the use of a temporary variable/textfile and then overwriting the old file with the temporary new file. Is there anyway whereby I can bypass the use of temporary storage containers? I hope there is any magical combination of commands to edit the file directly.
View 3 Replies
View Related
Jan 8, 2011
I want to display something in my text view widget in glade using c code. that's all right.
now I need to attach a save button beneath the text view.so that on click the text view content should save as a txt file..
View 8 Replies
View Related
Feb 9, 2011
I want to display the contents of a particular log file (simple text file, I mean in Linux). But there is a problem: The contents need to be organized in a fixed format. Have a look at this log file:
sampleLog.txt
Code:
User Name: XYZ
Reported Problems Description: Blah! Blah! Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah!
[code]....
So, while displaying the contents of above file on a web page, I want to format the field names found in the log file: User Name:, Reported Problems Description:, and Remarks:. These fields may contain a variable length of text and no specific line number is assumed for them to appear on.
The desired output should look like this:
User Name: XYZ
Reported Problems Description: Blah! Blah! Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah! Blah!Blah!
[code]....
Well, what I am trying to do may sound wierd to some of you. The filed "Reported Problems Description:" can possible contain text which embeds colon (.
View 15 Replies
View Related
Dec 6, 2010
I am looking for a way to keep a log and make if then statements if a line exitsts in the log. I also am looking for a way to make a simple loop, like goto line number, and I also am wondering how to add/remove bits of text from a text file (plugins line in server.properties)
View 5 Replies
View Related
May 3, 2010
a sed command to add a text before line number in text file? I have text file with 500 lines, and i want to add 3 more lines with text after line 300, OR before line 302, isn't no problem.
View 16 Replies
View Related