1. 从括号中取英文名字
CountryCityMaster IDHotel NameHotel Name ENIndonesiaTentena691823UE大土别墅(Ue datu Cottages)Ue datu Cottages
Hotel Name EN = SUBSTITUTE(TRIM(MID(D2,FIND("(",D2)+1,LEN(D2))),")","")
2. 取出中文名字
Hotel Name Zh = TRIM(MID(B2,1,FIND("(",B2)-1))
3. 统计 冒号 ：出现次数
001:LHO5:16258:S16003:93846:194424
=LEN(A1)-LEN(SUBSTITUTE(A1,":",""))
4. 得到 ItemCode Destination Property 里面的 code有的有空格有的没有空格，Destination Hotel Code 同样的
Destination City CodeDestination PropertyDestination Hotel CodeItemCodeAAHA&O Aachen Hauptbahnhof - AAH AOAAAH AOAAOAAAHIbis Styles Aachen City - AAHMERAAHMERMERAAHLeonardo Hotel Aachen - AAHHOLAAHHOLHOLAAHMercure Hotel Aachen Europapla - AAH MER4AAH MER4MER4 ItemCode =TRIM(MID(D2,LEN(B2)+1,8)) 8 为虚长度，能够覆盖剩余的长度部分
