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:
Code:
#!/usr/bin/env bash
# @(#) s1 Demonstrate align for column presentation, display.
# source for perl code "align": http://freshmeat.net/projects/align
# Section 1, setup, pre-solution.
# Infrastructure details, environment, commands for forum posts.
# Uncomment export command to test script as external user.
# export PATH="/usr/local/bin:/usr/bin:/bin"
set +o nounset
pe() { for i;do printf "%s" "$i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
C=$HOME/bin/context && [ -f $C ] && . $C align
set -o nounset
pe
FILE=${1-data1}
# Create short version of data file.
cut -f1-10 -d" " data0 > $FILE
# Section 2, display input file.
# Display sample of data file, with head & tail as a last resort.
pe " || start [ first:middle:last ]"
specimen $FILE \
|| { pe "(head/tail)"; head -n 5 $FILE; pe " ||"; tail -n 5 $FILE; }
pe " || end"
# Section 3, solution.
pl " Results:"
align $FILE
exit 0
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)