Need help to format one txt file to required format
Hello Everyone,
I have one source file which is genarated by SAP in different format(Which I've never seen). I need to convert that file to required format and I need to read this target file from Datastage to use this in my Jobs. So I do not have any other options except to use Unix script to modify this file. I am not that expert in Unix so I would like to take Ideas from all of you, it may help us to complete this task.
I am attaching my source file to this thread and below is my required output format.
Can anyone please let me know is it possible to do this through Unix or not?
Hi all,
i have a file toto.txt :
blabla;toumtoudoum;blablabla
toumtoudoumtoudoum;blabla;popopopo
blablabla;etcetcetc;blabla
etc....
As you can see, it is a simple file containig 3 fields separated by a ";".
What i want to do is to display this file with a nice formating... (4 Replies)
Hi
I have a file which has ascii , binary, binary decimal coded,decimal & hexadecimal data with lot of special characters (like öƒ.ƒ.„İİ¡Š·œƒ.„İİ¡Š· ) in it. I want to standardize the file into ASCII format & later use that as source .
Can any one suggest a way a logic to convert such... (5 Replies)
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
I have some files created in Excel that have to be saved as .txt files in order to load them into our accounting system. I can save the files as .txt files through Excel, but I then have to open them in TextPad and do a save as to change the Format from PC to UNIX. Is there a way to skip this step... (2 Replies)
Hi All,
I have a file with content
FLIGHT PLANS PRODUCED ON 26.08.2008(SORTED BY FPLAN NUMBER) RUN DATED 27/08/08 PAGE 1
--------------------------------------------------------------
FPLAN FPLAN PRE BTCH BATCH POST BTCH BATCH BATCH ... (1 Reply)
I have a short time to solve a problem, so I need some help. I've searched the forum, but I couldn't find a solution to my problem.
I made a script to filter some text and now I have a new requirement to make it available as html table. Problem is that I more than one files with different set... (2 Replies)
Hi,
I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix.
My requirement here is that i want to do it automatically using a... (5 Replies)
Hello All,
I have File_all.txt which have content as below
Volume in drive E is Data
Volume Serial Number is 586D-6932
Directory of E:\mydi2\siudfor\TFG058
03/27/2014 09:59 PM 5,569 FX\FX01 my4_pg4_MON_20140327_C.zip
1 File(s) 5,569 bytes
... (5 Replies)
My file format:
--------------------------------------------------
Complete Consistency Check
Valid Area : VALID:VALID
Started by : esanwad
Started at : Thu Dec 11 16:04:46 2014
CNA version : R21H04_EC08
Check range : AREA VALID/VALID
... (4 Replies)
I have a text file with contents like this:
a,b,c,
d~e,f,g,h~i,j
,k,l,m~n,o,p,q~
I need to convert this file into this format unix shell script commands:
a,b,c,d~
e,f,g,h~
i,j,k,l,m~
n,o,p,q~
as you may have noticed, I need to retain the ~ signs at the end.
Any help is greatly... (3 Replies)
Discussion started by: harsha1238
3 Replies
LEARN ABOUT DEBIAN
mcxconvert
mcx convert(1) USER COMMANDS mcx convert(1)
NAME
mcx convert - convert between mcx storage types
SYNOPSIS
mcx convert <matrix-file-in> <matrix-file-out>
mcx convert [--write-binary] --cone-to-stack <cat-file-in> <cat-file-out>
mcx convert [--write-binary] --stack-to-cone <cat-file-in> <cat-file-out>
mcxconvert is not in actual fact a program. This manual page documents the behaviour and options of the mcx program when invoked in mode
convert. The options -h, --apropos, --version, -set, --nop, -progress <num> are accessible in all mcx modes. They are described in the mcx
manual page.
mcx convert [--cone-to-stack (transform cone file to stack file)] [--stack-to-cone (transform stack file to cone file)] [--write-binary
(output native binary format)] [--cat (read and write cat format)] [-cat-max <num> (limit the stack conversion to <num> matrices)]
In the two-argument invocation without additional arguments, mcx convert converts from the format found in the first file to the other for-
mat, i.e. from native interchange to native binary format or the other way around. When querying with the -q option, mcx{convert} will out-
put a one-line synopsis describing the matrix in the argument. The --cone-to-stack and --stack-to-cone options convert between the two types
of concatenated output provided by mclcm.
DESCRIPTION
The mcl libraries make extensive use of matrices. Matrices are used to encode graphs, matrices and clusterings. They can be stored either
in interchange or in binary format. The latter is somewhat more efficient in storage and much faster in both reading and writing, but the
default is interchange format.
The mcl input routines recognize the type of storage they are dealing with. If you want to convert a matrix to the other storage type, sim-
ply specify the file name of the matrix you want to convert. mcx convert will recognize its type, and write the other type to the file
specified as the second argument.
OPTIONS
--cone-to-stack (transform cone file to stack file)
This option requires two trailing options, the names of respectively the source cone file and the target stack file.
--stack-to-cone (transform stack file to cone file)
This option requires two trailing options, the names of respectively the source stack file and the target cone file.
--cat (read and write cat format)
-cat-max <num> (limit the stack conversion to <num> matrices)
--write-binary (output native binary format)
This option is only useful with either of the options --cone-to-stack, --stack-to-cone, or --cat.
AUTHOR
Stijn van Dongen.
SEE ALSO
mcxio(5), and mclfamily(7) for an overview of all the documentation and the utilities in the mcl family.
mcx convert 12-068 8 Mar 2012 mcx convert(1)