I have a list of letters that that need to be changed. It's working for the 150th letter but not for 2nd letter for instance. For example, if I change the script (awk line) to change the second letter A to C, it doesn't work. It doesn't give me an error message but returns the text unchanged. I'm using cygwin on a windows machine
Thanks
Amir
When I invoke the script I provided in message #4 in this thread as follows:
then the only difference between files mtDNA_GATK_reference_letters.txt and out is that the first line changed from:
to:
which shows that the 2nd "A" in the file changed from "A" to "C". I'm running this on OS X instead of Cygwin on Windows. But the script I provided should work on any system with a POSIX conforming awk and a shell that processes variable substitution as required by the POSIX standards. (Although you will need to change #!/bin/ksh to specify a path to such a shell on your system.)
I note that the awk scripts provided by pamu use -F "" which works on some systems to treat every input character as a separate field, but produces unspecified results on other systems. I don't know how Cygwin's awk treats that construct. On OS X it prints the diagnostic:
I agree that the awk script provided by rdrtx1 in message #3 in this thread doesn't do what you requested, but I don't see any reason why the awk script provided by rdrtx1 in message #7 in this thread shouldn't do exactly what you're requesting with obvious changes to the settings for the variables p, r, and l depending on which occurrence of which character you want to change to what.
However, none of our scripts will work if you want the characters acgt to be counted and replaced as equivalent to the characters ACGT, respectively. To make any of these script work, all of your input characters need to be in uppercase. You should be able to fix your input by running the commands:
We could also all change our scripts to work with mixed case input, but I don't see any reason to do that given your specified requirements.
This User Gave Thanks to Don Cragun For This Post:
I will appreciate if you help me here in this script in Solaris Enviroment.
Scenario:
i have 2 files :
1) /tmp/TRANSACTIONS_DAILY_20180730.txt:
201807300000000004
201807300000000005
201807300000000006
201807300000000007
201807300000000008
2)... (10 Replies)
Hi,
I have a file with multiple lines(fixed width dat file). I want to search for '02' in the positions 45-46 and if available, in that lines, I need to replace value in position 359 with blank. As I am new to unix, I am not able to figure out how to do this. Can you please help me to achieve... (9 Replies)
I have a requirement where i need to split a file based on occurence of a character which is present at a fixed position. Description is as below:
1. The file will be more than 1 Lakh records.
2. Each line will be of fixed length of 987 characters.
3. At position 28 in each line either 'C' or... (9 Replies)
Hi,
I am in need of help for the two things which is to be done.
First, I have a file that has around four columns. The first column is filled with letter "A".
There are around 400 lines in the files as shown below.
A 1 5.2 3.2
A 2 0.2 4.5
A 1 2.2 2.2
A 5 2.1 ... (2 Replies)
Hi,
i want find the character '-' in a file from position 284-298, if it occurs i need to replace it with 'O ' for the position in the file. How to do that using SED command.
thanks in advance,
Sara (9 Replies)
Greetings,
We have a requirement where we need to loop in a fixed width file in linux and remove a character based on a position for every record. It would highly appreciate if someone can help to automate this.
Appreciate your time and help!
Regards (3 Replies)
How to extract multiple data based on character position. I need to fetch from 7-9 and 22-26 and there is no delimiter for 22-26 since it is part of the column. The file may have more than 1000 character long.I managed to pull any one but not both
for example
test data
12345 zxc vbnmlk... (1 Reply)
Hi,
I have following format in file aaa with content below, and would like to seek help from forumer about how to change and swap the position on 2nd field.
5874957|901125|
95874960|650614|
95874966|870308|
901125 to be changed as 25-11-1990 for eg
Can someone help please ?? :)
... (6 Replies)
Hi,
I have an urgent task here. I am required to sort a flat file based on multiple columns which are based on the character position in that line. I am restricted to use the character position instead of the space and sort +1 +2 etc to do the sorting.
I understand that there is a previous... (8 Replies)
Hi ,
I am required to view the fixed postion file very often . I am looking for the utility like this
if the file has a one or multile line
abcdefghijklmnopqr
Utility should make my file look like this
12345678910111213141516--------------------------
abcdefghijk l m n o p q r ... (4 Replies)