|I need to amend a csv file that could contain 1 line or 100 lines.|
The file will be sent thus:
Each line has to be changed to
That is add to first column P change the : to . (semicolon to full stop.
The first number (123456789) could be any length from 1 digit to 9 digits.
Hope someone can help Please (pretty please)