I was wondering if it is possible to load a space-tabulated ascii as a "cell-tabulated form", something like excel. I have the following information:
I usually use nedit to show this file in a shell script. I don't know what tool could do what I want, I tried calling a spreadsheet for instance but didn't work.
I'd be very grateful if someone could suggest me a solution for this, thanks in advance.
I don't understand. What is it that you want to do?
You want to process/massage the this data through the shell script somehow? You want to display it on the screen?
Elaborate please!
Thanks for your answer. I just want to display it arranged by cells, like in the excel. So far I displayed it with nedit, ie. in the way I showed here.
I don't think there's an Excel-like app in *NIX that comes out of the box...
You can convert your file into the HTML doc and display it in the browser....
Location: Saint Paul, MN USA / BSD, CentOS, Debian, OS X, Solaris
Posts: 2,288
Thanks Given: 430
Thanked 480 Times in 395 Posts
Hi.
The perl code align is the best tool for column alignment I have seen. Here I used the first 10 columns of your input data as a demonstration. The first part shows the context on our systems, the last part is probably more of interest:
producing:
The data are aligned, the default is "automatic", but options are available to force alignment to left, right, center, decimal, and much more.
See the URL noted the script listing for the source to align.
Hi All,
I have an ascii file in which few columns are having hex values which i need to convert into ascii. Kindly suggest me what command can be used in unix shell scripting?
Thanks in Advance (2 Replies)
Hi,
I want to read extended ASCII characters from keyboard using c language on unix/linux. How to read extended characters from keyboard or by copy-paste in terminal irrespective of locale set in the system. I want to read the input characters from keyboard, store it in an array or some local... (3 Replies)
Hi,
I want to write a small code in which script changes command line input to some form.
Example
script.sh a1 a2 a3 a4 .....
output should be "a1|a2|a3|....."
Number of inputs in command line can be any variable (2 Replies)
Hi ,i have a question ,if I am in sertain directory and I have 4 files *.c
how can I read and append this files in file backup.bac
Thanks
find ./ -name "*.csh" | wc -l (2 Replies)
Hi,
Maybe this iscorrect forum for my question...
I should read one character at a fixed position from each line of the file. So how ??? should be substituted in the code below:
while read line ; do
single_char=`???`
echo "$single_char"
done < $input_file
OK...I did get an... (0 Replies)
Can someone help me to write a script / command to read in a file, character by character, replace any unknown ASCII characters with space. then write out the file to a new filename/
Thanks! (1 Reply)
Hello All,
I need to read the data inside one file who's format is ascii text. I got the file format when I use file command on the file.
file <filename>
filename ascii text
please help me on this.
Thanks (8 Replies)
Hi all
I need specific fields from a file to be tabulated into a single file.
I have a file with the following :-
FIELD1 InfoA FIELD2 InfoB
FILED3 InfoC
FIELD1 InfoD FIELD2 InfoE
FIELD3 InfoF
The output... (2 Replies)
Please someone I need information on how to change a Unix form/document into a microsoft word document in order to be emailed to another company. Please help ASAP. Thankyou :confused: (8 Replies)