LIKE operator in IF ELSE Condition

[priyadarshikunal]

You can use

if index("DELL", InputString)=1 then "DELL" else (if index("Cisco", InputString)=1 then "Cisco" else 'N/A')

or you can use left/substring("[]") function to achive the same.

[chulett]

The Index() suggestion is akin to '%DELL%' rather than 'DELL%'. Use a simple substring check on the front of the string for that:

Code: Select all

If Link.Field[1,4] = 'DELL' then 'DELL' else if Link.Field[1,5] = 'Cisco' then 'Cisco' else 'N/A'

[sarathi]

Thanks for comments. My task is NOT to check exact string but should work as Oracle like command - Like 'DELL%.

Tried to use Index send by Kunnal but not parsing.
Craig If Link.Field[1,4] condition is working but what if we have values 'DELL12' or 'Cisco32'

if index("DELL", LkFrom_CMDB_Table_Reject.VENDOR )=1 then "DELL" else (if index("Cisco", LkFrom_CMDB_Table_Reject.VENDOR)=1 then "Cisco" else 'N/A')

Sarathi

[DSguru2B]

What Craig advised will work as 'DELL%'

[chulett]

That's the whole reason why Craig suggested it.

Checking Field[1,4] which disregards anything else that follows in the string is exactly the same functionality as checking for like 'XXXX%'.

[gateleys]

So, MATCHES 'DELL...' did not work?

[chulett]

That should be fine as well, I would imagine, depending on where it was being used.

[sarathi]

If Link.Field[1,4] = 'DELL' then 'DELL' else is working.

I tried Matches 'DELL' with 'If then else' condition and it was not working.
My assumption is we need to use substring[] for IF THEN ELSE

Thanks for all

Sarathi

[ray.wurlod]

For processing efficiency load the first four characters into a stage variable, for example svFirstFour. Map to upper case if your data contain mixed case.

Code: Select all

If svFirstFour = "DELL" Then "DELL" Else If svFirstFour = "CISC" Then "Cisco" Else "N/A"

[Sainath.Srinivasan]

Or use filter stage

.....and yes...it is not transformer state.

[priyadarshikunal]

The Index() suggestion is akin to '%DELL%' rather than 'DELL%'.

If the condition is index()=1 then it will work like 'DELL%' and index()<>0 is similar to '%DELL%'.

also the index command should be

if index(InputString, "DELL",1)=1 then "DELL" else (if index(InputString,"Cisco", 1)=1 then "Cisco" else 'N/A')

[chulett]

The Index() suggestion is akin to '%DELL%' rather than 'DELL%'.

If the condition is index()=1 then it will work like 'DELL%' and index()<>0 is similar to '%DELL%'.

True, but my point was that it does a substring match across the entire string so can find it anywhere and without you specifically checking where it found the string it can get you in trouble. To me it makes much more sense to just look at the first four (or five) characters if that's all you want to check, whether that's via substring or left. More efficient and more 'self documenting'. Yours can look like a simple true/false/zero/one test to the untrained or hurried eye.

[priyadarshikunal]

More efficient and more 'self documenting'. Yours can look like a simple true/false/zero/one test to the untrained or hurried eye.

I agree.