How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have a list of several hundred entries that always begin

Customer Question

Hi, I have a list of several hundred entries that always begin with a date/time and always end with a string of different numbers. There is a bunch of stuff in the middle that I do not need and I would like to have the computer automatically delete from each entry so I do not have to do it by hand. Is there any way to do this using word or another text editor? I am using a Macbook and I have MS Office and Pages installed.
Here is an example of what I am trying to do:
Example entry/line:
05/19-07:43:43.079789 [Drop] [**] [1(###) ###-####3] ET SCAN NMAP -sS window 1024 [**] [Classification: Attempted Information Leak] [Priority: 2] {TCP} 99.999.999.6:55400 -> 88.888.888.88:8118
And I need it to look like this:
05/19-07:43:43 99.999.999.6:55400 -> 88.888.***-**-****
But there are a lot of lines!
Thanks
Submitted: 1 year ago.
Category: Microsoft Office
Customer: replied 1 year ago.
(Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Live Phone Call. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Expert:  The-PC-Guy replied 1 year ago.
cannot do a phone call, is it already in excel format?
Customer: replied 1 year ago.
No it's just listed in lines of text, each entry is its own line though
Expert:  The-PC-Guy replied 1 year ago.
i mean can each entry be in its own cell?
Customer: replied 1 year ago.
what do you mean? each entry is similar to the sample i sent that starts with date/time and ends with numbers -> numbers. currently they're listed as so:entry 1
entry 2
entry 3i'd like them to stay the same, but only with date/time and numbers... the middle stuff needs to be deleted from each line
Customer: replied 1 year ago.
they're currently in text format, and they were pasted onto a blank word document. not excel document
Expert:  The-PC-Guy replied 1 year ago.
can you send an excel sample file?
Expert:  The-PC-Guy replied 1 year ago.
if its textit will not be possible
Expert:  The-PC-Guy replied 1 year ago.
sorry, each one would need to be in its own cell.
Customer: replied 1 year ago.
is there a quick way to do that from word to excel
Expert:  The-PC-Guy replied 1 year ago.
if each line has a full carrage return after each one, it may be possible to write a macro to split into cells
Expert:  The-PC-Guy replied 1 year ago.
the carrage returns can be read, or new line character can be read by the program
Expert:  The-PC-Guy replied 1 year ago.
i would still need to see an example to make sure the lines are similar
Customer: replied 1 year ago.
yes it is in that format, each one is a new line. but i was told
Customer: replied 1 year ago.
ok
Expert:  The-PC-Guy replied 1 year ago.
you can send a word doc would be fine
Expert:  The-PC-Guy replied 1 year ago.
also if this can be done it will not be cheap, just wanted you do be aware of that upfront
Customer: replied 1 year ago.
then ill just have to find another way
Customer: replied 1 year ago.
thank you for letting me know
Expert:  The-PC-Guy replied 1 year ago.
the good news is that when you copy and paste into excel they all go into separate cells, so it can be done with a complex formula
Expert:  The-PC-Guy replied 1 year ago.
they all seam to be in a similar format
Customer: replied 1 year ago.
excellent. yes they each have their own line, just different words in the middle thats all
Expert:  The-PC-Guy replied 1 year ago.
i can do it for $50
Customer: replied 1 year ago.
no thanks
Expert:  The-PC-Guy replied 1 year ago.
ok, suit yourself, if you change your mind you know how to reach me
Customer: replied 1 year ago.
i don't think that will be happening, but have a nice day
Expert:  The-PC-Guy replied 1 year ago.
sure, remember this is how I make a living. I know it can be done and automated with the formula, so all you would have to do is copy and paste
Customer: replied 1 year ago.
good sir: the living of every individual is based on money, including yours and mine. i was quite clear in my description and about my offer, per site policy. you needn't have accepted it.
Customer: replied 1 year ago.
please release my question to other experts
Customer: replied 1 year ago.
as my only other option is to give you less than 3 stars. thank you
Expert:  Suryanto replied 1 year ago.
Hi,
Welcome to Justanswer
I am Suryanto and i will assist you if you still need help
Thank you