Simplest thing to use would be the OUTFIL slash (/) operator
Well, this might be with the assumption that the user wants to split the record precisely at the same position for all records within data set. RahulG31 can correct me if my assumption is wrong with his response.
Venkata Ramayya wrote:
I have a record like below it should be split into two records it finds 'where'
Not sure if the text "where" will always be at static offset for each record, you can consider using PARSE.
That's true Kerry. The TS mentioned that he had 'a' record. Since he didn't mention that he had a number of those records, I assumed that there is only a single record. In that case, the position/length is fixed and it is easy to use only the OUTFIL slash (/) operator.
If the position is Not fixed then it can be made fixed by using PARSE (as you had mentioned) and then use OUTFIL slash (/).