replace multiple carriage returns

[atarrqis]

I'm using cr8.5 with Oracle
I need to do a replace on a text string so that where ever there is two carriage returns in a row I will only have one. I know how to replace one carriage return:
replace({table.text},chr(13)," ")

I can't figure out the correct syntax for the replace when I'm trying to find two chr(13) in a row.
replace({table.text},"chr(13)chr(13)"," ")

 

[synapsevampire]

Try:

replace({table.text},chr(13)+chr(13),chr(13))

Can't recall the exact syntax, that looks ok.

-k

 

[atarrqis]

good idea but no, that still doesn't do it.

 

[synapsevampire]

Try posting specifics, does it error, or?

If it doesn't error, then your theory is incorrect, there aren't 2 consecutive Carriage Returns.

Often times there is a carriage return+line feed, which is a chr(10)

But you need to post more than, no, that doesn't do it.

You should try disaovering what is in the field by copying and pasting it into a formula of:

asc("<paste here>")

-k

 

[Madawc]

If it isn't line-feed, then consider spaces between the feed characters.

Try a test report to see what really is there. Change the feeds into something visible, e.g.

replace({table.text},"chr(13)chr(13)","CHR_13")

Find out what the data really is.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[atarrqis]

The string contains chr(13)chr(10) so that I get
9318 Nalini#$#$Urbana, IL#$61801#$
if I use
replace(replace({table.text},chr(13), "#"),chr(10),"$")

I only want to remove where there is a double (#$#$)
not a single set (#$) but I can't get the syntax for 'instr' to work correctly.

 

[synapsevampire]

Try:

replace({table.field},chr(13)+chr(10)+chr(13)+chr(10),chr(13)+chr(10))

-k

 

[lbass]

Try this:

replace({table.text},chr(13)+chr(10)+chr(13)+chr(10),chr(13)+chr(10))

-LB

 

[atarrqis]

Thanks, that did it.

 

[synapsevampire]

That'll never work, LB

-k