Trimming a string - rather than a character

[sjordery]

Hi All,

Probably a simple one for you gurus out there, but it's been a long day here...

Basically, I have the following row:

<OpenTag attritbute"888"><SecondOpenTag>

As part of my processing, I am splitting up the XML and don't want the second open tag...

So, what I want to do is:

Code: Select all

Trim(Input.Field,'<SecondOpenTag>','A')

But of course, this is no good as trim only does a single char. Any easy way to do this...? I wanted to avoid server job/routine and don't know C++.

Many thanks in advance.
S

[DSguru2B]

If server job is acceptable, use EREPLACE() to replace the string.

[crouse]

Is there only one occurence of "<SecondOpenTab>" in the string?

if so, you could do SOMETHING like:
right(string,index(string,"<SecondOpenTab>",1) -1) : left(len(string) - index(string,"<SecondOpenTab>",1) + 15)

In essence, you clip off the right and left side and concat them together.

If you have more than one occurance to remove... you'll need to do this over and over. ick!

[sjordery]

Great - thanks very much for ther pointers. :)

Cheers,
S