DEV Community

Need help in Populating HTML Table from a file

debbiswas on October 04, 2020

Hi All, Here am trying to retrieve data from text file and embed them to HTML table based on some condition. Below is the code which is written in...

Read full post

Edward Ellsworth • Oct 4 '20

Try putting a console.log in your filter callback function to see what values it's actually fetching and comparing from the file.

debbiswas • Oct 5 '20 • Edited

Thanks Edward for reaching out. I see that it fetches exactly same values as in text file inside filter callback. Also its datatype is string for each values

Edward Ellsworth • Oct 5 '20

So, if the values are exactly the same, the filtered array wouldn't be empty. I'd try adding more to the console.log statement. For example:

console.log(value, value == "p");

If this outputs something like p, false then my guess is the value variable has a phantom space around it. You could test that with something like:

console.log('xx' + value + 'xx');

If there's a phantom space, you should see something like "xxp xx" or "xx pxx"

debbiswas • Oct 6 '20

Thank you Ellsworth for your response . I tried putting above checks and see that condition return false but strangely there is no phantom space even.

Edward Ellsworth • Oct 7 '20

Hmm. I'm curious, if you do console.log(lineByline) what does it display? Or maybe console.table(lineByline)?

debbiswas • Oct 9 '20

thank you for your response. Attaching the response for console.log(line) , lineByline and console.table(lineByline) inn sequence.

Edward Ellsworth • Oct 9 '20 • Edited

I'm not sure what, but something is off about your array. Console.table is only showing the index. Unless this is a browser quirk I'm not aware of, it should be showing corresponding values.

debbiswas • Oct 10 '20

Yes may be browser issue. Let me then try in different browser and check. Thanks

manish srivastava • Oct 4 '20

Is TXT file was a table or database? Or paragraph.... And how many such files you need to convert?

debbiswas • Oct 4 '20

Thanks Manish. Text file will always contain one column data and only one file need to be converted.

manish srivastava • Oct 5 '20

May be this is not best answer but it may solve your problem.

Open your text file with ms Excel with limiting tab . You will see all your text column in first column on excel sheet.

Now, you can work on this textfile and save it either SQL or text file which will be easy to get modified results with your jQuery codes.

Ms Excel is superb program. It helped me in many cases.