I think you can try: strA = chr(13) & chr(10) strB = chr(243) strOrig = your original string
strOrig = replace(strOrig, strA, strB) > I've got a value I'm reading in from a SQL Server field which contains > embedded Carriage Return/Line Feed characters. I'm moving this data to > a UniData database, which is multi-valued. I want to convert those > characters to UniData value marks, CHR(243). Is there an easy function > to replace all instances of a substring within a string with another > substring? ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
