how to split multi line filed to several fields

[KrishnaElapavul]

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

[Ben.Lyons1]

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