Multi line string split

[Zeba (Affy)]

Hi all,

I have user addresses data in multi line string format,
Example:
Address = “355 Point Rd,
Kenansville, C
A
0335
7”
I am trying to split the address to add in a table like
Street name = 355 Point Rd
City = Kenansville
State = CA
Zip code = 03357

I tried

Split string multi lines

Hi guys I need to get all strings after “=” for each line DOMAINE = 1 SOC= 1 OBJ = Demande PRI = 2 Can you help me please?

Didn’t got the desired result, any advice please

Thank you and Happy Automation!

[Yoichi]

Hi,

How about the following sample?

Sample20220707-3.zip (3.8 KB)

Regards,

[Zeba (Affy)]

Thanks @Yoichi but it didn’t worked for me. When you convert the string to an array, the index is not extracting the same street name for all users.

[Yoichi]

Hi,

Can you share some examples (input and expected output)?

Regards,

[Zeba (Affy)]

Input:
I have 10 invoices of scanned PDF where I need to take the details of the customers and add to an excel sheet, the multi-line string I got is from “Screen scraping → Get full text”.
Note: I cannot use OCR for this activity.
Output:
Get all the details of each invoice