on 09-20-2012 8:23 AM
Hello Every One
I would be getting the date format in yyyyMMdd and i have to display it in dd-MMM-yyyy.
I used date trans function to acive this, now i am getting required format. but i wanted the month to be displayed in caps.
For example the date is 19-Sep-2012 i want it like 19-SEP-2012
I have used To UpperCase function to achive this. The Problem is when i test it in message mapping time it is coming fine, but in the target file it is still coming 19-Sep-2012.
it is a CSV file.
Can any one tell me what could have gone wrong.
Hi,
It might be silly, but... Did you save & activate your change? There shouldn't be any difference between mapping test and real message mapping, in terms of results of the functions you mentioned.
Regards,
Greg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sridhar,
The excel does not allow date to be shown in capital letters unless you write a small function to display the same. Say for example the date appears in excel cell a1. Then in the cell where you want it to be displayed in capital you need to write this function =UPPER(TEXT(A1,"dd-mmm-yyyy")). Below are the screen shot
In case you want to view the output only in excel and no other editor you can use this UDF just before populating the date field in target xml
public static String capitalDate(String date)
{
return "=UPPER(\""+date+"\")";
}
If you view the output in notepad you will get
in excel it will look like
regards
Anupam
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.