search and return adjacent value
I have a file as follows
3010,123456789,4103,123.56,5101,123
3010,987654321,3011,abcde,4103,15000.00,5103,654
3010,654987321,4103,4523.69,5104,987
I need to search for the value 4103 and return the value after it eg. 123.56
|