DSXchange

hai Ray, I have got the output in this way StageVariable1 if Len (Field(DSLink2.date_f,"/",1))=1 then "0":Field(DSLink2.date_f,"/",1) else Field(DSLink2.date_f,"/",1) StageVariable2 if Len (Field(DSLink2.date_f,"/",2))=1 then "0":Field(DSLi...

Hai Ray,

StringToDate function is working if my input date is 01/01/2005(having length 10). It is not working if the input data is 1/1/2005(having the length .Why is it so. Thanx in Advance

Regards
Ravi

Hai ArndW,

i have tried using StringToDate(ip.date,"%yyyy-%mm-%dd")
iam getting the output as

"**********",2005,1,1,1,7,1,1,1,31,"SATURDAY","JANUARY

Regard's
RAvi

Hai All,

I have a date field of the format 1/1/2005 and my output should look like 2005-01-01. How can i achieve this. Thanx in Advance

Regard's
RAVI

Hai Friends, I have two CSVinputs and here is the sample date for you to work out First file Input "Code","Name","Color" "100","CBZ","Silver" "101","SPLENDOR","Black" "102","CD100","Red...

Hai Vinay,

i have run the job it works for me and just you have to enable row buffer to inter process by default it will be project defaults in the performance of job properties.


Ravi

Hai,

source field julian date value
TaxDate 103127

target= sequential file
target field datatype value
TaxDate Date <<mm/dd/yyyy>>

Ans:

Oconv(103127, "D/E") results as 08/05/2250

hope this helps

RAVI

Hi,

FMT(49477404.97, "R2,") ie

FMT(Input, "R2,")

Ans = 49,477,404.97

Hope this helps



Ravi

Hai Vinay, I have a solution for your query. let me say how i have solved. i have taken three inputs each connected to tranformer and now i have 3 transformers and i have linked them to Link Collector. in the job properties-->Performance enable row buffering to inter process. there is no need of usi...