String Values

[Robotics (Bala)]

Hi Team,

I reading a date value using OCR
Exact date is : 08/06/90
Extracted as : 08106190

I want to remove this 1 and replace with /. We cant do replace function because if
date is 18/06/90 means 1 will be replaced with /.

So how to read the 3rd and 6th character from the end of the date, so that we can
get the value 1 ?

[Manish540 (Manish Shettigar)]

Check this workflow, @Robotics
String_Data_Extraction.xaml (4.7 KB)
Hope this may help you

[ImPratham45 (Prathamesh Patil)]

Use
Var=08106190
Var=var.substring(0,2)+“/”+var.substring(3,2)+“/”+var.substring(6,2)

[Robotics (Bala)]

Given code is working fine when output extracted as 08106190
Now i came across another different output as 8106190
If this is the output how do i change your code ?

[ImPratham45 (Prathamesh Patil)]

You can use like this
If var.length=8
Then
Var=var.substring(0,2)+“/”+var.substring(3,2)+“/”+var.substring(6,2)

Else
Var=var.substring(0,1)+“/”+var.substring(2,2)+“/”+var.substring(5,2)

[Robotics (Bala)]

Yes its working fine, Thanks

[ImPratham45 (Prathamesh Patil)]

Welcome
!

You have marked solution to your comment

Happy Automation!