DSXchange

Thanks boxtoby.

Your logic worked for me.

I have scenario. Input : source | destination | distance city1 | city2 | 500 city2 | city1 |500 city3 | city4 | 500 city4 |city3 | 500 How to delete vice versa duplicates. Output should be: source | destination | distance city1 | city2 | 500 city3 | city4 | 500 How to achieve above situation using d...

I achieved it through trimming input time stamp micro seconds. If year is <50 then added 20 else 19 to the year. Note : DSLink2.A is input value stgvar = Left(DSLink2.A,6):'-':(If Right(Left(DSLink2.A,9),2) >=50 Then 19:Right(Left(DSLink2.A,9),2) Else 20:Right(Left(DSLink2.A,9),2)):' ':Right(Left(DS...

How to get below string to timestamp

Input :
05-SEP-13 12.00.00.000000000 AM
01-JAN-99 11.59.59.000000000 PM

Output :
2013-09-05 12:00:00
1999-01-01 23:59:59


Thanks in advance

Am at client Location.

Upgrade not posmsible. Please give another solution.

DS version : 8.0.1
AIX

I have below requirement. Please give me suggestion.

Source :

col 1 | count | multiplier

a|4|10
b|2|20


I want output like this.

a|1|10
a|2|20
a|3|30
a|4|40
b|1|20
b|2|40

Thanks in advance