Hi,
I tried this but could not get it...
here is what I need I have an xml where I get all the data in blocks but some times I get empty blocks with no data...shown below..I need to delete only those blocks with no data, I tried couple of ways but could not do it..any help is appreciated...... (1 Reply)
I'm getting an else unmatched error on the script below..
For info : SYDB is the database name entered as a param on the command line.
#Check the DB name
HBDB=`sql $SYDB <<_END_ | grep '^|' | grep -v dbase | sed 's/|//g' | sed 's/ //g'
set autocommit on;
\p\g
set lockmode... (7 Replies)
:b:Hi guys,
I am getting this error in this piece of code, Any help will be appreciate
rypidoc.shl: syntax error at line 79 : `for' unmatched
##Determine if there is a file to process
ls 3526*.dat > /dev/null 2>&1
if
then
exit
fi
for i in 3526*.dat
do
# Capture just the file... (2 Replies)
Hi I have a file with following records
It contains three months of data, some data is duplicated,i need to access the latest data from the duplicate ones.
for e.g; i have foll data
"200","0","","11722","-63","","","","11722","JUL","09"
"200","0","","11722","-63","","","","11722","JUL","09"... (10 Replies)
Hi,
i need help to extract unmatched data from 2 files. for instance, the input file like below:
file1.txt
ID hit addhit
123 sp q9876
656 sp q5641
332 sp d1211
248 sp f5642file2.txt
ID Num def activity
123 447 trial ... (4 Replies)
Hi Guys,
Please help me with my problem here:
I have a source file:
1212 23232 343434 ASAS1 4
3212 23232 343434 ASAS2 4
3234 23232 343434 QWQW1 4
1134 23232 343434 QWQW2 4
3212 23232 343434 QWQW3 4
and a mapping... (4 Replies)
Hi,
I am running sinple ksh script .
From some reason it failed on the following error:
./ogg_status.sh: syntax error at line 16 : `<<' unmatched
Please advise.
#!/usr/bin/ksh
export ORACLE_HOME=/software/oracle/DB10gR2
export LD_LIBRARY_PATH=/software/oracle/DB10gR2/lib:/usr/lib... (4 Replies)
Hi,
I have a delimited (|) file having millions of rows. Sometime the file comes with less number of delimiters than expected. In this scenario I want to delete the row having unmatched delimiters.
Can anyone help me with the command to achieve this?
Ex:
File1.txt
8039339595113|JIMMY... (2 Replies)
Hi all,
Please help with the following example.
I want to keep all people in the data, who at least have Firstname or Lastname or both and at least 1 row of Details. So, Person4 lacking both Firstname and Lastname will be deleted, Person5 with no Details will be deleted.
Firstname,Lastname... (3 Replies)