editing a text file
Posted 03-26-2012 at 08:58 AM by arn2025
Tags awk, text files
i want to edit this text file and remove the column with the arts and also edit the separator & so that they become columns.
old text
ANNE 2453 3564 M@M.U 1 O&C&TY
JUDE 3453 2345 n@m.u 1 W&Y&TY
wend 3442 3773 h@y.u 1 O&C&TY
fill 3266 7473 g@m.u 1 W&T&TY
feat 3455 5544 1 W&C&TY
carl 3435 6723 1 Y&C&TY
wade 3442 7843 1 L&C&TY
jenw 7863 9028 1 P&C&TY
matt 5637 9034 1 W&C&TY
to this
ANNE 2453 3564 1 O C TY
JUDE 3453 2345 1 W Y TY
wend 3442 3773 1 O C TY
fill 3266 7473 1 W T TY
feat 3455 5544 1 W C TY
carl 3435 6723 1 Y C TY
wade 3442 7843 1 L C TY
jenw 7863 9028 1 P C TY
matt 5637 9034 1 W C TY
old text
ANNE 2453 3564 M@M.U 1 O&C&TY
JUDE 3453 2345 n@m.u 1 W&Y&TY
wend 3442 3773 h@y.u 1 O&C&TY
fill 3266 7473 g@m.u 1 W&T&TY
feat 3455 5544 1 W&C&TY
carl 3435 6723 1 Y&C&TY
wade 3442 7843 1 L&C&TY
jenw 7863 9028 1 P&C&TY
matt 5637 9034 1 W&C&TY
to this
ANNE 2453 3564 1 O C TY
JUDE 3453 2345 1 W Y TY
wend 3442 3773 1 O C TY
fill 3266 7473 1 W T TY
feat 3455 5544 1 W C TY
carl 3435 6723 1 Y C TY
wade 3442 7843 1 L C TY
jenw 7863 9028 1 P C TY
matt 5637 9034 1 W C TY
Total Comments 0