OK, it appears I have muddied the waters by only explaining what I think I need.
Given that my knowledge is poor at best i'll explain the whole problem to try and give it context which will hopefully help.
I have a file which contains a hex value of 01 at the beginning of each 'record' and a hex value of '03' at the end of each record.
Within each record there are several 'lines' of data that end with a hex value of '0D0A'
So the data would look like this (crlf signifies a carriage return/line feed)
If I look at it in a HEX viewer I see
The problem I have is that the application I need to put the file into has the following restrictions
- The ^A character(hex value of 01) needs to be replaced with a space(hex value 20). So, I want to replace hex 01 with hex 20
- The ^C character(hex value 03) needs to be replaced with a carriage return and two line feeds(hex values 0D 0A 0A). So, I want to replace hex 03 with hex 0D 0A 0A.
What I want to end up with is
Hopefully that makes what i'm aiming for a little clearer and apologies for not being accurate enough initially.
Suppose I have a file which has 1000 columns (5 SHOWN FOR EXAMPLE)
two alphabets are separated by a space and then tab
A A"\t"C C"\t"G G"\t"0 0"\t"T T
A G"\t"C C"\t"G G"\t"A T"\t"0 0
G A"\t"0 0"\t"G C"\t"A A"\t"T C
whenever there is a 0 0 in any column, the output should be printed as
A... (12 Replies)
I have the following file consisting of dates and sample measurements:
05��Oct��2010 1.31��
06��Oct��2010 1.32��
07��Oct��2010 1.31��
The hex characters are \xc2\xa0 in sequence.
I have tried to remove the characters as follows:
sed -i '' -e 's/\xc2\xa0//g' file.dat
and as follows... (6 Replies)
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... (6 Replies)
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:... (2 Replies)
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... (1 Reply)
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... (8 Replies)
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"... (1 Reply)
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 Replies)