在excel中删除分隔符之后的字符串 [英] Delete the string after the delimiter in excel

问题描述

我有简单的问题。我正在分析一些数据，并提出了这个问题。

以下是我在colomn中的价值：

  www.mysite.come / api / Customer？id = 12333& name = jack 
 www.mysite.come / api / Department？id = 52365& name = COP 
 www.mysite.come / api / Customer？id = 13333& name = mathew 
  

etc

我想过滤这些数据，如下所示

  www.mysite。来/ api /客户
 www.mysite.come / api /部门
 www.mysite.come / api /客户
  

请帮助我。

解决方案

，其中包括？然后这样做：

= LEFT（A：A，FIND（？ A1）-1）

编辑：如果要抓住 #VALUE没有的错误？只需使用 IFERROR ：

= IFERROR（LEFT（A：A，FIND（？， A1）-1），A1）

示例行：

  www.mysite.come / api / Customer？id = 12333& name = jack 
 www.mysite.come / api / Department？id = 52365& name = COP 
 www输入：
  www.mysite.come / api / Customer 
 www.mysite.come / api / Department 
 www.mysite .come / api / Customer 
  
 
I have simple problem. I was analyzing some data and came up with this problem.

Below is my value in a colomn:
www.mysite.come/api/Customer?id=12333&name=jack
www.mysite.come/api/Department?id=52365&name=COP
www.mysite.come/api/Customer?id=13333&name=mathew
etc

I want to filter this data something like this
www.mysite.come/api/Customer
 www.mysite.come/api/Department
www.mysite.come/api/Customer
Please help me with this.
解决方案
If its just as simple as removing everything after, including, the ? then this will do it:

=LEFT(A:A,FIND("?", A1)-1)  

Edit: If you want to catch the #VALUE! error when there is no ? simply use IFERROR:

=IFERROR(LEFT(A:A,FIND("?", A1)-1), A1)

Example rows:  
www.mysite.come/api/Customer?id=12333&name=jack
www.mysite.come/api/Department?id=52365&name=COP
www.mysite.come/api/Customer?id=13333&name=mathew
Output:  
www.mysite.come/api/Customer
www.mysite.come/api/Department
www.mysite.come/api/Customer


                        
这篇关于在excel中删除分隔符之后的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！