Check if there ENTER on a string

[flebrao]

Good morning masters ...
I have a question ...: Roll: I'm trying to locate an enter in a text field, but I tried in many ways and it did not work, someone would tell me how I can be doing this, please?


Thanks,
Fábio leak

[dr_gori]

You can search for CHR (10) or CHR (13)
Try there !!! :-O

[ruevers]

Uses the dump () function that shows all the text chr.

[gokden]

I have this Comandim here chi takes the line breaks and travernform in space ...

Select all

vv_string := translate(vv_string,chr(10)|||chr(13),' ');

I do not know if this is what you need, more for me This helped a lot = D

[flebrao]

Guys thank you very much for the tips. Mr. Tomas I was doing the Select searching for the CHR (10) but in the wrong way ... But with this doubt there were these other tips that are already being used here in the sector ... this forum is a spectacle ... brigaduuuuuuuuuuu hugs

[oteles]

Dear Lucas,

I ended up putting a new topic unduly "generate text-free text file (UTL_File)", and I know that maybe this topic could help. Anyway I tried to use your solution without success. Could you check where I'm wrong?

Thanks

Abçs

Omar Teles

[aarao.primo]

Select all

SELECT COLUNA FROM TABELA WHERE COLUNA LIKE '%'||CHR(13)

: -O