Hi all,
I'm new in the unix environment. I'm having a challenge in extracting data from a flat file and convert it to a CSV file format or I should be able to open it with MS Excel.
The input data in my flat file looks like this:
AV00001001155000063637143326711145412082EM SITHOLE... (3 Replies)
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
I have a fixed length file that need to be sorted according to the following rule
IF B=1 ORDER by A,B
Else ORDER by A,C
Input file is
ABC
131
112
122
231
212
222
Output needed
ABC
112
131
122
212
231
222 (1 Reply)
Hi All,
So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command:
export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel
select a.accno,
a.CUR_BL_AM, ... (1 Reply)
Hi Gurus,
Thanks in advance...
I am new to writing shell scripting and help me out reading a flat file with fixed length.
I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file.
Like the following str00001.txt... (2 Replies)
I am new to shell scripting and I have to to the following
I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file.
Like the following str00001.txt
StoreName emailaddress location... (3 Replies)
Hi
Can somebody help me with solution for this PLEASE?
I have a flat file and need to insert delimiters at fixed positions in all the lines so that I can easily convert into EXCEL with columns defined as per their width.
For Example
Here is the file
{
kkjhdhal
sdfewss
sdtereetyw... (7 Replies)
Hello Everyone,
I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table.
Input Data-
------ ------------------------ ---- -----------------
WFI001 Xxxxxx Control Work Item A Number of Records
------ ------------------------... (5 Replies)
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies
LEARN ABOUT DEBIAN
restoredirvbe
RESTOREDIRVBE(3) MBK LOGICAL FUNCTIONS RESTOREDIRVBE(3)NAME
restoredirvbe - restore connectors directions from behavioral view
ORIGIN
This software belongs to the ALLIANCE CAD SYSTEM developed by the ASIM team at LIP6 laboratory of Universite Pierre et Marie CURIE, in
Paris, France.
Web : http://asim.lip6.fr/recherche/alliance/
E-mail : alliance-users@asim.lip6.fr
SYNOPSYS
#include "mlo.h"
int restoredirvbe(ptfig)
lofig_list *ptfig;
PARAMETER
ptfig Pointer to a lofig_list
DESCRIPTION
The restoredirvbe function read the PORT section of the vhdl behavuoiral view of the figure, restores the externals connectors directions
and order them as indicated in the vbe.
RETURN VALUE
restoredirvbe returns 1 on success, 0 if there is an error while reading the vbe file, -1 if their is no vbe.
ERROR
"*** mbk error *** restoredirvbe : no figure given"
The ptfig parameter is NULL.
"*** mbk error *** restoredirvbe : figure %s have more connectors than vbe"
Number of connetors in vbe and in figure must be identical. If the vbe have more connectors, the getlocon function give an error on
the unknown connector.
"*** mbk error *** restoredirvbe : cannot read port well!"
To restore the connectors directions, the vbe description must have a port well.
"*** mbk error *** restoredirvbe : bit_vect neither to nor downto"
In a port section of a vbe, the bit vector must have indication of the sens of incrementation.
EXAMPLE
#include "mut.h"
#include "mlo.h"
lofig_list * getgoodlofig(figname, mode)
char *figname;
char mode;
{
lofig_list *ptfig;
ptfig = getlofig(figname, mode);
restoredirvbe(ptfig);
return ptfig;
}
SEE ALSO mbk(1), lofig(3), locon(3), getlofig(3),
BUG REPORT
This tool is under development at the ASIM department of the LIP6 laboratory.
We need your feedback to improve documentation and tools.
ASIM /LIP6 October 1, 1997 RESTOREDIRVBE(3)