Dear Master, Pls provide solution or code for this problem with out using IF condition

[Lokesh_M2 (Lokesh M)]

Here if VALUE is numeric,write ‘458’ in OUTPUT column
if VALUE is the alphabet,write ‘zxy’ in OUTPUT column
if VALUE is a symbol,write ‘^&*’ in OUTPUT column
and Final Status be successful
if there is no data, FinalStatus is Unsuccessful.
Here i should NOT USE IF condition.TQ
Pls provide solution.Tq

[Yoichi]

Hi,

In this case, I recommend to use Dictionary as the following.

dict =New Dictionary(Of string,string)From{{"numeric","\d+"},{"alphabet","[A-Za-z]+"},{"symbol","\W+"}}

judge = New Dictionary(Of Boolean,string)From{{True,"success"},{False,"Unsuccess"}}

Then

m =System.Text.RegularExpressions.Regex.Match(CurrentRow("data").ToString,dict(CurrentRow("value").ToString))

m.Value

judge(m.Success)

Sample20221201-4.zip (9.1 KB)

Regards,

[RajKumar_DC (RajKumar Durai)]

Hi @Lokesh_M2 ,

What about below workflow

Workflow

Xaml
Sequence7.xaml (3.5 KB)

stOutput

If(Row(“Value”).ToString.ToUpper=“NUMERIC”,“458”,
If(Row(“Value”).ToString.ToUpper=“ALPHABET”,“zxy”,
If(Row(“Value”).ToString.ToUpper=“SYMBOL”,“^&*”,“”)))

stFinalStatus

If(String.IsNullOrEmpty(Row("Final Status ").ToString),“Unsuccessful”,“Successful”)

Best,