Search Results

Hi,

I am writing just to share my appreciation for help I have received from this site in the past.

In a previous post Split File by Data Group...

Many thanks Alister.

Your guess about the units is correct.

These files are actually excerpts for the USDA Nutrient Database available here:

http://www.nal.usda.gov/fnic/foodcomp/search/

Looking to join three files and then transpose some columns from multiple rows into a single row.


File Info:

FIELD TERMINATED BY '^'
ENCLOSED BY '~'
LINE TERMINATED BY '\r\n'



FIRST...

Thanks that worked well.

Code:

$ cat test.bash
#!/bin/bash

job=$1
steps=$2

num=$(echo "$@" | wc -w)



Example Submission:


$ ./test.bash BS01 3 1 2 3



What:

sysstat

man, why must I always do things in the strangest of ways....

This will assign user cpu% used to variable c

This assumes, you only have 1 cpu and that you are only concerned with user cpu %

c=`iostat | awk '{if(NR==4) {print $1}}'`

If you just want to use "oracle" you wouldn't need a script like this...


$ cat ./bin/df.bash
#!/bin/bash

echo Please type Filesystem Name:

read fs

rs=`df -h | awk -v fs=$fs 'BEGIN...

just a start....

$ cat spell_game
#!/bin/bash

matches=`awk '
(/^ball/ || /ball$/) && !(/^ball$/||/s$/||/ing$/||/ed$/||/er$/) {
gsub(/ball/,"")
if(length($0)>1) {print $0}
$0=""
}
...

what was the exact code you submitted during that run please

$ echo "secret1 secret2 serect3" | awk 'BEGIN {RS=" "; ORS=" "} {key=substr($1,length($1)); print key}'

This should return whatever is in the last space of each string...

Try doing a bulk insert instead. I didn't test this....


BULK INSERT my_table_tmp
FROM '"{$input}"'
WITH (fieldterminator = ',' ,roterminator = '\n')

http://www.linuxtutorialblog.com/post/tutorial-conditions-in-bash-scripting-if-statements

input
$ cat vtest
Vouchers For Date :05/01/2009 *...

Can you please provide an example of exactly how you want the output to look. Thanks.

Please provide a better example of input and output that you are looking for.

Try using gawk or nawk instead of awk. You may have to install them and I would recommend doing that if you're able.


or

use sed


echo "secret1 secret2 secret3" | sed 's/[a-z]//g'

$ echo "secret1 secret2 serect3" | awk '{gsub(/[a-z]/,""); print $0}'
1 2 3

There are three standard sources of input and output for a program. Standard input usually comes from the keyboard if it’s an interactive program, or from another program if it’s processing the other...

Okay, finally got back to finishing this off, I hacked it up pretty ugly but it works as intended so here it goes...

Example Input:

$ cat ./scripts/tests/beers.dat
1. LIGHT LAGER
1A. Lite...

I will be able to this evening, I will have to make a few modifications to the script and won't have access to my servers till later today.

Definitely, thank you very much for your help with this, much appreciated!

Thanks!

Hi all,

I'm having a little trouble solving a file split I need to get done.

I have the following data:



1. Light
1A. Light Soft
texture: it's soft
color: the color value is that of...

for file in `ls -ltr --time-style=+%s | awk '{now=systime(); del_time=now-2; if($6<del_time && $5=="0") print $7}'` ;do
chmod 777 $file >/dev/null 2>&1
rm -f $file >/dev/null 2>&1
done