Insert space or pattern between columns in a data file in a specified format

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Insert space or pattern between columns in a data file in a specified format

Shivakumar
Input .csv file present in a single column and different rows, as data recieved from the Database
SUBDIV_ID SUBDIV_MDE TRKDATAVER
 958 EXPLICIT 60
 999 STOP 3
 965 EXPLICIT 43
 841 STARTUP 3
 953 STARTUP 5
 972 STOP 3
 990 STOP 4

Expected Output:
SUBDIV_ID        SUBDIV_MDE      TRKDATAVER
 958                 EXPLICIT              60
 999                 STOP                   3
 965                 EXPLICIT              43
 841                 STARTUP              3
 953                 STARTUP              5
 972                 STOP                   3
 990                 STOP                   4