vbscript - CSV Parsing Not Recognizing Line Break (ASP) -


i'm using vbscript parse csv data , display on table. i've got csv set , when open in sublime text, headers , content on different lines (there's 1 row of content besides header). shows 2 lines in sublime text.

the headers don't have comma @ end of row doesn't break , appends first entry of second line on last entry of headers line because it's not technically divided comma.

the code i'm using is:

<html> <head> </head> <body> <%@language="vbscript"%> <table border="1"> <% dim csv_to_read, fso, act csv_to_read="sample.csv" set fso = createobject("scripting.filesystemobject") set act = fso.opentextfile(server.mappath(csv_to_read)) 'read first line of csv, typically these colum headings response.write "<tr><th>" & replace(act.readline,",","</th><th>") & "</th></tr>" & vbcrlf 'read rest of csv response.write "<tr><td>" & replace(replace(act.readall,vbcrlf,"</td></tr>"&vbcrlf&"<tr><td>"),",","</td><td>") & "</td></tr>" %> <caption>total number of records: <%=act.line-1%></caption> </table> </body> </html>

why not recognizing line break?

thanks help!

i think problem caused file not having eol marker of vbcrlf (but crlf probably). evidence:

s = "1,2,3" & vblf & "4,5,6" h = "<tr><td>" & replace(replace(s,vbcrlf,"</td></tr>" & vbcrlf & "<tr><td>"),",","</td><td>") & "</td></tr>" wscript.echo "vblf" wscript.echo h s = "1,2,3" & vbcrlf & "4,5,6" h = "<tr><td>" & replace(replace(s,vbcrlf,"</td></tr>" & vbcrlf & "<tr><td>"),",","</td><td>") & "</td></tr>" wscript.echo "vbcrlf" wscript.echo h

output:

cscript 23072652.vbs vblf <tr><td>1</td><td>2</td><td>3 4</td><td>5</td><td>6</td></tr> vbcrlf <tr><td>1</td><td>2</td><td>3</td></tr> <tr><td>4</td><td>5</td><td>6</td></tr>

(i hope output prove looping advocates double replace produces valid html)

update wrt comment:

this version of script:

s = "1,2,3" & vbcrlf & "4,5,6" wscript.echo ".readall() (faked):" wscript.echo s  ' h = "<tr><td>" & replace(replace(s,vbcrlf,"</td></tr>" & vbcrlf & "<tr><td>"),",","</td><td>") & "</td></tr>" ' step step  h = replace(s,vbcrlf,"</td></tr>" & vbcrlf & "<tr><td>") wscript.echo "step 1 - eol handling:" wscript.echo h h = replace(h,",","</td><td>") wscript.echo "step 2 - comma handling:" wscript.echo h h = "<tr><td>" & h & "</td></tr>" wscript.echo "step 3 - head & tail i:" wscript.echo h h = "<!doctype html><html><head><title>replace demo</title></head><body><table>" & vbcrlf & h & vbcrlf & "</table></body></html>" wscript.echo "step 4 - head & tail ii:" wscript.echo h

output:

cscript 23072652.vbs .readall() (faked): 1,2,3 4,5,6 step 1 - eol handling: 1,2,3</td></tr> <tr><td>4,5,6 step 2 - comma handling: 1</td><td>2</td><td>3</td></tr> <tr><td>4</td><td>5</td><td>6 step 3 - head & tail i: <tr><td>1</td><td>2</td><td>3</td></tr> <tr><td>4</td><td>5</td><td>6</td></tr> step 4 - head & tail ii: <!doctype html><html><head><title>replace demo</title></head><body><table> <tr><td>1</td><td>2</td><td>3</td></tr> <tr><td>4</td><td>5</td><td>6</td></tr> </table></body></html>

should make visible how double replace works , parts important.


Comments

Post a Comment

Popular posts from this blog

javascript - jquery or ashx not working -

i using ajax file upload control. it creating html: <form action="/pages/handlers/asyncfileuploadhandler.ashx" method="post" enctype="multipart/form-data" target="ajaxuploader-iframe-1397144545"> <input type="hidden" name="type" value="mindvoice"> <input type="file" id="imagefile" style="display: block; width: 80%; margin-right: auto; margin-left: auto;"> </form> and target is: <iframe width="0" height="0" style="display:none;" name="ajaxuploader-iframe-1397144545" id="ajaxuploader-iframe-1397144545"></iframe> the form submitted using .submit() . my ashx handler: <%@ webhandler language="c#" class="asyncfileuploadhandler" %> using system; using system.web; using nettpals.core; public class asyncfileuploadhandler : ihttphandler { public void processre...
Read more

opencv - DataType<cv::detail::deriv_type>::depth what is it used for -

i wondering why line used in lucas kanade tracker in opencv: datatype<cv::detail::deriv_type>::depth can explain me? in opencv, depth of mat refers type of data contained in mat 's data buffer. represented integer values correspond given data type. these integers commonly abstracted appropriate macro definition (e.g. uchar data represented macro cv_8u ). cv::datatype type-traits class provides method obtain corresponding integer value without having memorize macro means data type. there few cases user code needs use datatype::depth . more common datatype::type . a simple example shows 1 possible use of datatype::depth : cv::mat uchar_data = cv::mat::ones(3, 3, cv_8uc1); cv::mat float_data; uchar_data.convertto(float_data, cv::datatype<float>::depth); // ^^ equivalently replaced // cv_32f macro float_data.at<float>(0,1) += 0.5f; std::cout << float_data << std::endl;...
Read more

python 3.x - Mapping specific letters onto a list of words -

can please suggest approach write piece of codes automatically maps letter in letter_str onto dic_key (a dict key string type contains dashes match length of words in word_lst)? so, mapping occurs if letter appears in every words in list @ same position no matter how many words in list. if no letter appears @ position words in word list new_dic_key '----'. please see examples below thanks word_lst = ['ague', 'bute', 'byre', 'came', 'case', 'doze'] dic_key = '----' letters_str ='abcdefghijklmnopqrstuvwxyz' new_dic_key = '---e' if word_list = ['bute', 'byre'] new_dic_key = 'b--e' or word_list = ['drek', 'drew', 'dyes'] new_dic_key = 'd-e-' if words in word_list of same length code give want: word_list = ['drek', 'drew', 'dyes'] cols = [] in range(len(word_list[0])): cols.append([]) word in ...
Read more