Page 1 of 1
String to date format
Posted: Fri Oct 19, 2007 1:50 pm
by samuel.rajesh
Hi ,
Am converting a string to date using the below transformer function (StringToDate(Lnk_Transaction_Read.ORDR_VLE_DT,"%yyyy%mm%dd"),
However the output is the following format "YYYY-MM-DD" how do i remove the "-" ,thanks in advance .
Sam
Re: String to date format
Posted: Fri Oct 19, 2007 4:28 pm
by edison
samuel.rajesh wrote:Hi ,
Am converting a string to date using the below transformer function (StringToDate(Lnk_Transaction_Read.ORDR_VLE_DT,"%yyyy%mm%dd"),
However the output is the following format "YYYY-MM-DD" how do i remove the "-" ,thanks in advance .
by using e-replace command u can do that right,go in the help and write e-replace u will get clear idea to remove"-"
Sam
Posted: Sat Oct 20, 2007 2:14 pm
by ray.wurlod
You don't need to remove the "-" characters - display of dates is governed by the default date format string you have defined. When Date data types are written to database tables, they are loaded as type Date; display format is ignored. If you are writing to a text file, don't use the Date data type, and simply trim the "-" characters from the string using Trim() or Convert() function.
Remove " " (double quotes)
Posted: Sun Oct 21, 2007 5:36 am
by mcs_murali83
Hi,
If you want to remove the double quotes, while u r importing the meta data
into your repository folder, a window pops up. In that specify " (double quotes) in that box.
(i.e) quote "