Carriage Returns, Line Feeds, and Tabs in Text Area

[Former Member]

I am having users copy and paste data from an Excel spreadsheet into a textarea on a BSP page. When they submit this, since there are tabs and line feeds in the data, the BSP does not recognize the data. The value in the field comes through as blank. When I manually type something into this field, with out any carriage returns, tabs, etc., the value does not come through as blank? Does anybody know how to get around this?

[eddy_declercq]

Hi,

How did you define your variable? As STRING? That should work (it does for us).

Btw there is a dedicated forum for BSP questions.

Eddy

[eddy_declercq]

Hi,

Pls don't forget to reward points if you find the answers usefull.

Eddy

[former_member623843]

HI

Iam uploading the data from application server(AL11) to other server.

In the GLPCA-SGTXT(Table) iam having some text like 'This is good ##'.i was downloded some other data with this text('This is good ##') by using report program in to aplicationserver(AL11) and from there iam uploading that data into other server.

But here the problem is in the UNIX, it was showing some problem.

That is actually it need to show the format like:

001 256 786 This is good## 459786

But here it was showing like:

001 256 786 This is good^M

459786

So here '459786' is coming to next line. But i need this '459786' also in the same line.

I am not sure if it is possible to remove CR and LF's using the code the program is written in, but that is what we need to do. In Unix ^M is the CR (Carriage return), but I am not sure what LF is?