August 17, 2018 at 11:37 am
Hi Everyone,
I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string. Meaning, I need the RTF tags stripped, only bringing back the text. I've been looking and can't seem to find any resources on it.
Is there something I can put in my query that will do it on the fly?
Thanks!
August 17, 2018 at 11:50 am
meichmann - Friday, August 17, 2018 11:37 AMHi Everyone,
I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string. Meaning, I need the RTF tags stripped, only bringing back the text. I've been looking and can't seem to find any resources on it.Is there something I can put in my query that will do it on the fly?
Thanks!
Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 17, 2018 at 11:56 am
Phil Parkin - Friday, August 17, 2018 11:50 AMmeichmann - Friday, August 17, 2018 11:37 AMHi Everyone,
I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string. Meaning, I need the RTF tags stripped, only bringing back the text. I've been looking and can't seem to find any resources on it.Is there something I can put in my query that will do it on the fly?
Thanks!
Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.
Hi Phil,
Yeah, I'm trying to do it dynamically in the SQL query. That's my only option at the moment, unless I can find a way to do it in SSIS.
August 17, 2018 at 12:07 pm
meichmann - Friday, August 17, 2018 11:56 AMPhil Parkin - Friday, August 17, 2018 11:50 AMmeichmann - Friday, August 17, 2018 11:37 AMHi Everyone,
I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string. Meaning, I need the RTF tags stripped, only bringing back the text. I've been looking and can't seem to find any resources on it.Is there something I can put in my query that will do it on the fly?
Thanks!
Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.
Hi Phil,
Yeah, I'm trying to do it dynamically in the SQL query. That's my only option at the moment, unless I can find a way to do it in SSIS.
But if you had a CLR, you'd be able to call that from within your T-SQL. If this is going to be an ongoing requirement, I'd say that a CLR is your best option.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 17, 2018 at 12:11 pm
Phil Parkin - Friday, August 17, 2018 12:06 PMmeichmann - Friday, August 17, 2018 11:56 AMPhil Parkin - Friday, August 17, 2018 11:50 AMmeichmann - Friday, August 17, 2018 11:37 AMHi Everyone,
I was wondering if anyone knew of a way to convert an RTF field to a regular varchar string. Meaning, I need the RTF tags stripped, only bringing back the text. I've been looking and can't seem to find any resources on it.Is there something I can put in my query that will do it on the fly?
Thanks!
Looks fairly challenging in T-SQL, but not so bad in C# – so a CLR, SSIS package or C# app will do it for you.
Hi Phil,
Yeah, I'm trying to do it dynamically in the SQL query. That's my only option at the moment, unless I can find a way to do it in SSIS.But if you had a CLR, you'd be able to call that from within your T-SQL. If this is going to be an ongoing requirement, I'd say that a CLR is your best option.
Phil,
ok I'll look into that. thanks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply