how to split multi line filed to several fields

KrishnaElapavul — Fri, 04 Jun 2021 05:43:00 GMT

Hello Friends,
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

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
------------------------------

RE: how to split multi line filed to several fields

Ben.Lyons1 — Fri, 04 Jun 2021 08:30:00 GMT

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
------------------------------

topic RE: how to split multi line filed to several fields in Product Forum

how to split multi line filed to several fields

RE: how to split multi line filed to several fields