Trimming characters within an XML file

Question

Good morning

I have an xml being produced by a legacy system that has a quirk - it has an ID code 35 characters long but i want to trim to 15 characters - this occurs multiple times in the file and i need to change each instance

So this will appear or a variant of multiple times - in order for consumption to another solution, it cannot exceed 15 characters , highlighted in red

<EndToEndId >123451F4-C123-456C-B123-09E8C8F7ADD<

This is a snip from the file , there is obviously data above an below - I can change the format to txt if that helps.

Appreciate some advice

apathetichell · Answer

if this only occurs once per line something like regex_replace(field,"^(.*)(.[15])(.*)(.*)$","$1$2$4") should get you there.basically - get me everything including the xml field marker. get me the next 15 characters. get me everything after xml field..

DataNath · Answer

Hey @Birdman1971, could you try the following in a Formula tool? Replacing [Input] with your actual field name. Replace([Input], SubString([Input], FindString([Input], '')+13, 35), SubString([Input], FindString([Input], '')+13, 15))