Sponsored Content
Full Discussion: Flat file to csv conversion
Top Forums Shell Programming and Scripting Flat file to csv conversion Post 302405643 by p1_ben on Friday 19th of March 2010 10:51:23 AM
Old 03-19-2010
Perfect - thank you very much!!!!
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Flat File Conversion Format

Hi all, I've a flat file in this format: = " Record 1 Field1 -> XXXX Field2 -> 9558 Field3 -> 55AA Record 2 Field1 -> YYYY Field2 -> 12345 Field3 -> aa23 " And i want to convert it to (4 Replies)
Discussion started by: Loobian
4 Replies

2. Shell Programming and Scripting

Awk to convert a flat file to CSV file

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)
Discussion started by: rkumudha
14 Replies

3. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies

4. Shell Programming and Scripting

conversion of spaces into CSV format file

INput file attached in thread : Column widths at 24,73,82,87,121 characters (sed 's/./,/24;s/./,/73;s/./,/81;s/./,/87;s/./,/121;s/ *, */,/g' fixedinputfile >output.csv ). The client wants instead of hard coding the column widths as they are not fixed .he has given the hint stating that ( ... (3 Replies)
Discussion started by: sreenath1037
3 Replies

5. Shell Programming and Scripting

reading a csv file and creating a flat file

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)
Discussion started by: mprakasheee
3 Replies

6. Shell Programming and Scripting

perl : number to date conversion in CSV file

I have a CSV file in the below format. while generating CSV file from excel sheet , date in excel sheet(Format :Mon 8/28/2012) got converted into the below format with numbers 41148,41149 so on. Could anyone please let me know how to the convert the numbers(41148,41149 so on.) to its actual... (2 Replies)
Discussion started by: giridhar276
2 Replies

7. UNIX for Dummies Questions & Answers

Conversion of flat file to Mainframe file

Hi guys, I have a flat file created by ETL tool. Now the flat file has 4 columns. 1st column is a Character(17), 2nd Column Character(4), 3rd column is a decimal column and 4th column is also a decimal column. I have to convert this file into a Mainframe file in the following format. ... (4 Replies)
Discussion started by: mac4rfree
4 Replies

8. Shell Programming and Scripting

awk Flat File Conversion Script

In awk how would I flatten input.txt to output.txt? Input: givenname: Darth sn: Vadar mail: d.vadar@deathstar.com uid: dv12345 orclguid: 1234567890 givenname: Carlito sn: Brigante mail: c.brigante@paradise.com uid: cb12345 orclguid: 2134567890 Output: ... (3 Replies)
Discussion started by: u20sr
3 Replies

9. UNIX for Dummies Questions & Answers

Convert flat file to csv

Hi I have a file like this: a=1 b=2 c=3 a=4 b=2 d=3 a=3 c=4 How can I change this to csv format a,b,c,d 1,2,3,, 4,2,,3 3,,4,, Please use code tags next time for your code and data. Thanks (10 Replies)
Discussion started by: sandip_2014
10 Replies

10. UNIX for Beginners Questions & Answers

Conversion of Binary csv file

Hello, I have a binary csv file that was created on 'Red Hat Enterprise Linux Server release 6.6'. Now we have transferred all files on Ubuntu 16.04.2 LTS/xenial On opening the file in Ubuntu, there are special characters ... (8 Replies)
Discussion started by: nans
8 Replies
otr_parse(1)							   User Commands						      otr_parse(1)

NAME
otr_parse, otr_sesskeys, otr_mackey, otr_readforge, otr_modify, otr_remac - process Off-the-Record Messaging transcripts SYNOPSIS
otr_parse otr_sesskeys our_privkey their_pubkey otr_mackey aes_enc_key otr_readforge aes_enc_key [newmsg] otr_modify mackey old_text new_text offset otr_remac mackey flags snd_keyd rcv_keyd pubkey counter encdata revealed_mackeys DESCRIPTION
Off-the-Record (OTR) Messaging allows you to have private conversations over IM by providing: o Encryption o No one else can read your instant messages. o Authentication o You are assured the correspondent is who you think it is. o Deniability o The messages you send do not have digital signatures that are checkable by a third party. Anyone can forge messages after a conversa- tion to make them look like they came from you. However, during a conversation, your correspondent is assured the messages he sees are authentic and unmodified. o Perfect forward secrecy o If you lose control of your private keys, no previous conversation is compromised. The OTR Toolkit is useful for analyzing and/or forging OTR messages. Why do we offer this? Primarily, to make absolutely sure that tran- scripts of OTR conversations are really easy to forge after the fact. [Note that during an OTR conversation, messages can not be forged without real-time access to the secret keys on the participants' computers, and in that case, all security has already been lost.] Easily- forgeable transcripts help us provide the "Deniability" property: if someone claims you said something over OTR, they will have no proof, as anyone at all can modify a transcript to make it say whatever they like, and still have all the verification come out correctly. EXTENDED DESCRIPTION
The following commands are supported: otr_parse Parse OTR messages given on stdin, showing the values of all the fields in OTR protocol messages. otr_sesskeys our_privkey their_pubkey Shows our public key, the session id, two AES and two MAC keys derived from the given Diffie-Hellman keys (one private, one public). otr_mackey aes_enc_key Shows the MAC key derived from the given AES key. otr_readforge aes_enc_key [newmsg] Decrypts an OTR Data message using the given AES key, and displays the message. If newmsg is given, replace the message with that one, encrypt and MAC it properly, and output the resulting OTR Data Message. This works even if the given key was not correct for the orig- inal message, so as to enable complete forgeries. otr_modify_mackey old_text new_text offset Even if you can't read the data because you do not know either the AES key or the Diffie-Hellman private key, but you can make a good guess that the substring "old_text" appears at the given offset in the message, replace the old_text with the new_text (which must be of the same length), recalculate the MAC with the given mackey, and output the resulting Data message. Note that, even if you don't know any text in an existing message, you can still forge messages of your choice using the otr_readforge command, above. otr_remac mackey flags snd_keyid rcv_keyid pubkey counter encdata revealed_mackeys Make a new OTR Data Message, with the given pieces (note that the data part is already encrypted). MAC it with the given mackey. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-im-client | +-----------------------------+-----------------------------+ |Interface stability |Volatile | +-----------------------------+-----------------------------+ SEE ALSO
pidgin(1), attributes(5) Off-the-Record Messaging, at http://www.cypherpunks.ca/otr/ NOTES
Written by the OTR Dev team (otr@cypherpunks.ca). Updated by Brian Cameron, Sun Microsystems Inc., 2007. SunOS 5.11 13 Nov 2007 otr_parse(1)
All times are GMT -4. The time now is 03:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy