find , replace and add a new pattern

Vote count: 0

I have below kind of entries in a file. While I can easily replace RAW to VARCHAR , I am trying to find a way to add a pattern after replacement

For example here is my data

COL1 RAW(64) NOT NULL, COL2 RAW(255) NOT NULL,

here is desired data COL1 VARCHAR (64) FOR BIT DATA NOT NULL, COL2 VARCHAR (255) FOR BIT DATA NOT NULL,

i.e RAW should be replaced with 'VARCHAR' - this part I am able to do using awk , however I am not sure ow to add 'FOR BIT DATA'

asked 36 secs ago

Manish26

Let's block ads! (Why?)

find , replace and add a new pattern