If u observe, there's an alphabbet "A"(or any other character) missing from the first example line that i provided at 9th Position. That's clearly wrong. Instead there's a space in that line.
I want to split my 30 GB file in two files in such a way that any string which has a space in that position (9th Position) should be moved to a different file and rest of the good records to another file.
Can this be done? If yes, can you please guide me to do so.
Where did the records come from? Can you open and view it notepad?
Of course you can analyze the file in a powerscript and make the changes. I am not prepared to auther this script for you, as it is inevitable that it will not work as you wish for it to, or it won't do a certain detail that you failed to mention, and I will have to keep working on it. For this reason, we do not provide turn key solutions.
If you wish to post some code and get help from that, I encourage you to go that route!