Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Date Format and eliminate string(Date Format)
Date Format and eliminate string [message #1102306] Thu, 05 September 2013 16:14 Go to next message
JP Redro is currently offline JP RedroFriend
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
Re: Date Format and eliminate string [message #1102770 is a reply to message #1102306] Fri, 06 September 2013 03:56 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
Re: Date Format and eliminate string [message #1106159 is a reply to message #1102770] Tue, 10 September 2013 19:40 Go to previous messageGo to next message
JP Redro is currently offline JP RedroFriend
Messages: 181
Registered: July 2009
Location: India
Senior Member

Williams,

Thanks It's works.


Thanks,
JP
Re: Date Format and eliminate string [message #1106183 is a reply to message #1106159] Tue, 10 September 2013 20:13 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Not a problem!

Michael

Developer Evangelist, Silanis
Previous Topic:schema name in DataSet
Next Topic:Error while opening a .rptdesign file in Eclipse Juno
Goto Forum:
  


Current Time: Fri Dec 06 11:06:37 GMT 2024

Powered by FUDForum. Page generated in 0.03799 seconds
.:: Contact :: Home ::.

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

Back to the top