Remove character from a column in each line

Shell Programming and Scripting
1

Hi,

I am a newbie to shell scripting (.sh). Please guide me on how to do the below issue.

My input file has below data.
I want to remove $ sysmbol from the fourth column of each line. (ie, between 4th and 5th pipe symbol)

ABC25160|51497|06/02/2010|$32,192.07|MARK|$100|A
ABC08053|95149|06/02/2010|$47,904.95|TIM|$100|A
ABC53615|28172|14/02/2010|$40,636.85|CHRIS|$100|A
ABC88924|45149|21/02/2010|$30,363.69|TOM|$100|A

Please help
Sreejith

2

The problem is there is not spacing between your | if you had a space you could use awk and sed. With that being said if the value you're wanting to change is $100 and is the same in the file then you can use tr command.

3

Something like this?

awk -F"|" 'sub(".",x,$4)' OFS="|" file
4

Maybe try this:

jasonralph-> cat test_file.txt 
ABC25160|51497|06/02/2010|$32,192.07|MARK|$100|A
ABC08053|95149|06/02/2010|$47,904.95|TIM|$100|A
ABC53615|28172|14/02/2010|$40,636.85|CHRIS|$100|A
ABC88924|45149|21/02/2010|$30,363.69|TOM|$100|A

jasonralph-> awk -F\| '{ sub(/^\$/, "", $4); print}' OFS="|" test_file.txt 
ABC25160|51497|06/02/2010|32,192.07|MARK|$100|A
ABC08053|95149|06/02/2010|47,904.95|TIM|$100|A
ABC53615|28172|14/02/2010|40,636.85|CHRIS|$100|A
ABC88924|45149|21/02/2010|30,363.69|TOM|$100|A