input value issues in javascript

Question

I hav a google published csv sheet. I created a html table and want to display csv values from published csv sheet into all input fields inside html table.

due to a unspecified reason this question has been moved.

xmlhttp.responseText.trim(); so you need to split it up..... — epascarello
– epascarello, Commented Jan 6, 2022 at 16:37
@epascarello I don't' know how to do it. Can you please post your code? — planpoint
– planpoint, Commented Jan 6, 2022 at 16:39
You can use split() function. example : let splitedResult = xmlhttp.responseText.split(" "); console.log(splitedResult[0].trim(), splitedResult[1].trim()). You can assign the values to element.value = splitedResult[0].trim(); element1.value = splitedResult[1].trim() ...... — Syam
– Syam, Commented Jan 6, 2022 at 16:49

Syam · Accepted Answer · 2022-01-06 17:49:32Z

1

You can use Split() function https://www.w3schools.com/jsref/jsref_split.asp

let splitedResult = xmlhttp.responseText.split("\r");

You can assign the values to

element.value = splitedResult[0].trim();
element1.value = splitedResult[1].trim();

Check out this link for the implementation https://jsfiddle.net/SyamKumarD/xa49vspy/29/

I would suggest you to provide a iterable id to your table elements, so you don't need to hardcode the index to your split result and you can iterate through the element and assign the split value dynamically.

edited Jan 6, 2022 at 17:49

answered Jan 6, 2022 at 17:33

Syam

3231 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

NightEye Over a year ago

Last couple of values were not separated by space. You might need to split by whitespace or better yet, a new line to be specific instead and then trim. Aside from that, you should be golden.

planpoint Over a year ago

@Syam I really don't know how to fix last 2 cells or how to add white spaces. Because these values are inside of google published csv file. Even still I have no idea. Thank you for your answer. But if you can properly fix the code, I will accept ur answer. Because I'm still unable to fix the code.

NightEye Over a year ago

@planpoint, answer's been updated. use \r instead.

Collectives™ on Stack Overflow

input value issues in javascript

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related