I have a file with about 25 colums separated with '~', but few of the lines have extra tabs ('^') and new line characters ('$'). Is there a way I can delete those characters if they are anywhere before the 25th column in a line?
example:
CLUB000650;12345678;0087788667;NOOP MEMBER ;Sam ;Sam ;31 bridge Rd.$
ABCD00001111;PQRS20393343;0088518295;NORTH AMERICAN DIRECTORY SERV.;TATE;HELLO;123 MAIN STREET;;;LOVELAND;CO;80538;Tate HELLO ;11 STREET^I ; ; ;LOVELAND ;CO;80538 ;N TON 00477 ; ;BLK 9K #C90A FHP MEDIA ;S1741721;2005-06-08 00:00:00;135;1;119.52;0$