Search Results

Thank you, it works with nawk, not sure why,

it just errors:
awk: illegal statement near line 1
awk: bailing out near line 1

I'm expecting like this:

1|Friends|$3.99 per 1,000 listings|8158

Hi, could some help me convert CSV file (with double quoted strings) to pipe delimited file:

here you go with the same data:

1,Friends,"$3.99 per 1,000 listings",8158here " 1,000 listings "...

awesome! thanks a lot.!

Problem now:
c=2
d=3
nawk -F, -v v1=a-v v2=b '{ a[$7]++ } END {
if ( a[v1] >= 1 || a[v2] >= 1 )
print "print data between $c and $d";
}' import_data.csv

it...

yet again :)

---------- Post updated at 09:47 PM ---------- Previous update was at 09:43 PM ----------

it works like this:
nawk -F, -v v1="RC" '{ a[$7]++ } END { for (b in a) { print b } }'...

it fails again :(

Sorry this is the error i find continuously:
awk -F, -v v1 = "RC" '{ a[$1]++ } END { for (b in a) { print b } }' import_data.csv
awk: syntax error near line 1
awk: bailing out near line 1

Thank you, but please to explain...

Friends, please help me with this: i have the following csv file:

Cat, 4
Cat, 4
Cat, 3
Rat, 4
Rat, 5
Cow,6

This csv file is parsed and found that it contains Cat, Rat, Cow in it. now i...

For this input:
1000,Y,$2 ,10000,Students Plan
1001,M,$2 ,10001,Professional Plan
1002,M,$3 ,10002,Talk 199
1003,Y,$5 ,10003,Simple 30
1004,M,$3 ,10004,Flat 300

The insert is:
insert into...

hello!, but there is a requirement to do it with shell scripts, so that we have our own environment set up to execute it in appworx... it will be scheduled everymonth and this script will be executed...

Hi Anchal, Thanks it worked for me. But I just have a question, how to let my code go directly to the II row I column right after it does with I row I column?

for example: right after 1000, i...

Thanks a lot, Atul. I think your code should help me. I will give out a try and let you know shortly.

Here is how the CSV should look like.
1000,Y,$2 ,10000,Students Plan
1001,M,$2...

Friends,

This is what I need:

I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a...

Friends,

This is what I need:

I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a...