Splitting a file more than 30 GB size with specific condition [Closed]

 Blocked Profile -
I have a file name "xzy.dat". It is of size more than 30 GB.

The content of file would be something like this

12345678 244466 2017101820171021 00077898 00011111 00022222

Above record is a bad record. A normal record would look something like this

12345678A244466 2017101820171021 00077898 00011111 00022222

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.

Thank You,

1 reply

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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!