Timestamp conversion

[srekant]

Hi,

My input is Jan

Code: Select all

12 1995 12:00:00:000AM

and i want the output to be yyyymmdd.How can i achieve this.

[ArndW]

This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result.

[srekant]

This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result.

but my input date is not going to have month as jan every time

[srekant]

This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result.

sorry the input is going to be like this

Code: Select all

Jan 12 1995 12:00:00:000AM
Aug 29 1995 12:00:00:000AM

and expecting output to be

19950112
19950707

[ArndW]

srekant,

that's nice, so your input format is different from your initial query. Now you need to use a date conversion algorithm instead of a string function. Have you looked at the date conversions that Px offers?

[Prashantoncyber]

Again, I feel it can be done as string manipulation with out using date

conversion like this,

if Field(Instring,1," ")=JAN

then In.InString[4,4]:'01':In.InString[1,2]

else In.InString[4,4]:'07':In.InString[1,2]

Hope not going against ArndW

Correct me if i am wrong?

Thanks

Prashant

[ArndW]

Prashant,

looking at your code, you would need to quote 'JAN' and if you only have dates in January and July then you will be set. But what happens with 'MAR'?

[Prashantoncyber]

Arndw,

That's true it will work only for JAN & AUG.
Seeing the sample data provided , i presumed so.

Thanks
Prashant

[lshort]

You could use the code below to determine the month number.
The rest should be a simple matter of concatenation and the StringToDate function.

Put the delimited Month list in the default value for a Stage Variable (svMM). Leave the derivation empty.

svMM(default) = 'Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec'


use this code to get the month number (ie. 01, 02...12) where Month is the string value from your input.

MM =((COUNT(svMM[1,Index(svMM,Month,1)],'|')+1)/100)[3,2]

[lshort]

mydate= 'May 12 1995 12:00:00.000 AM'

mydate[8,4]:((COUNT(X[1,Index(X,mydate[1,3],1)],'|')+1)/100)[3,2]:mydate[5,2]

Result = 19950512

[ray.wurlod]

You could use the code below to determine the month number.
The rest should be a simple matter of concatenation and the StringToDate function.

Put the delimited Month list in the default value for a Stage Variable (svMM). Leave the derivation empty.

svMM(default) = 'Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec'


use this code to get the month number (ie. 01, 02...12) where Month is the string value from your input.

MM =((COUNT(svMM[1,Index(svMM,Month,1)],'|')+1)/100)[3,2]

Lance,
Check out the lookup_int16_from_string operator in the Modify stage
Page 27-9 of Parallel Job Developer's Guide for v7.x

[info_ds]

hi lance,

mydate= 'May 12 1995 12:00:00.000 AM'

DateToString(StringToDate(mydate[1,11],"%mmm %dd %yyyy"),"%yyyy%mm%dd")


can we implement this way?

[ray.wurlod]

How about you try it and let US know? Lance is probably asleep as I post.

[info_ds]

hi ray,

i tried and got the result --> 19950512

any suggestions?

[srekant]

hi ray,

i tried and got the result --> 19950512

any suggestions?