**260**wrote:

I have data of 55000000 rows i want to replace `<*>`

with preceding 3rd column nucleotide.

Format of data is

```
12 1109770 C <*>
12 1109771 T <*>
12 1109772 T <*>
12 1109773 T <*>
12 1109774 C <*>
12 1109775 C <*>
12 1109776 C A,C,C,<*>
```

Output

```
12 1109770 C C
12 1109771 T T
12 1109772 T T
12 1109773 T T
12 1109774 C C
12 1109775 C C
12 1109776 C A,C,C,C
```

**4.5k**• written 21 months ago by Kritika •

**260**

Can you post something you have already tried?

4.5kIs your example correct for the last line ?

12 1109776 C A,C,C,<*>

This should turn to :

12 1109776 C A,C,C,C

not

12 1109776 C C,A,C,C

Am I correct ?

4.5kYes... It should turn to A,C,C,C

260Updated the same again with actual required out put

260Always add some detail on the effort you put in to solving your problem.

25k