excel公式来剥离html [英] excel formula to strip html
问题描述
我想从文本值的左侧和右边剥离所有的HTML:
I want to strip all the html away from the left and right of the textual value:
我有这个...
< option value =41> GECommonUI< / option>
GECommonUI
推荐答案
简单的字符串函数集。因为我不能超越excel字符串的功能,这对我来说是一个痛苦,想出来...
guys this is a simple set of string functions. as i am not up to speed on excel string functions this is a pain for me to figure out...
在编程语言中,这将像
中(开始,长度)从完整的html字符串获取值 - 诀窍是获取长度作为开始占有减去结束html lenght的第十个)
in a programing language this would go somethign like mid(start, length) to get the value from the full html string- the trick is to get the length as the start possition minus the lenth of th ending html lenght)
mid(pos(>)+ 2,len(string)-pos(>))
mid( pos(">")+2, len(string)-pos(">") )
这篇关于excel公式来剥离html的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!