Search Results

Redirection works identical for input as well as for output. Try
$ mv /tmp/new_file /tmp/old_file
$ while read product id features
do printf "${product}, %s\n" ${features%#*}
done <...

That is close - try this
while read product id features
do
printf "${product}, %s\n" ${features%#*}
done < Check_FileYour example was using only two variables (f1, f3) to read the fields...

Or, awk:
awk -F"[,;]+" 'NR == 1 {print; next} {for (i=2; i<=NF; i++) print $1, " " $i}' OFS=, file
Name , Company_Worked (Header)
Asley, IBM
Asley, Amazon
Asley, BOA
Asley, Google
King.Jr,...

Hi
How about sed?
sed -r ':1;s/^([^,]+)\s*,\s*([^;]+);/\1, \2\n\1, /;t1' file
Name , Company_Worked (Header)
Asley, IBM
Asley, Amazon
Asley, BOA
Asley, Google
King.Jr, Wipro
King.Jr,...

A shell script with only shell builtins:
#!/bin/sh
set -f # unquoted $f2
IFS=";"
while IFS="," read f1 f2
do
printf "$f1, %s\n" $f2
done < file

$ cat ~/tmp.dat
Name , Company_Worked (Header)
Asley,IBM;Amazon;BOA;Google
King.Jr,Wipro;Microsoft;AMZ

$ perl -ne 'chomp;($name,$emp)=split/,/;for (split/;/,$emp){print "$name, $_\n";}'...

What you want are the "rank()" or "dense_rank()" analytic functions.
They could be referred to as "window functions" or "OLAP functions" in DB2 and some of them are available in DB2 9.7 at least....

Over the weekend, I was able to install a very basic free, developer's edition of SAP Sybase ASE 16.0 on my Debian 8 OS.
The SQL implementation is quite primitive compared to those by the big boys....

if I were your boss, i would calculate it this way.

SALARY=Perlbaby_annual_salary
let HOURLY_RATE = $SALARY / 2000
let ANNUAL_SAVINGS = (180 - 12) * $HOURLY_RATE
echo $ANNUAL_SAVINGS


Note...

The following was tested on DB2 Express-C Version 11.1 on a Centos 7 Virtual Machine.


[db2inst1@r2d2-centos7 data]$
[db2inst1@r2d2-centos7 data]$ cat -n dec2bin.sql
1 --
2 ...

From the ASE documentation at: infocenter.sybase.com

Adaptive Server Enterprise 15.5
> Transact-SQL User's Guide
> Using the Built-In Functions in Queries
> String functions used...

Hmm that is nasty - here is a generalized discussion of the problem:

https://en.wikipedia.org/wiki/Correlated_subquery#Optimizing_correlated_subqueries

It looks like you're doing a correlated subquery (https://en.wikipedia.org/wiki/Correlated_subquery). Those are nasty performance killers.

Could you post the columns available in each table, the...

select regexp_replace('AB,CD','([[:alpha:]]{2})',q'['\1']') from dual;
'AB','CD'
select regexp_replace('AB,CD,EF','([[:alpha:]]{2})',q'['\1']') from dual;
'AB','CD','EF'

This should work for you:
select '''AB,CD,EF''', regexp_replace( '''AB,CD,EF''', ',', ''',''' ) from dual

The content of the script :

#!/bin/bash

target_date=`date +%Y%m`
cd /tmp
the_existing_file=`ls *$target_date*`
the_desired_file="Access_file_Record.${target_date}"

if [ $the_existing_file...

UNIX doesn't use \r\n to terminate lines, just \n, so the carriage return is being taken as part of the string and not as whitespace. I don't know why some systems didn't have a problem, but this is...

Hi,

there is a redbook AIX for HP System administrators (http://www.redbooks.ibm.com/abstracts/sg246767.html?Open)

Regards
zxmaus

Rosetta Stone for Unix (http://bhami.com/rosetta.html)