Hello everyone, I am somewhat new to XML and just begun using it A LOT at work. I have this problem I want to resolve but I am not sure if I can do this in XML. Basically, I want to take the very first character of a tag from incoming XML <App_Data App="MOD" Name="Episode_Number" Value="303"/> and assign it to another tag that is empty. I am trying to get the first character of Episode_Number which is 3 and represents the season number. I then want to put that into the season number tag but I am not sure how to go about that. My transform rule would look something like:

You seem to be calling everything a "tag", but some are attributes or attribute values. A tag usually refers to an element.You have to learn a bit of the XML technology and its terminology before starting to use it. Without the terminology it is difficult to understand the means you plan to use and the desired result. I did get part of what is the desired result, but that is just a piece of the result that you are describing. Provide a broader input and output (desired result), not just a single entry.

This code assumes you have multiple "App_Data" elements and each useful one has the attribute Name = 'Episode_Number'. Assuming the output is still XML, you need a single root element. So, this code adds an "outroot" root element/tag for the output that surrounds all the "input" elements.This outputs something like this: