how to split multi line filed to several fields
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-06-21 06:43 AM
Hello Friends,
I have a scenario where I need to read the full address and transform to individual fields.
Example is as below
At first step I tried to train the Decipher to read the address in different fields , but it is not able to do even after 30 + docs trained.
So I thought an other approach where i read full address and split them in to values with the help of formula ( I tried with SPLIT in STR formula but not able to get as there is no split lines formula)
any idea to suggest me please ?
------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------
I have a scenario where I need to read the full address and transform to individual fields.
Example is as below
Multiline flag enabled | Auto calculation flagged | ||
Full address | Value1 | Value2 | Value3 |
ABCD XYZ 321 1234 COUNTRY |
ABCD | XYZ 321 | 1234 COUNTRY |
So I thought an other approach where i read full address and split them in to values with the help of formula ( I tried with SPLIT in STR formula but not able to get as there is no split lines formula)
any idea to suggest me please ?
------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-06-21 09:30 AM
Hi Krishna,
I have a similar query logged with the development team and I'm waiting to hear back. This may come back to me during my annual leave, but I will get back to you on here once I can.
It is possible to split US addresses using the following formula:
ADDRGETSTREET
ADDRGETCITY
ADDRGETSTATE
ADDRGETZIP
Thanks
------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------
I have a similar query logged with the development team and I'm waiting to hear back. This may come back to me during my annual leave, but I will get back to you on here once I can.
It is possible to split US addresses using the following formula:
ADDRGETSTREET
ADDRGETCITY
ADDRGETSTATE
ADDRGETZIP
Thanks
------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------
Ben Lyons
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based
