How to delete characters after certain number

Cristina Moise

Hi All,
I would appreciate your help regarding my issue. I am struggling with a big xml File where I have below line, the commodity code should have only 8 characters but due to a system wrong setting it’s coming out with 10 numbers/characters so I manually have to replace each code by deleting the last two numbers and it takes me almost two days to do that.
Can someone help me with this topic.
<ProductCommodityCode>8414302090</ProductCommodityCode>

Thank you

Alan Kilborn

@Cristina-Moise :

Find: (?-i)<ProductCommodityCode>(\d{8})\d\d</ProductCommodityCode>
Replace: <ProductCommodityCode>${1}</ProductCommodityCode>
Search mode: Regular expression

Will change, e.g.

<ProductCommodityCode>8414302090</ProductCommodityCode>

into

<ProductCommodityCode>84143020</ProductCommodityCode>

Cristina Moise

@Alan-Kilborn Can’t say in words how much I love you right now.You made my day !! So happy!Again thank you for your prompt answer.