DSXchange

ingsic

jwiles wrote:I tried the third option in 8.1 as well and it wouldn't pass validation.

isvalid('DATE',StringToDate(Lnk_campo,"%yyyy%mm%dd"))

isvalid('TIME',StringToTime(Lnk_encabezado.CHDHTR_E,"%hh%nn%ss"))

ingsic

when a job running, I want store in a table start and end time of the execution of the job

ingsic

eph wrote:This topic seems to reply to your concerns

Regards,
eph

ok

but yet need to validate if the following formats are correct:

HHMMSS

isvalid (HH: MM: SS)

thanks

ingsic

Need to validate
if the following formats are correct:

YYYYMMDD
Date:
if isValid ('DATE', StringToDate (StageVar, "% yyyy% mm% dd")) Then StageVar else 0

HHMMSS
Time

isvalid (HH: MM: SS)

Please confirm if it is correct

ingsic

jwiles wrote:Almost, except that your example just creates a string of zeros. Would you have simple concatenated the two strings together?

You could use

left(Lnk_In.V_NUM : svBlanks,9)

where svBlanks is a stage variable initialized as Str(" ",9)

Regards,

thx James

ingsic

I want to align a field to the left and complete its length with blanks.
Is this right or there is another way in the transformer ?

Str("0",9-Len(Lnk_In.V_NUM))

DSXchange

Search found 6 matches

validate

store in a table start and end

validate YYYYMMDD and HHMMSS

align a field to the left and complete its length with blan