Search Results

awk -F, '$6!="\"\"" ' infile
Hi,

A little explanation will be of great help

Thanks

I think using a comma between the email addresses will do the work.

Thanks Pravin.
But can you check the second row, last column.
The code will delete that also
$ cat x.csv
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient...

Hi,

I want to delete the null values that are present in all the columns except the last column
$ cat x.csv
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient...

Hi,

I am generating 20 csv's and I am sending it to the client in one mail.

But it is awkward to open 20 csv's one by one.

Can somebody tell me how to generate the data in one csv's but...

Ohh I resolved the issue of the space ...i replace the \t with " " and it worked...

Thanks very much.

Why was it not working in my code ?
Can you please explain the code that you have written

Thanks

---------- Post updated at 01:28 AM ---------- Previous update was at...

Hi,
I am having a problem in the below code:-.

$ cat x.csv
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient
baseball,NULL,8928192,Most...

Thanks Franklin

Hi,

I am having problem in deleting the leading spaces:-

cat x.csv
baseball,NULL,8798765,Most played
baseball,NULL,8928192,Most played
baseball,NULL,5678945,Most played...

Yes it is cygwin bash shell...that i executed the script

yes Cgwin

I am not sure if you are asking for this :-
$ cat f1.sh
#!/bin/sh
Rundate=`date +%Y-%m-%d`
echo $Rundate
Filecrtdate=`date +%Y-%m-%d`
echo $Filecrtdate

if [ $Filecrtdate == $Rundate ]
then...

grep -i "search_string" log_filename
status=$?
if [ $status -eq 0 ]
then
echo "grep successful"
else
echo "unsucessful"
fi

Hi,

I have a problem in dollar substitution:-
$ csv1="first_csv"
$ csvnumber=1
$ echo {csv$csvnumber}
{csv1}
$ echo "${csv$csvnumber}"
bad substitution

I want first_csv...why is it not...

Thanks for the explanation Franklin.It was really of great help

From the last two days, I am seeing you guys are solving the issues like any thing else. I am overwhelmed by the quick and thorough...

It worked...
Thanks very much..
Can you please explain it, so that it can be useful to me...
and also I can make some modification if it is necessary...

Hi,
It is giving the below error:-
awk 'BEGIN{FS=OFS=","}!a[$1] {print;a[$1]++;next}{print "\t"$2,$3,$4}' input.csv

awk: syntax error near line 1
awk: bailing out near line 1

Hi,

I am presently stuck in a csv file.

INPUT CSV

baseball,NULL,8798765,Most played
baseball,NULL,8928192,Most played
baseball,NULL,5678945,Most played...

It is a sybase stored procedure...

Some lines of the stored procedure are:-

select
"Counter Number" ,",",
"Counterparty1" ,",",
.........
........
from table
...

Hi,
I don't want to hard code the things.

I am able to generate a csv file where the data is coming in all the columns properly from the procedure.I am running the procedure in the shell...

Atleast please tell me for the above three columns that I have posted, so that i can get some insight and idea....

Another thing that i can do is, I can delete the spaces between any header names...

@Franklin & Tyler,

Thanks for the reply.
Still it is hard coding in the script giving the header names directly. If that the case then my lines were working fine.

But i want a generic...

Hi,
I am able to generate a csv file which has 3 columns. But the header is not coming out exactly i.e it doesnot have a comma in between it but the data is getting produced with the comma.
The...