Search Results

oh here are the scripts. :(

hi Chubler_XL, though i think this is already working perfectly fine, is it possible to do some final adjustments/modifications to this code?

it seems that the script works when you have key...

Thanks you guys, i think the first one you posted works just fine, i guess.

Thanks a lot for all your help! :b:

wow, that's a really clever thing you did there. really brilliant idea.

Though, does it really have to be "none" with quotation marks(" ")?

it seems that when i put only none, it doesn't work....

hi Chubler_XL, thanks again for your reply.
you have no idea, how much i appreciate it.

i apologize if i still have concerns, even after such a long conversation.

it's just that for this 2nd...

thanks again Chubler_XL, sir, for this.

though please bare with me for my questions again. i really want to learn all these codes that you've helped me with.

so this is the code before, right?...

hi Chubler_XL, my man, this is so cool, i tried executing the code you posted, and i actually changed 7 to 4 in EXC, because it worked the first time,

So for the first scenario, NO second file:
$...

okay, thanks for the answers to those questions. i really appreciate it a lot.

so in the change that you made to the code:
FILENAME != "-" {sub(/,.*$/,"");if(FNR>1)EXC[$0]; next}
!($7 in...

here is what the second file looks like.
It is a csv file(comma delimited), the header row/first line of this 2nd file should be ignored/skipped as well.

$ cat flagfile.csv
UPC,name...

hi guys, thanks a lot for your replies,

it seems that the problem is the FTP transfer mode i used,

before i used binary mode, which resulted to this error..

i changed the Transfer type to...

im sorry if i dont understand your suggestion correctly.. is it like this?

$ sh getsums.sh -vx ft-GNCT-3398-CD-2012-07-07-140112.txt.gz " " 22 23 1 2 4

.:Summation Tool:.
getsums.sh[36]: ^M: ...

$ cat getsums.sh |head -39
#!/usr/bin/sh
.
.
.
for FILE in ${FILENAME}
do >> line 39
gzip -t ${FILE} 2>/dev/null

hi guys,

here's the code

$ cat getsums.sh
#!/usr/bin/sh
FILENAME=$1
DELIMITER=$2
FIRST_COL=$3
SECOND_COL=$4
SALESDATE_COL=$5
STOREID=$6
UPC=$7
GTIN=$8
PROMOID=$9
echo ""
echo...

Thanks again Chubler_XL for your inputs, i really appreciate it.

so basically, the arguments would be like this:

$1 = ft-gnct-3398-cd-2012-07-07-140112.txt.gz (1st filename)
$2 = " "
$3 =...

no sir, i just need help that's all, and i just want to learn how to this particular modification, and it's a bit different.
i'm just honestly seeking for help from you guys.

---------- Post...

hi there, Chubler_XL, thanks a lot for your reply.

Although, do i need to add it to every if/elif statement?

and also, i'm not quite familiar with this EXC command, what exactly would it do?
...

hi guys,

i have a script that basically just sums up the values of 2 particular columns in a file, grouped by the columns specified as well

The script is quite long, but it's basically just...

hmm okay, thanks a lot for your help! it's getting pretty late here already, it's 1 in the morning, and im already sleepy, i'll add these in my script, and maybe show it to you tomorrow, if i bump...

oh yeah, got it, forgot about that, so i'll just put an if statement in the begin section, to check if there's a 2nd or 3rd file.

i'm actually getting the hang of it now, that getline suggestion...

okay, i'm taking all your suggestions into consideration, coz I basically don't know what's the best thing to do here, so

in that BEGIN section, is it okay if the file that i will load there is...

hmm okay, how about the scenario where i want some rows to be ignored when they are summed?

how can i add to the script, where in it also references to the 2nd and 3rd file, to look for some...

i have this script that basically sums two columns in a file, but does not group data.. and does not consider records to be ignored, so i wanted to add that function to improve this script..

it...

1. The problem statement, all variables and given/known data:
Hi guys, i'm a new guy here, and it's my first time creating a unix script.
can you guys help me out here? i'd really appreciate it. :(...

it's actually a project in class, and it's due next week, i would really really appreciate it if you could help me in this. thanks a lot man.

oh im terribly sorry about this. :(

i created a new thread with this title just now: "HELP with Unix scripts in summing columns in a file."

and im basically a noob, and i dont know how to do...