09-27-2014
Don,
Please find my answers here, I could have been more specific earlier. I am working on automating few scripts and as part of that, I need to have this.
1. No there could be less or more depending on columns between brackets. In this example, I have 2 columns and so 5 lines. If there are 5 columns, then there will be 8 lines. Line 1, Line 2 and last line will remain same except the table name in last line
2. No, the number of elements changes depends on the number of columns(COL1, COL2, COL3.....)
3. ',' is expected in the output
4. It is tab key. In the sample data, it didn't allow me to put tab key, so I used spaces. There are two tabs before COL1, COL2
5. No, COL1 will always appear in line 3
6. No, COL1, COL2(and even COL3 if there is one) will always be in separate lines
7. Yes there will be a comma if COL3 exists and so on. The last column(COLx) will not have anything
8. I am using ksh in linux
Thanks,
V
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I've been asking on IRC channels but no one answers me, I need to format my hard drive, normally it's just format c:
but c doesn't exist, how do I format when I have linux mandrake installed. Please reply to this quickly, I'm kinda in a rush :( (1 Reply)
Discussion started by: darryll777
1 Replies
2. UNIX for Dummies Questions & Answers
is it possible to format a powerbook g4 mac? like totally erase the HD then pop in the Mac OS cd and it will boot up an install like windows or any linux? (5 Replies)
Discussion started by: xeron
5 Replies
3. UNIX for Dummies Questions & Answers
Hi Again Guys ,
Please i installed linux RH 6.1 on Toshiba , 10G , RAM=128 , 600 MHZ .
After i installed linux i got many error messages , seems it was not installed correctly , also when i finished installation it did not ask me for the 2nd installation CD , and when i logged as root , i... (5 Replies)
Discussion started by: tamemi
5 Replies
4. Shell Programming and Scripting
I have next part of script:
for i in $LIST
do
echo "`date +"%H:%M:%S"` Converting $i ...";
mysql -uroot some -sABe "ALTER TABLE $i ENGINE=$ENGINE";
done
I want to get following output formatting:
"OK" must be one under another :)
... (3 Replies)
Discussion started by: mirusnet
3 Replies
5. Shell Programming and Scripting
I have file with different columns
for ex.
contents of file "txt"
NAME AGE MARKS
HARRY 23 89
TOM 12 67
BOB 23 11
and you see its not formatted.Now, I need the file "txt" to be formatted like
COLUMN1 COLUMN2 COLUMN3
NAME AGE ... (3 Replies)
Discussion started by: vijay_0209
3 Replies
6. Shell Programming and Scripting
Is there a way to make a 2 column output out of the following :
1
2
3
4
5
6
Output :
1 2
3 4
5 6
Thanks,
Prasanna (3 Replies)
Discussion started by: prasanna1157
3 Replies
7. Shell Programming and Scripting
Hello,
I am developing a platform Independant tool that should work for all major unix flavors outlined in this forum(Solaris,Linux, AIX, HPUX, SCO,BSD)
Therefore, in order to cover all types of user community, I have deliberately posted the same message on every forum. Please do not think... (9 Replies)
Discussion started by: darsh123
9 Replies
8. Shell Programming and Scripting
I need to format a txt file and convert it in CSV.
Any "future" column is separated by a newline.
FROM:
XS1
1.43294
0.0
XS2
1.21824
0.0
TO:
XS1,XS2 (2 Replies)
Discussion started by: alfreale
2 Replies
9. Shell Programming and Scripting
Hi Guys,
i have report that runs every 10 min and send the report of failed jobs to my mail.
Currently i am using a command like this to send mail.
mailx -t -s "FAILURE JOBS IN HYDRA $temp_date" addressee@domain.com < temp_file5
But i am getting mail in this format ....... (4 Replies)
Discussion started by: gkrish
4 Replies
10. Shell Programming and Scripting
Good day All,
I have requirement where my input data looks like below
] Message5
Expecting Output as
04/MAR/2104 ||| 23:15:45 ||| servername ||| NOTIFICATION |||message1||||||userId|||||| Message5
I could not use space delimiter as in the messages I would be having them as... (2 Replies)
Discussion started by: Tomlight
2 Replies
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD