Split the Record...
Posted: Wed Sep 07, 2011 5:26 am
Hi All,
I have one flat file which has 3 columns. I have mentioned below the metadata of the file.
ColumnName DataType
Name Varchar 6
Salary Varchar 6
Company Varchar 6
My problem is There is no delimiter in any one of the records. All the records are in sameline.
Ex:
Pravin50000GoogleMoses70000Target
Above I mentioned just for 2 records. Like that It may have many number of records.
Now I need to split the each record one by one and store the corresponding records into corresponding columns.
Hope I have clearly explained my problem to you people
Any help is really appreciated.
I need my output
Name Salary Company
Pravin 50000 Google
Moses 70000 Target
This file is a fixed length
I have one flat file which has 3 columns. I have mentioned below the metadata of the file.
ColumnName DataType
Name Varchar 6
Salary Varchar 6
Company Varchar 6
My problem is There is no delimiter in any one of the records. All the records are in sameline.
Ex:
Pravin50000GoogleMoses70000Target
Above I mentioned just for 2 records. Like that It may have many number of records.
Now I need to split the each record one by one and store the corresponding records into corresponding columns.
Hope I have clearly explained my problem to you people
Any help is really appreciated.
I need my output
Name Salary Company
Pravin 50000 Google
Moses 70000 Target
This file is a fixed length