File1 :
File2 :
Required output is
Please suggest shell script to resove this.
Last edited by Scott; 09-11-2018 at 05:13 AM..
Reason: Please use code tags properly, not just randomly placed variations of <code>, [ICODE] and [HTML]
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Hi can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database (2 Replies)
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies
LEARN ABOUT DEBIAN
nxconvert
NXCONVERT(1) General Commands Manual NXCONVERT(1)NAME
nxconvert - convert a NeXus file between different on disk file formats
SYNOPSIS
nxconvert [-x|-h4|-h5|-d|-o keepws|-o table] [infile [outfile]]
DESCRIPTION
NeXus supports different file formats for physical storage on disk or other media. nxconvert allows the user to convert a file to a dif-
ferent backend.
If no output file is supplied on the command line, the program asks for one interactively. Same if the input file is not given.
OPTIONS
The following options are supported:
-x make outfile XML
-h4 make outfile HDF4 (this is the default)
-h5 make outfile HDF5
-d make a XML based definition file used for validating NeXus files (i.e. remove the data).
-o keepws
the XML file created should preserve whitespace.
-o table
the XML file created should write the data in a table format where the columns and rows are easily imported into spreadsheet pro-
grams.
SEE ALSO
http://www.nexusformat.org
AUTHOR
nxconvert was originally written by Freddie Akeroyd and Ray Osborn.
This manual page was written by Tobias Richter <Tobias.Richter@diamond.ac.uk> and may be used by others.
June 2010 NXCONVERT(1)