03-26-2012
Output is not comming as expected
Hi All,
I am in middle of one script. I want output in the form of xls file.
There are 4 fields - user name, email Id, full name, date of birth. I want these details to get in seperate columns.
But, i am getting it in the single cell and as like a paragraph.
Please suggest me some command to format this looks..
Thankuz!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Experts,
I am adding a column of numbers with awk , however not getting correct output:
# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06
How can I getthe output like : 2152910
Thank you..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
2. Shell Programming and Scripting
Hi,
I am presently stuck in a csv file.
INPUT CSV
baseball,NULL,8798765,Most played
baseball,NULL,8928192,Most played
baseball,NULL,5678945,Most played
cricket,NOTNULL,125782,Usually played
cricket,NOTNULL,678921,Usually played
EXPECTED OUTPUT CSV
... (7 Replies)
Discussion started by: scripter12
7 Replies
3. Shell Programming and Scripting
Hi
I have written below script to get the data in table form.
#!/bin/sh
echo "File Name\tType"
for i in *;
do
echo "$i\t\c"
if ; then
echo "directory"
elif ; then
echo "symbolic link"
elif ; then
echo "file"
else
echo "unknown"
fi
donehowever i am getting output in different way... (3 Replies)
Discussion started by: scriptor
3 Replies
4. Shell Programming and Scripting
Hi awk experts,
I am getting a strange output , may be it is normal but I am unable to comprehend,
When Using == operator it is showing correct:
# ls -l | awk '{for (i=0;i<=NF;i++) if ( $i =="info" )print $1,$6,$7,$8,$9}'
drwx------ Jan 17 10:44 info
But When using ~ (equal )... (4 Replies)
Discussion started by: rveri
4 Replies
5. Shell Programming and Scripting
I've been working on improving my awk, and the next thing I want to learn is to properly use functions (I understand functions in shell and python). I have the following code which includes how I did this without functions before, and two attempts I've made to do it with functions:
function... (3 Replies)
Discussion started by: DeCoTwc
3 Replies
6. Shell Programming and Scripting
lyang001@lyang001-OptiPlex-9010:~$ service --status-all |grep dbus
acpid
acpi-support
alsa-restore
alsa-store
anacron
apport
atd
avahi-daemon
bluetooth
cgroup-lite
console-setup
cron
cups
dbus
dmesg
dns-clean
failsafe-x
... (1 Reply)
Discussion started by: yanglei_fage
1 Replies
7. Shell Programming and Scripting
Good Moring,
I am currently reading about awk in a manual and following the examples using the oratab file.
My system is SOLARIS 10
I think I am getting strange behavior judging by what the book says to do and what I am getting with my little program.
Here is my program:
grep -v oratab |... (4 Replies)
Discussion started by: bdby
4 Replies
8. Shell Programming and Scripting
#cat /tmp/input
old_array old_dev new_dev new_array
0577 008AB 01744 0125
0577 008AC 01745 0125
0577 008AD 005C8 0125
0577 008AE 005C9 0125
0577 008AF 005CA 0125
0577 008B0 005CB 0125
0577 008B1 005CC 0125
cat test.sh
#!/bin/ksh... (4 Replies)
Discussion started by: mbak
4 Replies
9. Shell Programming and Scripting
Hello,
I am practising awk and decided to compare two columns and print the result of the comparison as third column
i/p data
c1,c2,c3
1,a,b
1,b,b
i am trying to compare the last two columns and if they match I am trying to print match else mismatch(Ideally i want that as a last column... (5 Replies)
Discussion started by: mkathi
5 Replies
10. Shell Programming and Scripting
Hi Gurus,
I run command grep ABC file1 > file2 against below file. I got all ABC_xxx in one line in file2. I expect to get multiple lines in file2. If I print result in screen, the result is expected.
thanks in advance
My os is SunOS 5.10 Generic_150400-64 sun4v sparc sun4v
ABC_123
XXXXX... (2 Replies)
Discussion started by: green_k
2 Replies
DP(8) [nmh-1.5] DP(8)
NAME
dp - parse dates 822-style
SYNOPSIS
/usr/lib/mh/dp [-form formatfile] [-format string] [-width columns] [-version] [-help] dates ...
DESCRIPTION
Dp is a program that parses dates according to the ARPA Internet standard. It also understands many non-standard formats, such as those
produced by TOPS-20 sites and some UNIX sites using ctime(3). It is useful for seeing how nmh will interpret a date.
The dp program treats each argument as a single date, and prints the date out in the official 822-format. Hence, it is usually best to
enclose each argument in quotes for the shell.
To override the output format used by dp, the -format string or -format file switches are used. This permits individual fields of the
address to be extracted with ease. The string is simply a format string and the file is simply a format file. See mh-format(5) for the
details.
Here is the default format string used by dp:
%<(nodate{text})error: %{text}%|%(putstr(pretty{text}))%>
which says that if an error was detected, print the error, a `:', and the date in error. Otherwise, output the 822-proper format of the
date.
FILES
$HOME/.mh_profile The user profile
PROFILE COMPONENTS
None
SEE ALSO
ap(8), Standard for the Format of ARPA Internet Text Messages (RFC-822)
DEFAULTS
`-format' default as described above
`-width' default to the width of the terminal
CONTEXT
None
BUGS
The argument to the -format switch must be interpreted as a single token by the shell that invokes dp. Therefore, one must usually place
the argument to this switch inside quotes.
MH.6.8 11 June 2012 DP(8)