Thanks pg I am new to Perl and was pointed in Perl's direction to do the task. I am not a programmer which doesn't help. I have tried using split and substr, but the data position is not consistent for all records which doesn't help. Rather than waste your time I will do the fix manually in MS Excel.