DSXchange

yes I did that

TimestampFromSecondsSince(10800,StringToTimestamp(i.column,"%(m,s) %(d,s) %yyyy %(H,s):%n:%s"))

Thanks for the reply

I have source data as Nvarchar Source. 12/01/2013 15:13:17 -0800 12/09/2013 13:41:12 -0800 01/07/2014 07:09:40 -0800 I need to add 3 hours for only hours part. 12/01/2013 18:13:17 12/09/2013 16:41:12 01/07/2014 10:09:40 I tried to substing[1,19) then convert to string to timestamp then it is working...

Hi All I am trying to get the data between the string dynamically which is '~'. Any ideas would be appreciated. Source 0000000002 000000000 ~0000000009~1001~ ~VENDOR~0000000138~1001~ ~VENDOR~0020009816~2001~ ~0020009816~2100~ Target required 0000000002 000000000 0000000009 0000000138 0020009816 0020...

Hi Arndw/Ray,

As per your suggestion we exported the job and ran small java program on that dsx file then again reimported it it worked like charm. Thank you all once again.

Hi ray/arndw,

I will get back to you on this.. any way thanks for valuable suggestions..

hi all I have requirement I have 600 coulmns in xfm were I need to put same derviation for all 600 columns except numbering which is highlighted below. Trim(Field(svREC, svnewdel, 1 ),svquote,'B') Trim(Field(svREC, svnewdel, 2 ),svquote,'B') Trim(Field(svREC, svnewdel, 3 ),svquote,'B'). ...............

StringToTimestamp(lnk_src_exl_onbase.DATE,"%(m,s)/%(d,s)/%yyyy%(H,s):%nn:%ss%aa")

HI All,
my source has a varchar column DATE with following data :
8/3/2012 12:00:00 AM

My target should be like this
2012-08-03 00:00:00

I tried with date conversions but not getting exact output any ideas really appreciated Thanks M

after this I did the substring it worked fine thanks for your idea.

it worked partially for vendor it worked fine but LFA1 it brought the output with 1 and then the data? how to resolve this source_data Target data ~LFA1~0005002430~ outputwould be 10005002430 ~VENDOR~33940~ outputwould be 33940 ~VENDOR~217~1095-1~ outputwould be 217~1095-1

chulett wrote:We both did.

I said sorry

Sorry its my mistake could give some derviation for the above

So... how accurate is your example data? Are you literally looking for just "LFA1" or "VENDOR" or does it not really matter what value the "literal string" contains? Can this requirement boil ... Hi chulett, The literal string will be LFA1 and VENDOR only not other tha...

Hi all I have input.column. I need to satisfy this on both conditions any idea? "Parse all value after the string literal i.e. LFA1 or VENDOR, e.g. source_data Target data ~LFA1~0005002430~ outputwould be 0005002430 ~VENDOR~33940~ outputwould be 33940 ~VENDOR~217~1095-1~ outputwould be 217~1095-1

Hi Andrew,
So I should create parallel routine..Andrew?