RE: FLASH: replaces characters in a substring

[Scott Jeppesen]

Yes it's possible. I would probably create a loop that goes the length of

the field and looks at each character and if it is a space it would set the

field to everything before the space & _ & everything after the

space...something like this.


Assuming that your text field is called "input":


Set Variable: "index" = 1

Loop While (index <= Length(input))

If (Substring(input, index, 1) eq " ")

Set Variable: "input" = Substring(input, 1, index-1) & "_" &

Substring(input, index+1, Length(input)-index)

End If

Set Variable: "index" = index + 1

End Loop


SJ


-----Original Message-----

From:

ownerchinwag [dot] com

 [

ownerchinwag [dot] com]On">mailto:ownerchinwag [dot] com]On

 Behalf Of Olga

Sent: Friday, April 28, 2000 2:50 PM

To:

flasherchinwag [dot] com

Subject: FLASH: replaces characters in a substring



Is there any way to replace characters in a substring-- I have a text field

with a handful of words in it, and I want to be able to take the value of

that text field and replace all the spaces in it with underscores.  Is that

possible?


thanks!

olga



flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 Get the last 100 messages from the flasher list NOW

    http://www.chinwag.com/flasher/last100.shtml


 Flash books http://www.chinwag.com/flasher/books.shtml

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com

flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 Get the last 100 messages from the flasher list NOW

    http://www.chinwag.com/flasher/last100.shtml


 Flash books http://www.chinwag.com/flasher/books.shtml

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com