English 中文(简体)
从xml中提取价值的Excel公式[封闭]
原标题:Excel formula to extract values from xml [closed]

请建议从下文中提取数值的代谢公式:

<string name="confirm_message">I confirm the above information that I have entered is<br /><font fgcolor= @color/app_primary_color ><b>true and accurate.</b></font></string>

1. confirm_message
2. I confirm the above information that I have entered is<br /><font fgcolor= @color/app_primary_color ><b>true and accurate.</b></font>

Explanation :

I wanted to create an excel sheet where the 
- column 1 will be the actual value i.e. <string .. </string> (which are in 1000+) and the 
- column 2 will be the the value in the "name" attribute and the 
- column 3 will be the value within the  <string> .. </string>

我需要采用外部表格中的公式来获取第2栏和第3栏的数据。 它是吗? I Trial =SUBSTITUTE(SUBSTITUTE(A1,“</string>”),“<string”,”, 查询因特网。 但是,这并不完全是前任专家如此预期的建议。 我是新办法。

希望这解释了问题。

www.un.org/Depts/DGACM/index_spanish.htm 最新资料: 非常真实的是,大赦国际将接手我们的方案制定者。 我现在知道,分析简单刑期的人为智囊团是多么有限。 我刚刚在聊天会中提出同样的问题,你知道,我得到的答案是准确的。

谁需要答案如下:

http://www.ohchr.org。

=MID(A1,SEARCH("name=""",A1)+LEN("name="""),SEARCH("""",A1,SEARCH("name=""",A1)+LEN("name="""))-SEARCH("name=""",A1)-LEN("name="""))

http://www.ohchr.org。

=MID(A1,SEARCH(">",A1)+1,SEARCH("</string>",A1)-SEARCH(">",A1)-1)

<>ChatGPT 屏幕 :

“entergraph

问题回答

暂无回答




相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签