CSV formatting



Knightmare
07-09-2005, 11:04 PM
I want to import a CSV file into microsoft word and format it in columns. I
have imported it already. I can find & replace the comma with spaces, but it
still leaves me with an irregular second and third columns. (IE: address
book input with name,email address,etc. comes in:
xxx xxxxx,xxxxxxx@xxxx.com
xxxxxx xxxxxxx,xxxxxxx@xxxx.com
I can get it to separate as follows:
xxx xxxxx xxxxxxx@xxxx.com
xxxxxx xxxxxxx xxxxxxx@xxxx.com. I need the email address to be at
the same tab location. Can anyone explain what to do?
Jim

Jay Freedman
07-09-2005, 11:04 PM
On Wed, 22 Jun 2005 06:53:06 -0700, "Knightmare"
<Knightmare@discussions.microsoft.com> wrote:

>I want to import a CSV file into microsoft word and format it in columns. I
>have imported it already. I can find & replace the comma with spaces, but it
>still leaves me with an irregular second and third columns. (IE: address
>book input with name,email address,etc. comes in:
>xxx xxxxx,xxxxxxx@xxxx.com
>xxxxxx xxxxxxx,xxxxxxx@xxxx.com
>I can get it to separate as follows:
>xxx xxxxx xxxxxxx@xxxx.com
>xxxxxx xxxxxxx xxxxxxx@xxxx.com. I need the email address to be at
>the same tab location. Can anyone explain what to do?
>Jim

Hi Jim,

"Tab" is the magic word. Instead of replacing the commas with spaces,
replace them with tab characters (the code for a tab in the Replace
box is ^t). Then select all the text and set tab stops, either on the
ruler or by using the Format > Tabs dialog.

The underlying cause of the misalignment is that most fonts are
"proportional" -- different characters have different widths. Only a
few fonts (Courier New, Lucida Sans Typewriter) are "nonproportional",
or the same width for every character.

You may get some useful info at
http://www.word.mvps.org/FAQs/Formatting/SettingTabs.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

TF
07-09-2005, 11:04 PM
A possibility is to import the CSV and then use the Table, Text to Table
command selecting comma as the column separator.

You could also force Word to align the email address at the @ sign by using
the Decimal Align tab. (The decimal align tab will align at the first
'punctuation character' as long as it isn't the default thousands separator
(which is the comma in the UK).

--
Terry Farrell - Word MVP
http://word.mvps.org/

"Knightmare" <Knightmare@discussions.microsoft.com> wrote in message
news:39A93529-5F8C-48A5-AA64-E49D4E398500@microsoft.com...
:I want to import a CSV file into microsoft word and format it in columns.
I
: have imported it already. I can find & replace the comma with spaces, but
it
: still leaves me with an irregular second and third columns. (IE: address
: book input with name,email address,etc. comes in:
: xxx xxxxx,xxxxxxx@xxxx.com
: xxxxxx xxxxxxx,xxxxxxx@xxxx.com
: I can get it to separate as follows:
: xxx xxxxx xxxxxxx@xxxx.com
: xxxxxx xxxxxxx xxxxxxx@xxxx.com. I need the email address to be
at
: the same tab location. Can anyone explain what to do?
: Jim

Knightmare
07-09-2005, 11:04 PM
Thanks for the input. Sounds simple enough, I'll give it a try in the morning.

Jim

"Jay Freedman" wrote:

> On Wed, 22 Jun 2005 06:53:06 -0700, "Knightmare"
> <Knightmare@discussions.microsoft.com> wrote:
>
> >I want to import a CSV file into microsoft word and format it in columns. I
> >have imported it already. I can find & replace the comma with spaces, but it
> >still leaves me with an irregular second and third columns. (IE: address
> >book input with name,email address,etc. comes in:
> >xxx xxxxx,xxxxxxx@xxxx.com
> >xxxxxx xxxxxxx,xxxxxxx@xxxx.com
> >I can get it to separate as follows:
> >xxx xxxxx xxxxxxx@xxxx.com
> >xxxxxx xxxxxxx xxxxxxx@xxxx.com. I need the email address to be at
> >the same tab location. Can anyone explain what to do?
> >Jim
>
> Hi Jim,
>
> "Tab" is the magic word. Instead of replacing the commas with spaces,
> replace them with tab characters (the code for a tab in the Replace
> box is ^t). Then select all the text and set tab stops, either on the
> ruler or by using the Format > Tabs dialog.
>
> The underlying cause of the misalignment is that most fonts are
> "proportional" -- different characters have different widths. Only a
> few fonts (Courier New, Lucida Sans Typewriter) are "nonproportional",
> or the same width for every character.
>
> You may get some useful info at
> http://www.word.mvps.org/FAQs/Formatting/SettingTabs.htm.
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
>

Knightmare
07-09-2005, 11:04 PM
Jay Freedman gave me some good advice also. I will probably experiment with
both of them. I am inputing about 3600 Karaoke song, artists, and ID's and
its been a nightmare.

Thanks,
Jim

"TF" wrote:

> A possibility is to import the CSV and then use the Table, Text to Table
> command selecting comma as the column separator.
>
> You could also force Word to align the email address at the @ sign by using
> the Decimal Align tab. (The decimal align tab will align at the first
> 'punctuation character' as long as it isn't the default thousands separator
> (which is the comma in the UK).
>
> --
> Terry Farrell - Word MVP
> http://word.mvps.org/
>
> "Knightmare" <Knightmare@discussions.microsoft.com> wrote in message
> news:39A93529-5F8C-48A5-AA64-E49D4E398500@microsoft.com...
> :I want to import a CSV file into microsoft word and format it in columns.
> I
> : have imported it already. I can find & replace the comma with spaces, but
> it
> : still leaves me with an irregular second and third columns. (IE: address
> : book input with name,email address,etc. comes in:
> : xxx xxxxx,xxxxxxx@xxxx.com
> : xxxxxx xxxxxxx,xxxxxxx@xxxx.com
> : I can get it to separate as follows:
> : xxx xxxxx xxxxxxx@xxxx.com
> : xxxxxx xxxxxxx xxxxxxx@xxxx.com. I need the email address to be
> at
> : the same tab location. Can anyone explain what to do?
> : Jim
>
>
>

TF
07-09-2005, 11:04 PM
3600 Karaoke songs - nightmare!

Terry

"Knightmare" <Knightmare@discussions.microsoft.com> wrote in message
news:7C209641-250D-4DD9-BFD8-D3856DF3FE24@microsoft.com...
: Jay Freedman gave me some good advice also. I will probably experiment
with
: both of them. I am inputing about 3600 Karaoke song, artists, and ID's
and
: its been a nightmare.
:
: Thanks,
: Jim
:
: "TF" wrote:
:
: > A possibility is to import the CSV and then use the Table, Text to Table
: > command selecting comma as the column separator.
: >
: > You could also force Word to align the email address at the @ sign by
using
: > the Decimal Align tab. (The decimal align tab will align at the first
: > 'punctuation character' as long as it isn't the default thousands
separator
: > (which is the comma in the UK).
: >
: > --
: > Terry Farrell - Word MVP
: > http://word.mvps.org/
: >
: > "Knightmare" <Knightmare@discussions.microsoft.com> wrote in message
: > news:39A93529-5F8C-48A5-AA64-E49D4E398500@microsoft.com...
: > :I want to import a CSV file into microsoft word and format it in
columns.
: > I
: > : have imported it already. I can find & replace the comma with spaces,
but
: > it
: > : still leaves me with an irregular second and third columns. (IE:
address
: > : book input with name,email address,etc. comes in:
: > : xxx xxxxx,xxxxxxx@xxxx.com
: > : xxxxxx xxxxxxx,xxxxxxx@xxxx.com
: > : I can get it to separate as follows:
: > : xxx xxxxx xxxxxxx@xxxx.com
: > : xxxxxx xxxxxxx xxxxxxx@xxxx.com. I need the email address to
be
: > at
: > : the same tab location. Can anyone explain what to do?
: > : Jim
: >
: >
: >

Knightmare
07-09-2005, 11:04 PM
Thanks a lot. I used the text to table conversion, double columned and come
out with a usable print that will get me thru this weekend. I will try some
further experiments next week when I have more time to experiment.

"TF" wrote:

> 3600 Karaoke songs - nightmare!
>
> Terry
>
> "Knightmare" <Knightmare@discussions.microsoft.com> wrote in message
> news:7C209641-250D-4DD9-BFD8-D3856DF3FE24@microsoft.com...
> : Jay Freedman gave me some good advice also. I will probably experiment
> with
> : both of them. I am inputing about 3600 Karaoke song, artists, and ID's
> and
> : its been a nightmare.
> :
> : Thanks,
> : Jim
> :
> : "TF" wrote:
> :
> : > A possibility is to import the CSV and then use the Table, Text to Table
> : > command selecting comma as the column separator.
> : >
> : > You could also force Word to align the email address at the @ sign by
> using
> : > the Decimal Align tab. (The decimal align tab will align at the first
> : > 'punctuation character' as long as it isn't the default thousands
> separator
> : > (which is the comma in the UK).
> : >
> : > --
> : > Terry Farrell - Word MVP
> : > http://word.mvps.org/
> : >
> : > "Knightmare" <Knightmare@discussions.microsoft.com> wrote in message
> : > news:39A93529-5F8C-48A5-AA64-E49D4E398500@microsoft.com...
> : > :I want to import a CSV file into microsoft word and format it in
> columns.
> : > I
> : > : have imported it already. I can find & replace the comma with spaces,
> but
> : > it
> : > : still leaves me with an irregular second and third columns. (IE:
> address
> : > : book input with name,email address,etc. comes in:
> : > : xxx xxxxx,xxxxxxx@xxxx.com
> : > : xxxxxx xxxxxxx,xxxxxxx@xxxx.com
> : > : I can get it to separate as follows:
> : > : xxx xxxxx xxxxxxx@xxxx.com
> : > : xxxxxx xxxxxxx xxxxxxx@xxxx.com. I need the email address to
> be
> : > at
> : > : the same tab location. Can anyone explain what to do?
> : > : Jim
> : >
> : >
> : >
>
>
>


CSV formatting