PDA

View Full Version : How to solve the strings and sentence



q1q2q3
03-20-2007, 02:29 AM
If one cell contains a huge amount of strings, how can I solve it ?
I want to search the keyword in a cell for some criteria. What can I do ?
It is because cell containing the source of data is the html's source code
, it is very confusing. And then What capacity limitation can contain one cell

Simon Lloyd
03-20-2007, 02:56 AM
Why not attach a sample worksheet with the cells containing the strings?, if the string is not all one word then you can use the find method. A single cell may contain a maximum of 255 characters (i think!).

Regards,
Simon

q1q2q3
03-20-2007, 05:06 AM
The following is the content in a cell. It is because I run some criteria from importing the source code of html file into excel.

My criteria is to be extracted all full path of hyperlinks like
"http://asia.scmp.com/asianews/ZZZ????????.html (http://asia.scmp.com/asianews/ZZZ????????.html) "

Importing text file into excel, only one cell contains the huge amount of strings (highlighted font), the search command cannot perform so accurate. Whatever I want to
correct my statement.





<TD VALIGN=TOP ALIGN=CENTER> <applet CODEBASE="/java/ticker" CODE="both.class" WIDTH="760" HEIGHT="20" ID="readfile"> <param NAME="TickerText" VALUE=" HONG KONG: &nbsp; <a href=http://hongkong.scmp.com/hknews/ZZZ21G1TZYE.html?track=ticker>Li Ka-shing hits No.9 on global billionaires' list<BR></a> &nbsp; ASIA: &nbsp; <a href=http://asia.scmp.com/asianews/ZZZZUF1TZYE.html?track=ticker>Malaysian analyst's trial over murder of Mongolian woman advanced to June<BR></a> &nbsp; <a href=http://asia.scmp.com/asianews/ZZZ82F1TZYE.html?track=ticker>Jury finds man guilty of first murder in 151 years on Australia's Norfolk Island<BR></a> &nbsp; <a href=http://asia.scmp.com/asianews/ZZZR4F1TZYE.html?track=ticker>13-year-olds wed in northeastern Malaysia<br></a> &nbsp; WORLD: &nbsp; <a href=http://world.scmp.com/worldnews/ZZZ2O7CZZYE.html?track=ticker>Bush creeps up from all-time low mark in poll<br></a> &nbsp; <a href=http://world.scmp.com/worldnews/ZZZ0E7CZZYE.html?track=ticker>Bush in Brazil starts Latin America tour amid demonstrations<br></a> &nbsp; <a href=http://world.scmp.com/worldnews/ZZZWJ7CZZYE.html?track=ticker>Olmert and Abbas to meet<br></a> &nbsp; "> <param NAME="Left" VALUE="57"> <param NAME="Right" VALUE="759"> <param NAME="Backgif" VALUE="/images/iEdition/Misc/subscribeticker_760.gif"> <param NAME="Speed" VALUE="60"> <param NAME="Font_Name" VALUE="Verdana"> <param NAME="Font_Size" VALUE="11"> <param NAME="Font_Style" VALUE="Bold"> <param NAME="Colorlink" VALUE="ff8c00"> <param NAME="Colortext" VALUE="4b0082"> <param NAME="Top" VALUE="3"> <param NAME="ErrorText" VALUE="Sorry! Server error! Give us A HREF=http://Complaints.html feedback/A"> </applet>
</TD>

Bartek
03-20-2007, 05:11 AM
A single cell may contain a maximum of 255 characters (i think!).

Not exactly. The cell can contain up to 32767 characters. However, when one copies a worksheet, text strings are truncated to 255 characters. If one copies cells with Copy/Paste all characters are retained.

Simon Lloyd
03-20-2007, 06:42 AM
Thanks Bartek, i knew there was a "255" in there somewhere :), if you divide 32767 by 255 multiply by 2 you get 256 so i was nearly right twice! LOL

Regards,
Simon