That's beautiful. Thanks Jim
-----Original Message-----
From: Jim Frice [mailto:Jim.Frice@...]
Sent: Thursday, November 30, 2000 12:59 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Customer List
Go back to the report builder report and put in delimiters where you would
like them and them export again. We use "*" or the "|" but any character
that won't be in your data to be a delimiter. A little trick is to create a
line by itself in report builder with only the delimiters. Highlight that
line and change the font color to white. Make copies of that line and then
click and drag them into the data lines that you want to be broken into the
columns. This way if you actually print the report the delimiters don't show
up. Also have the data merge left so it moves over to the delimiter to keep
things lined up nicely and eliminate spaces before the data in excel.
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
-----Original Message-----
From: Jim Frice [mailto:Jim.Frice@...]
Sent: Thursday, November 30, 2000 12:59 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Customer List
Go back to the report builder report and put in delimiters where you would
like them and them export again. We use "*" or the "|" but any character
that won't be in your data to be a delimiter. A little trick is to create a
line by itself in report builder with only the delimiters. Highlight that
line and change the font color to white. Make copies of that line and then
click and drag them into the data lines that you want to be broken into the
columns. This way if you actually print the report the delimiters don't show
up. Also have the data merge left so it moves over to the delimiter to keep
things lined up nicely and eliminate spaces before the data in excel.
> -----Original Message-----We no longer allow attachments to files. To access/share Report Files,
> From: Todd Hofert [mailto:thofert@...]
> Sent: Thursday, November 30, 2000 11:16 AM
> To: Vantage List (E-mail)
> Subject: [Vantage] Customer List
>
>
> I am trying to extract the top 200 customers for 2000 from our db so I can
> do a year end mailing to them. I have an rb report that lists my
> customer in
> order of sales $. When I export the file I get a txt file with no
> delimiters. It's a mess when opened into Excel. Any suggestions how I can
> pull this off?
>
> Thanks
> Todd Hofert
> Spartan Graphics, Inc.
> (616)887-8243
>
>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:
> http://www.egroups.com/files/vantage/
> (Note: If this link does
> not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)