need python expert that is good with file management
I have a large file of texts with random information and i need this information extracted and reformatted
the files are structured like this
Name :: Albert S Chou
Ph# :: 4083547634
Add :: 15208 Stratford, CT
City :: Monte Sereno
State:: CA
Zip:: 95030
Ssn:: 7314
Dob :: 04-17-1929
Mmn::Chang
Exp :: 02-2024
CCn:: 6011-2088-9878-1490
Cvc::
Bal:: 6964
Avl:: 13036
Lp:: 899 DEC 2ND
Dp:: 35 JAN 2ND
i need a output as such NAME|ADDRESS|CITY|STATE|ZIP|DOB|SSN
example file: https://gofile.io/d/6tLFNI
any help is appreciated and will be rewarded
I have a large file of texts with random information and i need this information extracted and reformatted
the files are structured like this
Name :: Albert S Chou
Ph# :: 4083547634
Add :: 15208 Stratford, CT
City :: Monte Sereno
State:: CA
Zip:: 95030
Ssn:: 7314
Dob :: 04-17-1929
Mmn::Chang
Exp :: 02-2024
CCn:: 6011-2088-9878-1490
Cvc::
Bal:: 6964
Avl:: 13036
Lp:: 899 DEC 2ND
Dp:: 35 JAN 2ND
i need a output as such NAME|ADDRESS|CITY|STATE|ZIP|DOB|SSN
example file: https://gofile.io/d/6tLFNI
any help is appreciated and will be rewarded