Hi ,
I need to remove the 5th character of column1 and print the rest.
Can anybody give some advice?
Input:
0001c xx
0001r gg jj
0002y vv
0002p kk
0003q gg ll
0003v tt
0003t gg pp kk
Output:
0001 xx
0001 gg jj (9 Replies)
Hi ,
I have a file with contents as below:
Contract Cancellation Report UARCNCL
LOS CODE DATE REAS TYPE AMOUNT AMOUNT LETTER BY
========= ======= ==== ==== ==== ========= ==== ====
8174739 7641509 1S NONE CRCD 30-JUN-2008 NPAR N .00 .00 CCAN
8678696 8091709 1S NONE DDEB 30-JUN-2008... (14 Replies)
Hi Guy's can someone help me in converting the following
I have a flat text file which has several thousand lines which I need to convert to a csv it's got a consistent format but basically want every time it hit's txt to create a new line with the subsequent lines comma delimited for example
... (6 Replies)
Need help - hopefully I explain it correctly
I have a table in mysql database with multiple fields.
2 of the fields are called id and id_link
id id_link
93 http://test_server/testpage.cgi?93
95
96
97
98
I need to find the correct sql to update all of the id_link... (2 Replies)
hi
i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized
#----------------
FILENAME="$1"
SCRIPT=$(basename $0)
#-----------------------------------------//
function usage
{
echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Good morning everyone and hello unix.com!
I'm trying to solve a problem and was unable to find a solution after a forum research. So hopefully you can help me get this solved.
I have these two csv files:
file1.csv
ID,REFERENCE,STATUS
1,2,0
2,4,1
3,1,0
file2.csv... (2 Replies)
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output.
$1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Hi All,
I have a csv file which is comma seperated. I need to convert to flat file with preferred column length
country,id
Australia,1234
Africa,12399999
Expected output
country id
Australia 1234
Africa 12399999
the flat file should predefined length on respective... (8 Replies)
Discussion started by: rohit_shinez
8 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)