Joey you are spot on my friend. Were I more knowledgabkle with the code I'm sure i could explain this better because I know from working at large companies that its fairly common to use commands, snmpgets, etc to pull raw data then format that to a csv or something similar and then import it into a database for others to access via websites or reporting tools.
I've gotten to the point I can pull this data in via scripts, for loops or whatever but getting it into a format that a database or a spreadsheet app likes afterwards has been the tricky part for me.
So to better explain what I'm doing here is the output of a command that tells me most the info I need about a server, its HBAs and the storage it has:
I'm using some simple awk commands to format this data as I listed in the first post. I don't have to use three different files, one would suffice and your cat/tr command combo against that one file would make it one row that I can then redirect to a master list.
So step one of my process would be to:
1. Run the command above in a loop against a list of a few hundred servers.
2. Pipe this data to a temp file per server as the loop is executed
3. Run your cat/tr command against the temp file and >> to my master list
4. Repeat until I have each server in my master list!
This works perfectly for me but being I'm not very knowledgable on the subject I would love to here yours or anyones opinion on how best to do this as I'm sure this is done often by server admins, network guys, etc for various admin reporting.
I have a datafile having structure like
col1,col2,col3
col1,col2,col3,col4,col5
col1,col2,col3,col4,col5
.....
Can we take only first row of values from datafile and put into respective variable.
How col1 can be captured in a variable called v_col1 from unix script.
like first row(only)... (1 Reply)
hi
how do i manipulate .csv file to add an extra row after each row using shell script?
I need a blank line added for each 1000 records in my file?
I will then need to copy and paste some data in the blank row created.
thanks 4 ur support
neil (3 Replies)
I have a csv file, which is > 2 Gigs. I need to BCP that file to Sybase db , but I cant upload that b'caz first row of the file is failing. ( having some errors probably.) I can manually insert the first line into db & then I can upload the rest of the data in file, if i can delete the first row.
... (2 Replies)
Hello Team,
In the below code....The variabe values are not fetch from input table into SELECT statements.
===========================
#!/usr/bash
DATABASE=XXXXX
inputFILE=$1
db2 connect to $DATABASE
TABLENAME=`echo $inputFILE|awk '{print $1}'`
COLUMNNAME=`echo $inputFILE|awk... (2 Replies)
Hello,
am I new to awk, and I am tryint to:
INPUT FILE:
"73423555","73423556","73423557","73423558","73423559"
OUTPUT FILE:
73423555
73423556
73423557
73423558
73423559
My useless code so far:
#!/bin/awk -F ','
BEGIN
{
i=0;
} (8 Replies)
Hi Fellows,
I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem:
I have csv files in the following pipe-delimited format:
Column1|Column2|Column3|Column4|NEWLINE
Address Type|some descriptive... (4 Replies)
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
All,
I guess by this time someone asked this kind of question, but sorry I am unable to find after a deep search.
Here is my request
I have many files out of which 2 sample files provided below.
File-1 (with A,B as column headers)
A,B
1,2
File-2 (with C, D as column headers)
C,D
4,5
I... (7 Replies)
Hi,
I have to find the count of rows starting with "E," in given a.csv file .
Sample Data File.
E,2333AED,A,MC3,25,31-MAY-18
E,2333AED,A,MC3,25,31-MAY-18
CYMC3 25AED 0000
E,2333CZK,A,MC3,25,31-MAY-18
CYMC3 25CZK 0000
E,2333EUR,A,MC3,25,31-MAY-18... (3 Replies)
I have a source csv file consists of first field as variable name, and the rest are site-specific information (converted from excel file, where site -specific values in columns). I am trying to create a file for every site using a template and replace the multiple variables with values from the... (3 Replies)
Discussion started by: apalex
3 Replies
LEARN ABOUT MOJAVE
platform::shell
platform::shell(n) Tcl Bundled Packages platform::shell(n)
__________________________________________________________________________________________________________________________________________________NAME
platform::shell - System identification support code and utilities
SYNOPSIS
package require platform::shell ?1.1.4?
platform::shell::generic shell
platform::shell::identify shell
platform::shell::platform shell
_________________________________________________________________DESCRIPTION
The platform::shell package provides several utility commands useful for the identification of the architecture of a specific Tcl shell.
This package allows the identification of the architecture of a specific Tcl shell different from the shell running the package. The only
requirement is that the other shell (identified by its path), is actually executable on the current machine.
While for most platform this means that the architecture of the interrogated shell is identical to the architecture of the running shell
this is not generally true. A counter example are all platforms which have 32 and 64 bit variants and where a 64bit system is able to run
32bit code. For these running and interrogated shell may have different 32/64 bit settings and thus different identifiers.
For applications like a code repository it is important to identify the architecture of the shell which will actually run the installed
packages, versus the architecture of the shell running the repository software.
COMMANDS
platform::shell::identify shell
This command does the same identification as platform::identify, for the specified Tcl shell, in contrast to the running shell.
platform::shell::generic shell
This command does the same identification as platform::generic, for the specified Tcl shell, in contrast to the running shell.
platform::shell::platform shell
This command returns the contents of tcl_platform(platform) for the specified Tcl shell.
KEYWORDS
operating system, cpu architecture, platform, architecture
platform::shell 1.1.4 platform::shell(n)