Split String(Getting the specified ID)

[Dawodm (Mahmoud Dawod)]

Can you please share your sequence?

[prasath17 (Guru)]

@HeartCatcher - then you don’t have do it .

Can you show your sample output result in the same sheet. ? I.e. both input and output

[HeartCatcher (Naveenkumar.S)]

Flowchart1.xaml (28.2 KB)
PFAAirtel_Spice_Recon.xlsx (152.8 KB)

EXTERNAL_REF_NO(column name)

[HeartCatcher (Naveenkumar.S)]

No actually I am trying to get output in Write line inside for each loop as in the attachment.

[Dawodm (Mahmoud Dawod)]

I cannot see your sequence.

[prasath17 (Guru)]

@HeartCatcher - Here you go…this simple workflow will print the output…

if(Regex.IsMatch(CurrentRow(0).ToString.Trim,"SET\d+",RegexOptions.IgnoreCase),Regex.Match(CurrentRow(0).ToString.Trim,"SET\d+",RegexOptions.IgnoreCase).Value,"No Match")

Logic: First i am checking if there is SET value is found in the row…if true, I am printing the match value if not i am writing it as No Match…

My Output(just snippet)

[HeartCatcher (Naveenkumar.S)]

<?xml version="1.0" encoding="utf-16"?>TrueFalse__ReferenceID0

[HeartCatcher (Naveenkumar.S)]

please look into the photo to see the matches activity

[prasath17 (Guru)]

@HeartCatcher - your regex code is incorrect.

please check my post for the solution…you said, you just wanted to print the output in the write Line which I showed how to…

[HeartCatcher (Naveenkumar.S)]

@prasath17,
Thanks very much for your help and time its working fine.

[HeartCatcher (Naveenkumar.S)]

@prasath17 ,
at the end I need to write into a column

[prasath17 (Guru)]

@HeartCatcher - once you are done with your testing …please mark my post as solution as it help others.

[HeartCatcher (Naveenkumar.S)]

@prasath17,
Its done

[prasath17 (Guru)]

@HeartCatcher

at the end I need to write into a column

This is exactly i am asking you from the beginning, but you said you just wanted to write the output in the write line…

@prasath17

I guess you are trying to save all the results and right to the output column right ? Please confirm.

@prasath17

If you want the result to be in column B…create the column first and then add the output to that column

Going forward, please provide your requirement clearly , even if you are newbie you should know what is your input and desired output…

[HeartCatcher (Naveenkumar.S)]

Yes, sorry I didn’t explain correctly

[prasath17 (Guru)]

@HeartCatcher - Here you go…

Add DataColumn

Assign Code

CurrentRow("SubString") = if(Regex.IsMatch(CurrentRow(0).ToString.Trim,"SET\d+",RegexOptions.IgnoreCase),Regex.Match(CurrentRow(0).ToString.Trim,"SET\d+",RegexOptions.IgnoreCase).Value,"No Match")

Output

Hope this helps…

[HeartCatcher (Naveenkumar.S)]

@prasath17,

Thanks for your valuable response its a lot to me, please help me to improve in UiPath as I am a new to this technology.

Best Regards,
Naveen Kumar S

[HeartCatcher (Naveenkumar.S)]

Hi @prasath17,

I am trying to subtract two number but I am getting error.
Below steps which I am doing.
1.Read excel(DT1).
2.For each in(DT1).
3.Get row item(credit)
4.Get row item(debit).
5. Result=credit-debit–> here I am getting an error like in the attachment

please help me