How to write substring option in transformar with if conditi

deesh · Post by **deesh** » Tue Apr 07, 2009 9:53 am

Please can help in this canse

if OKCSCD in('DE') then substring(OKCUA4,7, end) else Blank

chulett · Post by **chulett** » Tue Apr 07, 2009 10:04 am

Then OKCUA4[7,len(OKCUA4)] Else

Or something similar with Right().

ray.wurlod · Post by **ray.wurlod** » Tue Apr 07, 2009 1:19 pm

If Index("DE", InLink.OKCSCD, 1) Then Right(InLink.OKCUA4, Len(InLink.OKCUA4) - 6) Else ""

chulett · Post by **chulett** » Tue Apr 07, 2009 3:08 pm

Now, that depends on how you read the 'IN' statement in the OP. As written, it is syntactically equivalent to if OKCSCD = 'DE' but if you read it as if OKCSCD like '*DE*' or that the field contains the substring 'DE' then the Index() is appropriate.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 07, 2009 5:37 pm

Code: Select all

Index("DE", InLink.OKCSCD, 1)

is the same as

Code: Select all

("DE" = InLink.OKCSCD) Or ("D" = InLink.OKCSCD) Or ("E" = InLink.OKCSCD)

chulett · Post by **chulett** » Tue Apr 07, 2009 9:46 pm

Ah... didn't notice you had the arguments 'backwards'.