How to split by numbers to get rid of all numbers

studio

#1

I have a string like this:

Batch NoVendor NameInvoice NoInvoice DateCurr.AmountPO
201803150009天津百得利汽车服务有限公司0112929120180313CNY4500.00

I would like to split the string and only remain those Chinese characters. Currently I can split by “AmountPO” and get the second line only. My thought is that I can split by numbers and get the text between two number series. Any help will be appreciated.

I search the forum for similar topic but no results found. If there is a solution already, my apology made.


#2

I think you can simply use string substring method, you can remove the first numbers as its date and it will always be 12 in length.
So substring should always start from 12, then you can give length of chinese character, is there any logic by which you can calculate chinese character length?


#3

Hope this helps


#4

Thanks for your help. the first substring of number is not always fixed in 12 length. And yes I can calculate Chinese characters but it is also not fixed length.


#6

I am still new to UiPath and terrible at it thus I never touched the activity “match” before, I do not know the logic behind your flow but I tried your approach. The message box shows everything but the Chinese characters I need. Can you please specify how to get those Chinese characters?

This is the text I get from “get email text activity”:

Batch NoVendor NameInvoice NoInvoice DateCurr.AmountPO
201803150009天津百得利汽车服务有限公司0112929120180313CNY4500.00

Thanks and best regards,


#7

TO get only chines characters use this :slight_smile:

[\u4e00-\u9fff]+

Hope this helps
Regards,


#8

Thanks a lot it worked fine!


#9

Good to know and I am happy to help :slight_smile: