This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Dear all,
Does anyone know how to populate text (only) for longdescription? Afaik,
longdec has RTF type so if i copy to text it will populate html tag such
as: <!-- RICH TEXT -->, <div>, <br></div><div></div><div>sdf</div> and so
on.
Thanks for any help.
Best Regards,
Yudi Irianto
This KB doc explains how to disable RTF editing in the long description field.
http://www-01.ibm.com/support/docview.wss?uid=swg21579206
--- In MAXIMO@yahoogroups.com, yudi.irianto@... wrote:
>
> Dear all,
>
> Does anyone know how to populate text (only) for longdescription? Afaik,
> longdec has RTF type so if i copy to text it will populate html tag such
> as: <!-- RICH TEXT -->, <div>, <br></div><div></div><div>sdf</div> and so
> on.
>
> Thanks for any help.
>
> Best Regards,
>
> Yudi Irianto
>
>
>
The other half of my answer was to state that RTF text is out of the box functionality and I don't believe it can be turned off either. Best option is to do a double cut/paste for text entries - text source to notepad to Maximo. That will strip out the HTML characters.
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> This KB doc explains how to disable RTF editing in the long description field.
>
> http://www-01.ibm.com/support/docview.wss?uid=swg21579206
>
>
> --- In MAXIMO@yahoogroups.com, yudi.irianto@ wrote:
> >
> > Dear all,
> >
> > Does anyone know how to populate text (only) for longdescription? Afaik,
> > longdec has RTF type so if i copy to text it will populate html tag such
> > as: <!-- RICH TEXT -->, <div>, <br></div><div></div><div>sdf</div> and so
> > on.
> >
> > Thanks for any help.
> >
> > Best Regards,
> >
> > Yudi Irianto
> >
> >
> >
>
I have had a great battle with Long Descriptions in 7.5 as well.. I think
it is great for PDF documents, but when it comes to exporting data to
excel .... well you know the rest!
The only work around that I have found that work fairly decent is too
create a function on the db calling it StripHTML, you can apply this when
pulling data straight from the db..
USE [????????]
GO
/****** Object: UserDefinedFunction [dbo].[StripHTML] Script Date:
04/02/2012 09:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <//////////////////////>
-- Create date: <2/6/2012>
-- Description: <Remove HTML Tags from Longdescriptions>
-- =============================================
ALTER FUNCTION [dbo].[StripHTML] (@HTMLText VARCHAR(MAX))
RETURNS VARCHAR(MAX) AS BEGIN
DECLARE @Start INT
DECLARE @End INT
DECLARE @Length INT
SET @Start = CHARINDEX('<',@HTMLText)
SET @End = CHARINDEX('>',@HTMLText,CHARINDEX('<',@HTMLText))
SET @Length = (@End - @Start) + 1
WHILE @Start > 0 AND @End > 0 AND @Length > 0
BEGIN
SET @HTMLText = STUFF(@HTMLText,@Start,@Length,'')
SET @Start = CHARINDEX('<',@HTMLText)
SET @End = CHARINDEX('>',@HTMLText,CHARINDEX('<',@HTMLText))
SET @Length = (@End - @Start) + 1
END
RETURN LTRIM(RTRIM(@HTMLText))
END
Some of our clients used long descriptions in other versions in detail, so
with 7.5 I created a field on the workorder screen and called it WOACTION..
This allowed us to move away from the rich text and also it's a lot faster
for employees to enter data...
Shannon Sutton
From: "Jason Verly" <jason.verly@yahoo.com>
To: MAXIMO@yahoogroups.com
Date: 04/01/2012 05:45 PM
Subject: [MAXIMO List] Re: Removing html tag
Sent by: MAXIMO@yahoogroups.com
The other half of my answer was to state that RTF text is out of the box
functionality and I don't believe it can be turned off either. Best option
is to do a double cut/paste for text entries - text source to notepad to
Maximo. That will strip out the HTML characters.
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> This KB doc explains how to disable RTF editing in the long description
field.
>
> http://www-01.ibm.com/support/docview.wss?uid=swg21579206
>
>
> --- In MAXIMO@yahoogroups.com, yudi.irianto@ wrote:
> >
> > Dear all,
> >
> > Does anyone know how to populate text (only) for longdescription?
Afaik,
> > longdec has RTF type so if i copy to text it will populate html tag
such
> > as: <!-- RICH TEXT -->, <div>, <br></div><div></div><div>sdf</div> and
so
> > on.
> >
> > Thanks for any help.
> >
> > Best Regards,
> >
> > Yudi Irianto
> >
> >
> >
>
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended recipient.
Since we can't remove the rich text format, does anybody know what the formula would be in Crystal to remove the tags from a crystal report with long description.
Thanks
Brian Swanson
Systems Analyst-Maximo
Information Technology
hermanmiller.com
HermanMiller
From: "Jason Verly" <jason.verly@yahoo.com>
To: MAXIMO@yahoogroups.com,
Date: 04/01/2012 05:45 PM
Subject: [MAXIMO List] Re: Removing html tag
Sent by: MAXIMO@yahoogroups.com
The other half of my answer was to state that RTF text is out of the box functionality and I don't believe it can be turned off either. Best option is to do a double cut/paste for text entries - text
source to notepad to Maximo. That will strip out the HTML characters.
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> This KB doc explains how to disable RTF editing in the long description field.
>
> http://www-01.ibm.com/support/docview.wss?uid=swg21579206
>
>
> --- In MAXIMO@yahoogroups.com, yudi.irianto@ wrote:
> >
> > Dear all,
> >
> > Does anyone know how to populate text (only) for longdescription? Afaik,
> > longdec has RTF type so if i copy to text it will populate html tag such
> > as: <!-- RICH TEXT -->, <div>, <br></div><div></div><div>sdf</div> and so
> > on.
> >
> > Thanks for any help.
> >
> > Best Regards,
> >
> > Yudi Irianto
> >
> >
> >
>
Hey have you got anywhere with this?? need help
________________________________
From: Brian Swanson <brian_swanson@hermanmiller.com>
To: MAXIMO@yahoogroups.com
Sent: Sunday, May 6, 2012 4:16 PM
Subject: Re: [MAXIMO List] Re: Removing html tag - Crystal reports
Since we can't remove the rich text format, does anybody know what the formula would be in Crystal to remove the tags from a crystal report with long description.
Thanks
Brian Swanson
Systems Analyst-Maximo
Information Technology
hermanmiller.com
HermanMiller
From: "Jason Verly" <mailto:jason.verly%40yahoo.com>
To: mailto:MAXIMO%40yahoogroups.com,
Date: 04/01/2012 05:45 PM
Subject: [MAXIMO List] Re: Removing html tag
Sent by: mailto:MAXIMO%40yahoogroups.com
The other half of my answer was to state that RTF text is out of the box functionality and I don't believe it can be turned off either. Best option is to do a double cut/paste for text entries - text
source to notepad to Maximo. That will strip out the HTML characters.
--- In mailto:MAXIMO%40yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> This KB doc explains how to disable RTF editing in the long description field.
>
> http://www-01.ibm.com/support/docview.wss?uid=swg21579206
>
>
> --- In mailto:MAXIMO%40yahoogroups.com, yudi.irianto@ wrote:
> >
> > Dear all,
> >
> > Does anyone know how to populate text (only) for longdescription? Afaik,
> > longdec has RTF type so if i copy to text it will populate html tag such
> > as: <!-- RICH TEXT -->, <div>, <br></div><div></div><div>sdf</div> and so
> > on.
> >
> > Thanks for any help.
> >
> > Best Regards,
> >
> > Yudi Irianto
> >
> >
> >
>
try REGEXP_REPLACE()
________________________________
From: Jagan Rajan <lensman511@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Monday, May 5, 2014 9:24 AM
Subject: Re: [MAXIMO List] Re: Removing html tag - Crystal reports
Hey have you got anywhere with this?? need help
From: Brian Swanson <brian_swanson@hermanmiller.com>
To: MAXIMO@yahoogroups.com
Sent: Sunday, May 6, 2012 4:16 PM
Subject: Re: [MAXIMO List] Re: Removing html tag - Crystal reports
Since we can't remove the rich text format, does anybody know what the formula would be in Crystal to remove the tags from a crystal report with long description.
Thanks
Brian Swanson
Systems Analyst-Maximo
Information Technology
hermanmiller.com
HermanMiller
From: "Jason Verly" <mailto:jason.verly%40yahoo.com>
To: mailto:MAXIMO%40yahoogroups.com,
Date: 04/01/2012 05:45 PM
Subject: [MAXIMO List] Re: Removing html tag
Sent by: mailto:MAXIMO%40yahoogroups.com
The other half of my answer was to state that RTF
text is out of the box functionality and I don't believe it can be turned off either. Best option is to do a double cut/paste for text entries - text
source to notepad to Maximo. That will strip out the HTML characters.
--- In mailto:MAXIMO%40yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> This KB doc explains how to disable RTF editing in the long description field.
>
> http://www-01.ibm.com/support/docview.wss?uid=swg21579206
>
>
> --- In mailto:MAXIMO%40yahoogroups.com, yudi.irianto@ wrote:
> >
> > Dear all,
> >
> > Does
anyone know how to populate text (only) for longdescription? Afaik,
> > longdec has RTF type so if i copy to text it will populate html tag such
> > as: <!-- RICH TEXT -->, <div>, <br></div><div></div><div>sdf</div> and so
> > on.
> >
> > Thanks for any help.
> >
> > Best Regards,
> >
> > Yudi Irianto
> >
> >
> >
>
Right click on the field in the Design View Select Format Field
Make the Text Interpretation HTML
If you can strip the HTML at the database level (before bringing it into Crystal), I think that is the better solution. I think you use Oracle, so you can use the REGEXP_REPLACE http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm function.
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm
REGEXP_REPLACE http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm REGEXP_REPLACE Syntax Description of the illustration regexp_replace.gif Purpose
View on docs.oracle.com http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm
Preview by Yahoo
A basic regex would look something like this:
<[^>]*>
This will remove whatever is between the less than and greater than.