while using following awk commend I’m getting confused,
The output is not like as the row present in input files, can anyone explain and tell me how to print in the order like in input.
Code:
value=$(awk 'FNR>1 && NR==FNR{a[$2]=$4;next} a[$2]{sum[$2]+=$4} END {for(i in sum){printf i"\t"sum[i]/2"@@";}}' file1.tsv file2.tsv)
echo $value > file.tsv
sed -i 's|@@|\n|g' file.tsv
My shell script below for import data to Oracle
it run okay. but the text display not correct follow order command executed.
=========================Shell Script code=================
#!/bin/sh
#directory = ${1-'pwd'}
#run import data with SQLLoader
runSQLLoader()
{
... (2 Replies)
Hello,
I am trying to print line number/order using this command
awk '{print $0, FNR}' myfilename
11006 A41 1888
11006 A41 1888
11006 A41 1888
11006 A41 ... (2 Replies)
I'm asking for explanation about the output of the diff format when i compare the two files f1 and f2:
root@host1 # cat f1
205226
205237
205250
205255
205262
205274
205307
205403
205464
205477
205500
205520
205626
205759
205766
205776 (2 Replies)
Dear help!
I want to print
The number i is number i
let i=1 to 5
output
should be like
The number 1 is number 1
The number 2 is number 2
The number 3 is number 3
The number 4 is number 4
The number 5 is number 5
Would be gr8 if you mke this with awk
Thanks (7 Replies)
Hi,
I want to print the item in reverse order such that the output would look like
00 50 50 23 40 22 02 96
Below is the input:
00 05 05 32 04 22 20 69
Video tutorial on how to use code tags in The UNIX and Linux Forums. (5 Replies)
Hello
I am working on one script where I am trying to display all the directories which is inside the workspace but somehow it is giving me weird output and this is occurring only with one directory other also having the result.html file inside the directory.
for i in `ls -1 | egrep -iv... (2 Replies)
Discussion started by: anuragpgtgerman
2 Replies
LEARN ABOUT DEBIAN
mongoimport
MONGOIMPORT(1) Mongo Database MONGOIMPORT(1)NAME
mongoimport - the Mongo import tool
SYNOPSIS
mongoimport [OPTIONS]
DESCRIPTION
mongoimport is a tool to import a MongoDB collection from JSON, CSV, or TSV. The query can be filtered or a list of fields to input can be
given.
OPTIONS
--help show usage information
-h, --host HOST
server to connect to (default HOST=localhost)
-d, --db DATABASE
database to use
-c, --c COLLECTION
collection to use (some commands)
--dbpath PATH
directly access mongod data files in this path, instead of connecting to a mongod instance
-v, --verbose
be more verbose (include multiple times for more verbosity e.g. -vvvvv)
-f, --fields NAMES
comma separated list of field names e.g. -f name,age
--fieldFile FILE
file with fields names - 1 per line
--jsonArray
load a json array, not one item per line. Currently limited to 4MB.
--ignoreBlanks
if given, empty fields in csv and tsv will be ignored
--type TYPE
type of file to import. default: json (json,csv,tsv)
--file FILE
file to import from; if not specified stdin is used
--drop drop collection first
--headerline
CSV,TSV only - use first line as headers
COPYRIGHT
Copyright 2007-2009 10gen
SEE ALSO
For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org.
AUTHOR
Kristina Chodorow
10gen January 2010 MONGOIMPORT(1)