问题已解决
怎样把一排含有客商车牌号里面的车牌号单独筛出来
![](https://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
您好,这些号码是否有其共性
2023 01/05 16:24
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784995 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 01/05 16:27
我要把车牌号单独筛出来
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
微微老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 01/05 16:28
不要客商:只要车牌号码,是这样吗?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784995 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 01/05 16:29
是嗯对的
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
微微老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 01/05 16:33
您好,可以使用替代,全部替换,客商:就不见了,就可以是车牌号码了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784995 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 01/05 16:37
外面那个框框咋弄
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
微微老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 01/05 16:38
同理,也可以通过替代的方法去掉
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784995 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 01/05 16:39
这个不行我试了
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
微微老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 01/05 16:40
可以的呢,你把那个框框复制上去替代掉呢
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784995 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 01/05 16:43
不行啊老师
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784995 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 01/05 16:44
你看看怎么办
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
微微老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 01/05 16:47
您好,那使用LEFT提取数字出来。