wk on csv files
Hi I have two csv files
1 ) keys.csv with data as below
2) source.csv file with data like
output needed is after comparing files the 2nd field from first file should get appended to where ever the 1st field from file 1 matches with field 3 from second file
i.e sample output
tried below it does not work any pointers on what could be wrong ?
I have a file as follows:
1,"This is field 2",3,4,5
2,"This is field 2 it can contain one , comma",3,4,5
3,"This is field 2 it also, can, contain, more",3,4,5
4,"This is field 2 without extra commas",3,4,5
and i pass this through to awk:
awk -F, ' {
if (... (3 Replies)
Hello People
I have the following file.csv:
date,string,float,number,boolean
20080303,abc,1.5,123,Y
20080304,abc,1.2,345,N
20080229,nvh,1.4,098,Y
20080319,ugy,1.9,586,N
20080315,gyh,2.4,345,Y
20080316,erf,3.1,932,N
I need to filter the date field where I have a data bigger than I... (1 Reply)
Hi
Here is my script that calls my awk script
#!/bin/bash
set -x
dir="/var/local/dsx/csv"
testfile="$testfile"
while getopts " f: " option
do
case $option in
f ) testfile="$OPTARG";;
esac;
done
./scriptFile --testfile=$testfile >> $dir/$testfile.csv
It calls my awk... (1 Reply)
Hi All,
I am new to shell scripting..My problem is i want to give multiple csv files as input to awk script and process the data into one file..
My input file is
File1 File2 File3
Product Location Period SalesPrice
A x 8/11/2010 ... (7 Replies)
I have 2 files pipe delimted and want to merge them based on a key
e.g file 1
123$aaa$yyy$zzz
345$xab$yzy$zyz
456$sss$ttt$foo
799$aaa$ggg$dee
file 2
123$hhh
345$ddd
456$xxx
888$zzz
so if the key is the first field, and the result should be the common key between file 1 and 2 (6 Replies)
Dear awk users,
I am trying to use awk to match records across two moderately large CSV files. File1 is a pattern file with 173,200 lines, many of which are repeated. The order in which these lines are displayed is important, and I would like to preserve it. File2 is a data file with 456,000... (3 Replies)
Hi,
I am new to awk/unix and am trying to put together an awk script to perform an action similar to vlookup between the two csv files.
Here are the contents of the two files:
File 1:
Date,ParentID,Number,Area,Volume,Dimensions
2014-01-01,ABC,247,83430.33,857.84,8110.76... (9 Replies)
Hello Gentlemen,
Finding difficulties to play with my Input files:confused: . Your guidance will certainly help as always.
After converting to csv file from XLSM file, I am getting some extra ""(double quote) characters which I want to terminate inside shell script and process it further.
... (6 Replies)
Hello all,
I have searched high and low for a solution to this, many have come really close but not quite what I'm after.
I have 2 files. One contains GUID's, for example:
8121E002-96FE-4C9C-BC5A-6AFF20DACECD
84468F30-F3B7-418B-81F0-0908E80792BF
A second file, contains a path to the... (8 Replies)
Hello everyone!
I have thousands of csv files I have to import into a Database table. As usually the files aren't perfect. For example they have a different number of columns and some weird columns.
The second problem is, that I have to add 3 parts of the filename into 3 rows in the... (6 Replies)
Discussion started by: elRonaldo
6 Replies
LEARN ABOUT DEBIAN
sss_ssh_knownhostsproxy
SSS_SSH_KNOWNHOSTSPR(1) SSSD Manual pages SSS_SSH_KNOWNHOSTSPR(1)NAME
sss_ssh_knownhostsproxy - get OpenSSH host keys
SYNOPSIS
sss_ssh_knownhostsproxy [options] HOST [PROXY_COMMAND]
DESCRIPTION
sss_ssh_knownhostsproxy acquires SSH host public keys for host HOST, stores them in a custom OpenSSH known_hosts file (see the
"SSH_KNOWN_HOSTS FILE FORMAT" section of sshd(8) for more information) /var/lib/sss/pubconf/known_hosts and estabilishes connection to the
host.
If PROXY_COMMAND is specified, it is used to create the connection to the host instead of opening a socket.
ssh(1) can be configured to use sss_ssh_knownhostsproxy for host key authentication by using the following directives for ssh(1)
configuration:
ProxyCommand /usr/bin/sss_ssh_knownhostsproxy -p %p %h
GlobalKnownHostsFile2 /var/lib/sss/pubconf/known_hosts
This is an experimental feature, please use http://fedorahosted.org/sssd to report any issues.
OPTIONS -p,--port PORT
Use port PORT to connect to the host. By default, port 22 is used.
-d,--domain DOMAIN
Search for host public keys in SSSD domain DOMAIN.
-h,--help
Display help message and exit.
SEE ALSO ssh(8), ssh_config(5), sss_ssh_authorizedkeys(1).
AUTHORS
The SSSD upstream - http://fedorahosted.org/sssd
SSSD 03/04/2013 SSS_SSH_KNOWNHOSTSPR(1)