Page 1 of 1
VL-Web: CRLF is added, when a value is copied from an Excel cell and pasted into a field on the screen.
Posted: Mon Sep 09, 2019 4:20 pm
by 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
Re: VL-Web: CRLF is added, when a value is copied from an Excel cell and pasted into a field on the screen.
Posted: Tue Sep 10, 2019 9:05 am
by 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?
Re: VL-Web: CRLF is added, when a value is copied from an Excel cell and pasted into a field on the screen.
Posted: Tue Sep 10, 2019 11:54 am
by 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
Re: VL-Web: CRLF is added, when a value is copied from an Excel cell and pasted into a field on the screen.
Posted: Tue Sep 10, 2019 12:28 pm
by 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.