Hello perl_vams,
Some tips for getting better answers sooner:
-
Place your code, input data and expected output data inside <code></code> tags. It's impossible to see what your text file contains as your post now is formatted.
-
State what you've tried, and how it fails for you. Show the code itself. You obviously already know that you need to use split as part of your solution, so show your code using split(), whether it gets the desired result or not: then you can receive useful help rather than just educated guesses.
Hope this helps!
The way forward always starts with a minimal test.