DSXchange

Hello, I want to add 100 years for the TimeStamp. How to do it? Thought of adding days, but is there any other way to do this? Thanks in advance. Naidu Buddha Probably the most simplistic approach is (DSJobStartTimestamp[1,4]+100):DSJobStartTimestamp[15] replace DSJobStartTimestamp with whatever yo...

Hi, Probably not as nice a solution as Ray's but the following will do what you want Create a Function DateOfMostRecentWeekDay(DateIn,DayOfWeek) ***************************************************** * * Will give the date of the most recent weekday to the date * ie if Friday and current date is 28/1...

Simply use Input1[1,3]:' ':Input1[4,LEN(Input1)-3] That's if your input data is to be ALWAYS split with 3 characters in the first word followed by a space and rest of the characters. What is your criteria for splitting a word into 2? The criteria was implied that the split happened between the 3rd ...

If you want to execute the substring operation through transformer then below is an example what you can refer. Input1 - column name expression in the transformer stage expression editor. Input1[1,3] note: 1 is the starting position and 3 is the string length. if your Input1 data is "SUBSTRING...

You could use the oracle date format RR instead of YY
as in TO_DATE(date,'DD-MM-RR')

I believe it was set up to cope with the transiton between centuries.

You could do the seperation in datastage if you wanted. Read the file in with file delimeter 000 quote delimeter 000. Then use the Count($,',')="Correct Number Of Commas" in a constraint and write the results out, with file delimeter 000 quote delimeter 000. You can put the invalid records...