VL-Web: CRLF is added, when a value is copied from an Excel cell and pasted into a field on the screen.

[Rieko Saitoh]

Hi all,

When I copy and paste the value of an EXCEL cell into a field, CRLF(Carrige Return / Line Feed ) is added.CRLF is not necessary.
Is there only a way to remove CRLF with logic? Is there any other way?

LANSA version: V14SP2
EPC level: EPC142040

Thank you.

Best regards,
Rieko Saitoh
LANSA japan

[MarkD]

It's easy to remove them from a field's content.

Are you asking if there is another way so that you do not have to do even that?

[Rieko Saitoh]

Hi Mark,

Could you tell me if there is a way to remove CRLF without using logics?
I learned how logic can remove CRLF. The following logic.

***********
#CR: = (13) .AsUnicodeString
#LF: = (10) .AsUnicodeString
#CRLF: = #CR + #LF
#STD_TEXT: = # STD_TEXT.Remove (#CR) .Remove (#LF) .Remove (#CRLF)
***********

Is there any other way?


Thank you.

Best regards,
Rieko Saitoh
LANSA japan

[MarkD]

Not that I now of. There are articles on the Internet on how to copy MS-Excel cells without including them .... but I guess that would require end user behavioral changes.