S
Write on doc file in this format
Size: a a a
2020 June 21
S
So we have used replace activities
P
Use toString(required format)
S
Input in excel from
RB
Uipath job for fresher?
SS
Monthly rental £567.06excl. VAT
SS
how to get only 567.06
SS
?
SS
strMonthlyRental.ToString.Replace("Monthly rental £","").Replace(",","").Trim but how to remove "excl.VAT"
PV
strMonthlyRental.ToString.Replace("Monthly rental £","").Replace(",","").Trim.Substring(0,5)
PV
Try this
PV
Let me know if it works, then we'll try to make it dynamic for any value
AP
But excl.vat is constent or will it change
PV
But excl.vat is constent or will it change
Looks constant to me
PV
But only Shobhit can tell
AP
If its constent then no problem
SS
But excl.vat is constent or will it change
it may change
AP
Ok value
AP
And *
SS
T1 = split (“Monthly rental £567.06excl. VAT”, “£”)(1)
T2=split (T1,”excl.”)(0)
T2=split (T1,”excl.”)(0)