By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,500 Members | 2,520 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,500 IT Pros & Developers. It's quick & easy.

how to output an text file with other type of delimeters

P: n/a
hi,
we're trying to output a text file in other format including delimeters
(; instead of , ) and changing text delimeters too any way to do it from
vb ??
thx


*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Joe:

You will need to change the delimiter in the output specification, and then
reference the specification in code.

Alternatively, you can create a specification by inserting into the
MSysIMEXSpecs and MSysIMEXColumns tables.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Joe Saliba" <jo*******@hotmail.com> wrote in message
news:lp***************@news.uswest.net...
hi,
we're trying to output a text file in other format including delimeters
(; instead of , ) and changing text delimeters too any way to do it from
vb ??
thx


*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #2

P: n/a
On Fri, 06 May 2005 21:34:09 GMT, Joe Saliba <jo*******@hotmail.com> wrote:
hi,
we're trying to output a text file in other format including delimeters
(; instead of , ) and changing text delimeters too any way to do it from
vb ??
thx


*** Sent via Developersdex http://www.developersdex.com ***


Presumably the text file is generated from a report. In the design of the
report add: &"{delininator} " every place where you want a special
delininator to be placed. Leave a space between the deliminator and the
closing quote.

=[FirstName] & "; " & [Phone] & "; " & "prints semicolons" will print like
this:
Chuck; 123-456-7890; prints semicolons

Chuck
....

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.