Hello ,
Query : I am getting two Values that I want to compare and on that basis have to update my Excel Column.
Value 1 : From Extracted Website’s Data Table (EX: $-222.22)
Value 2 : From Excel’s Filter Data table (EX: -222.22)
Have to check if match or not.
I am getting both values by Assign variables and now not able to match those.
Hello @PALKUMARI_PATEL
So in the website data $ is there ad inthe excel data $ is not there ryt?
If that is yhe case you can append a $ symbol to the value from excel and do the comparison.
For example if value from excel is -22,222 then append $ and make it to $-22,222
I’ve tried that but still it is fetching without $.
Can you explain me how should I achieve ?
Also How to match those in IF Condition :
I’ve two string variables which are fetching those amounts.
Can you let me know the expression to use for mach amount?
ushu
(Usha kiranmai)
July 7, 2022, 5:42am
4
@PALKUMARI_PATEL It was not able to compare values since the first value includes $. So, you have to replace it first and then compare. You can use below exp to replace then compare the values by converting to double since the value includes decimals
If(System.Text.RegularExpressions.regex.IsMatch(Str1,"[$]"), System.Text.RegularExpressions.regex.Replace(Str1,"[$]", "").Trim, Str1)
Str1 is the variable that contains $-222.22
Check attached workflow for ref
Example.zip (2.9 KB)
1 Like
ushu
(Usha kiranmai)
July 9, 2022, 1:51pm
5
@PALKUMARI_PATEL Please mark as solution and close the thread so that it helps others facing with the same/similar issue
1 Like
This is really helpful @ushu . Thank you so much.
1 Like
system
(system)
Closed
July 12, 2022, 3:55pm
7
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.