asked on

Format textarea text

Hi folks,
The task I am trying to accomplish is,

I have a textarea on my page and I paste some text from an excel sheet onto this textarea. The format comes up as:

abcd
jhjshds
eyyeye
yueye
ndgdjj
ieieue
iweiene

What I am trying to achieve is, onmouseout function, this input should turn into Comma Seperated Values, like:

abcd, jhjshds, eyyeye, yueye, ndgdjj, ieieue, iweiene

How to go about this?

SOLUTION

code-colors

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

frzsombor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aman0711

ASKER

Hi frzsombor:

Your solution isnt working right :(
I have attached the snapshot. Multiple commas indicate the number of times I did mouseout.

comma.PNG

aman0711

ASKER

Hi Code-colors,

Same sort of result with your script as well :(

comma2.PNG

SOLUTION

gamarrojgq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aman0711

ASKER

Hi gamarrojgq:

Your solution didnt work either. Its not doing anything on mouseout.

gamarrojgq

Hi aman0711,

The function use "txtTextArea" as the ID of you textarea control, does your control have this ID?

aman0711

ASKER

Hi gamarrojgg,

Yes I do have that. Below is my complete code.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
   <script>

		 function FormatTextArea(){
        
            var sdata;
            var newdata = "";           
            sdata = document.getElementById("txtTextArea").value;
            for(i=0; i<sdata.length; i++){
                if (sdata[i].charCodeAt(0) == "\n".charCodeAt(0))
                {
                    newdata = newdata + ",";
                }           
                else
                {
                    if(sdata[i].charCodeAt(0) != 13){
                        newdata = newdata + sdata[i];
                    }
                }
            }
            document.getElementById("txtTextArea").value = newdata;
        }

  </script>


 </HEAD>

 <BODY>
   
    <textarea rows="10" cols="40" id="txtTextArea" onmouseout="javascript:FormatTextArea();" >

	</textarea>


 </BODY>
</HTML>

Open in new window

errr.PNG

ASKER CERTIFIED SOLUTION