Search Results

Hi hanson44,

Thanks much for your update, still it does not work. It is not printing the 4th column , it just printing the 1st CSV file again without the additional column from file2.

Hi Scrutinizer, (https://www.unix.com/members/302052697.html)

I just tried your command , but it did not give me any...

Hi,

Thanks for the replies. I will be more specific.

The 1st CSV file contains 3 columns ( Client Name, Domain and Server Name ).

It will have more than 2000+ entries.

The 2nd CSV...

I tried both from above but didn't work. Any other solutions ?

Dear All,

I have 2 CSV files and want to create a new CSV based on a common value in both of the CSV file.


ColumnA ColumnB ColumnC
Client 1 XXXXX Server A
Client 2 XXXXX ...

Thanks a lot Ahamed, finally it worked :-) ... Thanks a ton for all your help.

---------- Post updated at 09:53 AM ---------- Previous update was at 09:09 AM ----------

Ahamed,

I have one...

The output for the both the commands are same what we were getting before. But in the first command I swapped the file names and it prints the licensed capacity and it's Data perfectly as 1st column....

Ahamed,

I tried just on the command line also , the result is still the same. BTW the OS is SuSE Enterprise Linux 11.

Do you know how can I merge ttwo csv files using awk ? I am planning to...

Server Name, Total Capacity , Server Utilization , Used capacity
servername.domain.name.com,7.8 TB,5.2%,406.9 GB

Hi Ahmed,

Here it is.

sh -x capacity_report.sh
+ echo ' Server Name, Total Capacity , Server Utilization , Used capacity'
++ cat serverlist.txt
+ for i in '` cat gridlist.txt `'
+...

Hi Ahamed,

I just tried your command , without my data variable but still the output is same. My server name is FQDN ( i.e Servername.domainname.com) in the first column. Does that creating any...

Hi Ahmed,

Hi Ahmed - Still the output is same as the above I mentioned.






I am using the code tags for the codes but sometime it doesn't show up. I will verify before posting the...

Hi Ahamed,

This is the output I am getting.

Server Name, Total Capacity , Grid Utilization , Used capacity,Licensed Capacity
,31.00servername,7.8 TB,5.2%,406.9 GB

The value 31.00 should...

Thanks for your update. I will try that out tomorrow and let you know. Let me know if you want me to post the total cap.awk ? I can do that tomorrow.

---------- Post updated 04-04-13 at 08:32 AM...

Here it is, This one works but adds the column from output as column 1. I want that as column 5.

for i in ` cat serverlist.txt ` ; do
command1 | awk -f totalcap.awk >> capacity_report.csv...

Yes , it's in a loop where it will read the server names that the commands should be executed on.

I also thought of doing in another way by creating two CSV files ( 1st one for the 1st output &...

Hi,

Thanks for your quick reply. Yes the second command gives me just one output.

For example from the first output I will get few fields like this.

Server Name, Total Capacity,...

Hi,

Can anyone please explain me how can I add a new column to a Csv file ?

Actaully I am setting one set of commands and creating a CSV file with 4 columns.

I am executing another...

Thanks a ton .. It works like a charm .... Can you explain me the script when you have time or give me a link where I can read more about writing awk scripts ?

Hi,

This is the acutual output of the command.
Attribute Value
------------------------- ----------------------------
State Full Access...

Thanks once again but it is not printing the values of these 3. sorry to keep you bugging

Hi,

I am sorry , the first command i posted works but my command output has couple of other statistics also apart from the 3 I gave in the example. How to pick only those 3 ? like row 3,4 & 5 out...

Thanks for your quick help. How should i run this along with the command ?

command | awk -f <awkfilename> or awk -f <awkfilename> ' command ' ?

Hi All,

I have a question on eliminating spaces from a output.

A command returns me output like this

Attribute Value
--------------- ...

Thank you so much for the info. I will try this one too. Basically I am not using the df -k command , but i just put that here for example but realized later that it is not a right example.

BTW...