Hi friends,
I am new to unix. With the help of this site I wrote a script. But it's returning some errors pls help.
Here is my specifications:
I have a file obsrec_31583_090212.xls at /home/lingalma/temp/cdl I want it to mv to another temp folder called /home/lingalma/temp/obsrec and check if itcontains more than 65000 rows. If so split the file and rename the files.
My script is:
Code:
#!/bin/csh -vdb
cd /home/lingalma/temp/cdl
FN =`ls -lrt obsrec* | tail -1 | awk '{print $9}'`
DN =`ls -lrt obsrec* | tail -1 | awk '{print $9}'| awk -F. '{print $1}'`
#FN should be obsrec_31583_090212.xls, and DN should be obsrec_31583_090212
cp $FN /home/lingalma/temp/obsrec
cd /home/lingalma/temp/obsrec
if [ wc -l $FN => "65000"];
then
split -l 65000 $FN $DN
rm -f $FN
NUM=1
ls | while read line
do
mv $line $DN_$NUM.xls
$(( NUM + 1 ))
done
fi
EOF
Error message is:
Code:
cd /home/lingalma/temp/cdl
FN =`ls -lrt obsrec* | tail -1 | awk '{print $9}'`
FN: Command not found
DN =`ls -lrt obsrec* | tail -1 | awk '{print $9}'| awk -F. '{print $1}'`
DN: Command not found
cp $FN /home/lingalma/temp/obsrec
FN: Undefined variable
Please advise how can I correct these errors.
Last edited by zaxxon; 02-13-2009 at 10:21 AM..
Reason: added code tags
I have a file {filename} which contains 65000 records
I need to split into 6 smaller files roughly 11000 records each.
Can someone advise me of the Unix command to do so ?
Many thanks (2 Replies)
Hi,
I have a comma separated file with millions of records in it.
I have a requirement to split the file based on the value in a one of the columns.
Suppose i have a text file with columns like C1, C2,C3,C4
Column C4 can hold the values either 01 or 02 03 or 04.
I nned to extract... (2 Replies)
Hi
The scenario is like this.
I need to split 5 files having size 3GB, 2GB, 4GB, 30GB and 20 GB respectively.
The machine has 15GB heap space. Before starting split proces it was showing 15gb free space. Once the split process completed it showed 100 mb free and around 12GB cached.
My... (3 Replies)
I have a very big log file which looks like this:
I need to split this file and create files with "+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+" as the delimiter.
The file names need to be the contents of the next line after the delimiter(FIRST_ITEM,SECOND_ITEM...so on..). (7 Replies)
Dear All,
I have a very large file which which i would like split into indvidual frames evrytime the line ends with "ENDMDL" and then name frame1.pdb frame2.pdb etc
can any one give me a few sugeestions? ideally i would like to have ENDMDL at the end of each frame or not pressent at all.
an... (4 Replies)
Hi all,
i have file that looks like as below
2263881188,24570896,439,SOLO,SOLO_UNBEATABLE,E,+3.13,+0.00
2263881964,24339077,439,SOLO,SOLO_UNBEATABLE,F,-0.67,+0.00
2263883220,22619162,228,Bell,Bell_MONTHLY,E,-2.04,+0.00
2263883220,22619162,228,Bell,Bell_MONTHLY,F,-2.04,+0.00... (3 Replies)
Hello,
I want to split or cut a large size log file by year wise(eg 2009, 2010) .But the source file must not have the splited or cut lines after this process ,all of them must move to the destination folder.Does grep command have the fuctionality like cut and paste? I used grep -Ev command but... (17 Replies)
I have a .ksh script that creates an sftp batch file and runs it through sftp. It works except for one thing. If I try to "put" to a different name, it doesn't use the specified remote name...it still "puts" the original local name.
I've tried both of these, and neither work...it will always... (4 Replies)
Discussion started by: dbiggied
4 Replies
LEARN ABOUT OSF1
rmm
rmm(1) General Commands Manual rmm(1)NAME
rmm - remove messages (only available within the message handling system, mh)
SYNOPSIS
rmm [+folder] [msgs] [-help]
OPTIONS
Prints a list of the valid options to this command.
The default settings for this command are:
+folder defaults to the current folder msgs defaults to the current message
DESCRIPTION
The rmm command deletes the current message from the current folder.
You can specify messages and folders other than the current ones by using the +folder and msgs arguments.
The current message is not changed by rmm, so a next will advance to the next message in the folder as expected.
If you have defined a component rmmproc: in your file, then instead of simply renaming the message file, rmm will call the named program to
delete the file.
The rmm command removes messages by renaming the message files with a preceding comma. Many sites consider files that start with a comma to
be a temporary backup, and arrange for cron(8) to remove such files once a day.
PROFILE COMPONENTS
Path: To determine your Mail directory
rmmproc: Program to delete the message
FILES
The user profile.
SEE ALSO rmf(1)rmm(1)
02-13-2009
Spliting a file and renaming it's out put
