New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Manipulating a data file
I hate doing these. With a passion.
Just got handed a text file made up of a couple thousand of these data records.
Some data record with a md5 on it#:#/1 - Keep/some file name.pdf;
All of the data runs together in one large paragraph. What I need to do is get rid of everything before the #/ and stick a line space where the ending ; mark is. And continue on from there.
I found how I think to do the line break. Any ideas of a command line comment to get rid of the first half of that? We just need a file listing the file names and the trailing file type.
thanks
You should be proud of me. I just spelled Manipulating correctly on the first try. Major shock.
Comments
Congratulations drmike for achieving this!
Not sure about last line with # but you can easily get read of it input_nl.txt
I wound up doing a
sed 's .\{53\} ' test2.txt >> test3.txtto get rid of the first section of each line. That worked for me. Not prefect but I can clean up the couple of lines where it messed up.
Thanks