Shell Programming and Scripting

I have a pipe delimitated line with 148 columns.

Code:

123|ABC|XYZ|999|8|N|PRA/PA|Search|2|E|WW|KHG|| T |Y|U|KA|9W|K45|

If I need to change a value in different column as below, how do I do that please?
In column 14 change value to 100
In column 30 change value to XY
In column 77 change value to OPQ
In column 135 change value to LCB

Thanks,
Prashant

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

---------- Post updated at 11:12 AM ---------- Previous update was at 11:10 AM ----------

It looks like you've been a number 'awk'-based solutions in the past.
What have you tried yourself so far?

awk '{$14="100";$30="XY";$77="OPQ";$135="LCB";print}' yourfile