Search Results

I am running an ISQL command on Sybase DB and getting output of a query in an CSV file.

The issue is that all the data comes in to the same column, i want them to be separated in different...

Hi Rudi,

Actually the query which i provided was dummy query in my actual query i am using the output of the first query in to the second one. The exact query is given below:

select...

I have one script as below:
#!/bin/ksh
Outputfile1="/home/OutputFile1.xls"
Outputfile2="/home/OutputFile2.xls"
InputFile1="/home/InputFile1.sql"
InputFile2="/home/InputFile2.sql"
echo "Select...

I know you are correct, But the problem you mentioned arises only when your requirement is that you want dates between 1st and last date of every month or you want the report to be generated after 30...

Thanks Junior helper!! it works perfectly. :)

It looks perfect... Let me try this and get back to you!!

Hi,

I tried below link. It gives me output but little weared.
https://www.unix.com/shell-programming-and-scripting/124557-how-get-date-n-months-before-unix.html

Actually my requirement is not...

can we do something like:

if[current month is january] then
subtract 1 from the year and make the month as 12;
else
subtract one from the month;
fi


Is this logic possible?

----------...

Hi Ravinder,

I have already tried it but it does not recognise the flag d. :(

Hi,

I want two dates one will be the current date and the other one will be just one month before. Say if current month is 11/4/2014 then the other date should be 11/3/2014.
#!/bin/ksh...

Thanks a ton Akshay that works perfectly! :D

Hi Akshay,

This is giving me all the columns but they all are coming in the same cell.
I am redirecting the output to a .xls file as below:

perl -lape '$F[0] = join(" ", $F[0] =~...

Thanks alot!
Thankyou for giving the guidance.. I tried your Perl script and it works perfectly! :)

But i have one problem. Actually my text file looks like below:

jan16201413:17PM abc def...

Thanks but i dont have perl also... :(

I dont have gawk!

---------- Post updated at 03:01 AM ---------- Previous update was at 03:00 AM ----------

Hi Don,

Can you please tell me which part of your suggested code adds space after...

Thanks sir it works like charm! :o but the only problem with this is i am not getting space before PM it is coming like below:
jan 16 2014 13:17PM
I want it to be
jan 16 2014 13:17 PM

I have a text file as below:

jan16201413:17PM
jan1620143:17PM
jan1620143:17PM
jan1620143:17PM
jan1620143:17PM


I want to add a delimeter which will be space to the date part as below:...

thanks.. :(
But it do send me a mail with a proper xls file with four columns.

You are correct i was talking about the one leading space inside the xls file.

---------- Post updated at 07:33 AM ---------- Previous update was at 07:18 AM ----------

my actual code is below:...

I tried your code it doesn't work for me.. :(
and i have a excel file with .xls extension. I am doing all the data processing in text file and finally transferring it to the xls file.

the xls...

Hi Don,

sorry for the confusion and the mess created by me. :(
I have only the xls file which has this data

column1 column2 column3 column4

16 jan 1994 _alia1 ...

Ok so its very simple i have a text file okay which has four columns like below:
column1 column2 column3 column4

16 jan 1994 _alia1 22 chennai
17 jan 1994 ...

It gives an error to me saying sed -r is not recognized

---------- Post updated at 08:03 AM ---------- Previous update was at 08:02 AM ----------



The space count is one for that column...

okay lets make my question very simple.
I have an excel sheet in which i just want to sed one space which is coming in the second column data.

column1 column2 column3 column4...

Input file File1:
xyz Date Name Age State
------------------------------------------------------------------------------------...