10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to create a fixed width file based on the column lengths.
lets assume I have six(this may be dynamic) fields each are of different length
column1=6 #size of the column
column2=3
column3=2
column4=3
column5=4
column6=5
I tried below code snippet but it is not working
echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies
2. UNIX for Beginners Questions & Answers
Hi all,
I am having the file below
I need that as below
Thanks,
Arun (12 Replies)
Discussion started by: arunkumar_mca
12 Replies
3. Shell Programming and Scripting
Hi,
I have a data as follows in some files, i want to change CHAR(2-20) to VARCHAR(2-20). I should not touch any line with CHAR(1)
Example:
Input:
cur_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
prev_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT... (7 Replies)
Discussion started by: srikanth38
7 Replies
4. Emergency UNIX and Linux Support
can anyone one help me....to make date and time format...to following format for my file
DATE TIME
DD- MON- YEAR 24 Hours
I have a need of format like this
12-Jan-2012 in one column, then time in 24 Hours in another column....please help...me...
... (4 Replies)
Discussion started by: nex_asp
4 Replies
5. UNIX for Dummies Questions & Answers
Hi I am a newbie here. I tried searching for the solution but I guess I either didn't find it or there hasn't been one posted.
my problem is I spooled the results of a query into a .txt file. When I cat the file the formating looks great. All the columns are aligned. However once I mailx the... (2 Replies)
Discussion started by: RB26DETT
2 Replies
6. Shell Programming and Scripting
Hello Team i have a file with following data (as columns).
I need implement a syntax like below for altering table
ALTER TABLE1 TABLENAME
ADD COLUMN COL1 CHAR(5) NOT NULL WITH DEFAULT
ADD COLUMN COL2 CHAR(5)
..
..
ADD COLUMN COLn CHAR(5) NOT NULL... (1 Reply)
Discussion started by: rocking77
1 Replies
7. Shell Programming and Scripting
Dear all
I had input file as mention below and want op as mention.
Kindly let me knw possible ways.
Regards
Jaydeep
INPUT:
RXOTX-48-1
2A 34
2B 35
RXOTX-499-2
2C 32
RXOTX-4-1
2D 23
OUTPUT: (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies
8. Shell Programming and Scripting
Hi All,
Can anybody tell me why is there a "0" in my output of $date_today ?
#!/usr/local/bin/perl
$date_today = system "date '+%y%m%d'";
print "$date_today\n";
Output:
$ perl test4
080908
0 (3 Replies)
Discussion started by: Raynon
3 Replies
9. Shell Programming and Scripting
Dear All
I am stuck in one problem. Kindly help me.
I am taking below mention file as input file and want some op file as mention below.
Kindly send me all possible suggestion and query.
Thnaks
Jaydeep
bELOW IS THE INPUT FILE:
*** Connected to BSCANGR ***... (1 Reply)
Discussion started by: jaydeep_sadaria
1 Replies
10. UNIX for Dummies Questions & Answers
Hi,
In my code:
echo " Field1 " " Filed2 " " Filed3 " >> $myfile
echo "--------" "------- " "--------">> $myfile
echo $value1 $value2 $value3 >> $myfile
echo $value1 $value2 $value3 >> $myfile
echo $value1 $value2 $value3 >> $myfile
My file... (4 Replies)
Discussion started by: redlotus72
4 Replies