Eclipse Community Forums: BIRT » Date Format and eliminate string

Search

Help

Login

Home » Archived » BIRT » Date Format and eliminate string(Date Format)

Show: Today's Messages :: Show Polls :: Message Navigator

Switch to threaded view of this topic

Create a new topic

Submit Reply

Date Format and eliminate string [message #1102306]

Thu, 05 September 2013 16:14

JP Redro is currently offline

Friend

Messages: 181
Registered: July 2009
Location: India

Senior Member

Experts,

I am working on the report with XML file as Data Source, in that i have a tag as date. This has format as '2013-09-05' but i need this as '05-SEP-2013'.

I have tried with data type as Date and applied Format date in properties as dd-MMM-YY
then i am getting as '05-Sep-2013'.. But i required month in UPPER CASE. Please suggest me.

Also i want to eliminate the number in the string column..

Ex: WELCOME-123
i want to delete -123 and print only WELCOME

This string is dynamic....

Thanks.
JP

Thanks,
JP

Report message to a moderator

Re: Date Format and eliminate string [message #1102770 is a reply to message #1102306]

Fri, 06 September 2013 03:56

Michael Williams is currently offline

Michael Williams

Friend

Messages: 1925
Registered: July 2009

Senior Member

mwilliams.silanis

Take a look at this report. It was made in BIRT 4.3.

Attachment: UppercaseMonthAndRemoveNumbersFromString.rptdesign
(Size: 12.35KB, Downloaded 468 times)

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Date Format and eliminate string [message #1106159 is a reply to message #1102770]

Tue, 10 September 2013 19:40

JP Redro is currently offline

Friend

Messages: 181
Registered: July 2009
Location: India

Senior Member

Williams,

Thanks It's works.

Thanks,
JP

Report message to a moderator

Re: Date Format and eliminate string [message #1106183 is a reply to message #1106159]

Tue, 10 September 2013 20:13

Michael Williams is currently offline

Michael Williams

Friend

Messages: 1925
Registered: July 2009

Senior Member

mwilliams.silanis

Not a problem!

Michael

Developer Evangelist, Silanis

Report message to a moderator

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	schema name in DataSet
Next Topic:	Error while opening a .rptdesign file in Eclipse Juno

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 10 22:49:50 GMT 2023

Powered by FUDForum. Page generated in 0.02178 seconds

.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top