Probably a simple one for you gurus out there, but it's been a long day here...
Basically, I have the following row:
As part of my processing, I am splitting up the XML and don't want the second open tag...<OpenTag attritbute"888"><SecondOpenTag>
So, what I want to do is:
Code: Select all
Trim(Input.Field,'<SecondOpenTag>','A')
Many thanks in advance.
S