Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace commas in a string

Status
Not open for further replies.

CryoGen

MIS
Joined
Apr 15, 2004
Messages
86
Location
US
I have a data string that I need to display with commas that are not separated by spaces. When I go to display these values, the string doesn't wrap because of the lack of spaces and it's doing nasty things to may layout.

This is a simple event listing (see below).

Code:
6-9 Jul
Event 1
Location 1
Staffer1,Staffer2,Staffer3,Staffer4

I've tried to fumble my way through this using the REReplace function ... here's what I've tried:

Original:
Code:
<TD width="348" 
#dates#<BR>
event#, #city#, #state#<BR>
#staff#
</TD>

Failed hack attempt:
Code:
<TD width="348" 
#dates#<BR>
event#, #city#, #state#<BR>
#REReplace("staff", ",", ", ")#
</TD>

Any help is appreciated.
 
i think this may work for you
Code:
#ReplaceNoCase(staff,",",", ","ALL")#

or i think you can use
Code:
#ListChangeDelims(staff, ", ", ",")#


=========================================
I have not failed. I've just found 10,000 ways that won't work.
Thomas A. Edison
 
Both worked fine. Thank you sir.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top