String Manipulation - 2 line Address

[aaron20]

Hello,

I am trying to take a full address and convert it into the following variables: Address, City, State, Zip. My problem is that I can't figure out how to take my full (2 line) address and convert it into the needed variables. I've tried everything..... Any help would be very much apreciated!!!


*Example

25467 Jake Street NE
Redding CA 85674

*Need

Address=25467 Jake Street NE
City=Redding
State=CA
Zip=85674

[forumsupport]

Hello,

In Automation Anywhere 5.5, enhanced String Manipulation feature with the support for Newline character as a separator can easily make this task possible.

We have attached a sample task for your reference. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

You can download free version of Automation Anywhere 5.5 from our website:
Automation Anywhere - The Leading Automation Software

Hope that helps.

[aaron20]

Thank you for taking the time to help me out. The problem that I'm still having is that your solution doesn't account for a city that is two words (i.e. = Los Angeles, San Antonio, New York). Thanks for your help in advance.

[forumsupport]

Hello,

We have amended the task as per the requirement. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

Hope that helps.

[aaron20]

Thank you! Thank you! Thank you!