How do you remove a carriage return from text in a field

[Ronald Anusiewicz]

I have a field (C,250,0) for users to enter text. The field is in a browse. As the text would be too long to display as a single row in the browse, by default the browse displays 3 rows.
The normal data entry would be to type in text as a single row word wrapping to the next row. My user has entered some text on the first row, pressed the enter key and entered text in the second row.


Light bulb inop.
P/N 12345

Instead of:

Light bulb inop. P/N 12345

This has broken some of my code in a different location. Is it possible to strip out the carriage return. My thought was remspecial(), but that would remove too much.

I tried strtran(Fieldname,"<CR>") but that didn't work.

Thanks

[Stan Mathews]

Re: How do you remove a carraige return from text in a field

A solo carriage return is chr(13), solo line feed chr(10), and there is always crlf() for the combination - depending on what is actually created by "pressed the enter key and entered text in the second row."

[Ronald Anusiewicz]

Re: How do you remove a carraige return from text in a field

Is there some way to see what the invisible text is?

[Al Buchholz]

Re: How do you remove a carraige return from text in a field

Is there some way to see what the invisible text is?

Export the record or just the field to a csv file and get a free hex editor to see the encoding.

[Stan Mathews]

Re: How do you remove a carraige return from text in a field

Or the hard way. Note the record number (#) of a record with the problem characters.

tbl = table.open("yourtablename")
tbl.fetch_goto(#)
tst = tbl.thefieldname
? at(chr(10),tst)
= 3
? at(chr(13),tst)
= 0
? at(crlf(),tst)
= 0
tbl.close()
'this indicates a chr(10) in the field

Note: A crlf() actually consists of a chr(13)+chr(10) pair so if the problem is a crlf() in the field then you will get a number result for all three.

Which means if you go the update operation route and update the field with

field expression
fieldname strtran(fieldname,chr(10),"")
fieldname strtran(fieldname,chr(13),"")

then it doesn't matter what was there originally.

[Ronald Anusiewicz]

Re: How do you remove a carraige return from text in a field

OK, as it turns out, it's a paragraph symbol, which is a CHR(20).
However; for some reason your little script doesn't find it.

Hmmm...

[Al Buchholz]

Re: How do you remove a carraige return from text in a field

OK, as it turns out, it's a paragraph symbol, which is a CHR(20).
However; for some reason your little script doesn't find it.

Hmmm...

Stan's script didn't look for it.

That's why I suggested what I did as one alternative.

The other would have been a loop to go through the character set for each letter in the text by looking for chr(n) for n = 1 to 256(or greater..)

[Ronald Anusiewicz]

Re: How do you remove a carraige return from text in a field

I did get it to work.
mytext = stritran(mytext,CHR(10)," ")

Thanks