Finding and deleting text within symbols within a single field...

[cyberspread]

Hi,

We have a issue we are trying to resolve.

We have imported information from WebHelpDesk. One of the fields is formatted as such:

<note date="04/18/2011 7:37 pm" author="dsimons" type="tech" time="15" rate="No Rate">I had them unplug the keyboard and flip it upside down. They were done shooting for the end of the day so I told them to go to radio shack and buy a chap USB key board. And to call up the chain to the regional manager.

We would like to run a calculation or a script to get rid of most of what is in that field.

Example: We would like to find and delete the symbol <> and all of the text in-between. Only in that field.

Original (Bold being what we want to strip out): <note date="04/18/2011 7:37 pm" author="dsimons" type="tech" time="15" rate="No Rate">I had them unplug the keyboard and flip it upside down. They were done shooting for the end of the day so I told them to go to radio shack and buy a chap USB key board. And to call up the chain to the regional manager.

Modified (This is what we want to keep): I had them unplug the keyboard and flip it upside down. They were done shooting for the end of the day so I told them to go to radio shack and buy a chap USB key board. And to call up the chain to the regional manager.

Is this possible with a calculation or a script of some kind. Right now, we manually remove the information. With thousands of files, that is no longer an option.

Thanks in advance,
Ken

[chopper]

Of course before you do anything back up your file

If a calculation

Middle (YourTablaName::YourFieldName ; Position (countvalues::NoteField ; ">" ;1; 1 )+1 ;500 )

//Note 500 is amount of characters to show , maybe less , but if more that number will need to increase

In a Script

Set Field [YourTablaName::YourFieldName] ; Position (countvalues::NoteField ; ">" ;1; 1 )+1 ;500 )

[cyberspread]

So, this is basically saying: In this field, "Notes", find "<" and ">" and delete everything in-between?

[chopper]

Kind of... you see the position in the calc. It is looking to see what number space it occupies.
the Right statement is saying start in position where the > is plus 1 space and give me what is in
the next 500 characters.

[cyberspread]

Do you have an example of the result? Of what we will possibly be looking at after running the script or calc?


Thanks for all the help by the way. Very appreciated.

[chopper]

I had them unplug the keyboard and flip it upside down. They were done shooting for the end of the day so I told them to go to radio shack and buy a chap USB key board. And to call up the chain to the regional manager.

[cyberspread]

LOL. Ok. Thanks...

[chopper]

This will illuminate the guess of how many characters remain after the >

Middle (Yourtable::YourField ; Position (Yourtable::YourField ; ">" ;1; 1 )+1 ; Length(Yourtable::YourField) - Position (Yourtable::YourField ; ">" ;1; 1 )+1 )