Replacing Hex Characters In A File Using awk? Post: 302899289

Sponsored Content

Operating Systems HP-UX Replacing Hex Characters In A File Using awk? Post 302899289 by AndyBSG on Monday 28th of April 2014 10:41:25 AM

04-28-2014

Registered User

Here is an example of the file in question

Code:

 
^A{1:F01BNPAGB20AXXX0000000000}{2:I103BARCGB20XXXXN}{3:{108:ORLD190077833XXX}}{4:^M
:20:CCT44195^M
:23B:CRED^M
:32A:140428GBP627,95^M
:33B:GBP632,95^M
:50K:/CH5708686001085122004/TR32793333^M
MSC CROCIERE SA^M
CHEMIN RIEU 12-14^M
GENEVE//CH^M
:52A:BPPBCHGGXXX^M
:57A:BARCGB20XXX^M
:59:/GB65BARC20789880480169^M
Gorkana Group Ltd^M
Discovery House,  28-42 EC1Y8QE Lon^M
don//GB^M
:70:MSC CROCIERE SA - Gorkana Group Ltd^M
. RIF. 647413 30/11/2013^M
:71A:SHA^M
:71F:GBP5,^M
-}^C                                                         ^A{1:F01BNPAGB20AXXX0000000000}{2:I103BARCGB20XXXXN}{3:{108:ORLD190077835XXX}}{4:^M
:20:CCT44196^M
:23B:CRED^M
:32A:140428GBP2703,88^M
:33B:GBP2708,88^M
:50K:/CH5708686001085122004/TR32793355^M
MSC CROCIERE SA^M
CHEMIN RIEU 12-14^M
GENEVE//CH^M
:52A:BPPBCHGGXXX^M
:57A:NWBKGB2LXXX^M
:59:/GB94NWBK50410145129827^M
Worldchoice Enterprises Ltd^M
Worldchoice House PE2 6FT PETERBORO^M
UGH//GB^M
:70:MSC CROCIERE SA - Worldchoice Enter^M
prises Ltd. RIF. 8375 21/10/2013^M
:71A:SHA^M
:71F:GBP5,^M
-}^C                                     ^A

Last edited by AndyBSG; 04-28-2014 at 11:47 AM..

AndyBSG

View Public Profile for AndyBSG

Find all posts by AndyBSG

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replacing all but last Hex characters in a text line

I must remove hex characters 0A and 0D from several fields within an MS Access Table. Since I don't think it can be done in Access, I am trying here. I am exporting a Table from Access (must be fixed length fields, I think, for my idea to work here) into a text format. I then want to run a...

2. HP-UX

Hex characters of ascii file

Hi, Whats the command or how do you display the hexadecimal characters of an ascii file. thanks Bud

3. UNIX for Dummies Questions & Answers

replacing few characters in a file

Hi All, I have huge xml file. The file contains some comment tags . I have requirement to replace comment tag with another comment tag. Say for example : file X has -- Part of the file <?xml version="1.0" encoding="ISO-2"?><translationResults jobDate="20070123 23:20:51"...

4. Shell Programming and Scripting

Help Replacing Characters in Flat File

I was wondering if somebody could help me with something on UNIX. I have a file that looks like this - "nelson,bill","bill","123 Main St","Mpls","MN",55444,8877,william I want to replace all comma with pipes (|), except if the comma is within double quotes. (The first field is an example of...

5. UNIX for Dummies Questions & Answers

replacing the characters in a file

hi i want to replace the characters between positions 2 to 30 in each line in a file how to do it suggestions welcome

6. UNIX for Dummies Questions & Answers

Replacing characters in csv file

Hello all, This is my first post here, so please excuse me if this question is too obvious or has been asked before. I am new to Unix and although I tried to search your forum for the answer to my question, I could not find an answer that would help me. I have a 500MB csv file with numeric values...

7. Shell Programming and Scripting

replacing characters with awk

Hi there! I'm new in this and probably is a quite simple task but I still cannot manage to do it: I have to read some files line by line and then change the input format into another one, but the very first step is to replace the empty variables by error values. I mean, each line looks like:...

8. Shell Programming and Scripting

Replacing hex characters '\x0D' with '\x0D\x0A'

Hello All, I have a requirement where I need to replaced the hex character - '\x0D' with 2 hex characters - 'x0D' & 'x0A' I am trying to use SED - But somehow its not working. Any pointers? Also the hex character '\x0D' can occur anywhere in the line. Can this also be accomplished...

9. UNIX for Dummies Questions & Answers