How to convert Word ot Text Article to Excel?

V

Vikram Rao

Hi!

I am developing a website (Joomla based) I have about 2000 Articles and the
articles are in the following format (This is a single article):

-----------------------------------------------------------
Title:
4 Secrets To Becoming A Guest On Top Tv Talk Shows

Word Count:
856

Summary:
The phone rings. You hear an authoritative voice say, *Hello, I'm the
producer of...Good Morning America or Oprah, or Larry King Live* or any other
top talk show, you name it. This is your big moment, the break you've been
waiting for. After you catch your breath what do you do?

Producers make an instant assessment of you in thirty seconds--or less. When
you get that coveted call from a producer, you aren't just *talking* to him:
you're auditioning. You are being screened...


Keywords:
media, media coaching, marketing, publicity, PR


Article Body:
The phone rings. You hear an authoritative voice say, *Hello, I'm the
producer of...Good Morning America or Oprah, or Larry King Live* or any other
top talk show, you name it. This is your big moment, the break you've been
waiting for. After you catch your breath what do you do?

Producers make an instant assessment of you in thirty seconds--or less. When
you get that coveted call from a producer, you aren't just *talking* to him:
you're auditioning. You are being screened to be accepted or eliminated as a
guest on their show. How can you pass the audition?

Secret #1: Ask Before You Speak

Before you even open your mouth to start pitching yourself and your story to
the producer, ask them a simple question: *Can you tell me a little bit about
the kind of show you envision?* In other words, ask the producer the angle he
is planning to take.

Doing so has two advantages. First, it gives you a moment to overcome the
shock and to collect your thoughts.

Second, once you hear the producer's reply, you can gear your pitch to the
type of information he's seeking. Listen closely to the angle that he's
interested in and tailor your points to it. Publicists often use this
technique to get their clients booked on shows. They *get* before they *give*
- so they are in a good position to tell only the most pertinent information
about their client.

Secret #2: Wow the Producers with Brevity

Follow the advice of jazz musician Dizzy Gillespie: *It's not how much you
play. It's how much you leave out.* Keep your list of talking points by the
phone when you call a producer (or a producer calls you), so you'll be
succinct. You will already have rehearsed your points so that they'll sound
natural and inviting. Be prepared with several different angles or pitches,
different ways to slant your information. *Nobody gets on these shows without
a pre- interview,* says publicist Leslie Rossman. *Be a great interview but
don't worry about the product you want to sell them because if you're a great
guest and you make great TV, they'll want you.*

And keep in mind the words of Robert Frost: *Half the world is composed of
people who have something to say and can't, and the other half who have
nothing to say and keep on saying it.*

Secret #3: Prove You're Not a Nutcase

If you area nutcase on the air, the producer will lose their job. What
constitutes a nutcase? You may think it's a positive trait to be enthusiastic
(and it is), but anyone who is overly zealous about his passion is considered
a nut. Best-selling author and screenwriter Richard Price talks about this
phenomenon as *The dangerous thrill of goodness.* He says, *What happens is
you can get very excited by your own power to do good.* Don't get carried
away by this thrill.

One way to tell if you're being too zealous is that you're hammering your
point at top speed with the energy of a locomotive pulling that toot lever
non-stop. I remember a man calling me up about how he was single-handedly
taking on Starbucks - who, he felt, had done him wrong. He wanted me to
promote his cause. While this could have been a great David versus Goliath
type story, he was long on emotion and short on facts. Some statistics or
figures would have tempered his mania.

But he also never checked in with me to see if he had my interest. By
talking loudly and barely pausing for a breath, he appeared to be a man who
wouldn't take direction well. His single-mindedness was off- putting, not
engaging.

When you're talking to a producer speak for 30 seconds or so and then check
in by asking, *Is this the kind of information you're looking for?* Listen
for other verbal cues, such as encouraging grunts, or *uh huhs.*

Secret #4: Can You Mark *The Big Point?*

Contributors to the popular radio show *This American Life,* hosted by Ira
Glass, have taken to calling the wrap-up epiphany at the end of a story, *The
Big Point.* This is the moment that the narrator gives his perspective on the
story in an attempt to elevate it from the mundane to the universal.

Another radio personality, Garrison Keillor, is a master at it. He tells
long, rambling stories (not good advice for you), then ties up all the story
strands in a coherent and satisfying way. As a great guest, you want to
illuminate your story with a big standout point that helps the audience see
the significance of your story in their world and the world at large. Rather
than hitting them over the head with a two-by-four, you want to share your
insights with a feather-like touch. By framing your story you alert the
producer to the fact that you're a thinker and can contribute great insights
and clarity to a story thus increasing its appeal.
------------------------------------------------------------------------

My Question is

1. How can I convert it into Excel so that I get Each field in a separate
calumn. I mean Title, Word Count, Summary, Keywords, and Paragraphs. all in
separate calumns.

2. How can I have all paragraphs in a single calumn but with proper breakes
so that when I export it to SQL via csv or so it should appear as individual
paragraph.

3. As each Article is in a separate .txt file, How can I import all the 2000
files in one go?

Thanks and regards
Vikram
 
J

Jacob Skaria

Hi Vikram

If you are looking to have this data in Excel (each row holding one file
information) the below will guide you in the right direction...

--All the files placed in the folder shoudl have exactly the same format as
the sample given.. (You can edit the macro to suit)

--I dont think converting to csv would be feasible as your data already has
commas in between. I would not suggest taking this directly to to SQL...(but
you cannot do that without some coding...try out in the other forums..)

--If you are new to macros..
-Set the Security level to low/medium in (Tools|Macro|Security).
-From workbook launch VBE using short-key Alt+F11.
-From menu 'Insert' a module and paste the below code.
-Get back to Workbook.
-Edit the folder path in the below code
-Run macro from Tools|Macro|Run <selected macro()>


Sub Macro()
Dim fso As Object, objFold As Object, objFile As Object
Dim lngRow As Long, objTemp As Object, strData As String

Set fso = CreateObject("Scripting.FileSystemObject")
Set objFold = fso.GetFolder("d:\text")
For Each objFile In objFold.Files
Set objTemp = fso_OpenTextFile(objFile.Path)
strData = objTemp.ReadAll: objTemp.Close
lngRow = lngRow + 1
Range("A" & lngRow) = objFile.Name
Range("B" & lngRow) = GetData(strData, "Title:", "Word Count:")
Range("C" & lngRow) = GetData(strData, "Word Count:", "Summary:")
Range("D" & lngRow) = GetData(strData, "Summary:", "Keywords:")
Range("E" & lngRow) = GetData(strData, "Keywords:", "Article Body:")
Range("F" & lngRow) = GetData(strData, "Article Body:")
Next
End Sub

Function GetData(strData As String, strString1 As String, _
Optional strString2 As String = "") As String
Dim lngStart As Long, lngEnd As Long
lngStart = InStr(strData, strString1) + Len(strString1) + 1
lngEnd = InStr(strData, strString2) - lngStart
If strString2 = "" Then
GetData = Mid(strData, lngStart)
Else
GetData = Mid(strData, lngStart, lngEnd)
End If
End Function

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top