Hello, I’ve been trying multiple ways to properly read a dummy invoice. My goal was to get 4 addresses/bank details. I managed to use regex and seperate the addresses from the pdf extract. These addresses are in proper format (Maintains lines for Company Name, City in next line, Country in 3rd li…

Hi, How about the following step? [image] Insert linebreak at ahead of the first number. yourString = System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=^\D+)\s+(?=\d)",vbcrlf) Insert linebreak at behind the last 2nd comma. yourString = System.Text.RegularExpressions.Regex.Replace(y…

Need help to string manipulate a single address into multiple lines

Help Activities

system (system) Closed December 14, 2022, 7:58am 6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Help with extraction of multiple data from pdf invoices Studio excel , pdf , studio , question	3	1062	April 28, 2020
Multi line string split Automation Starter	4	866	July 7, 2022
Extracting invoice file to excel Help excel , pdf , activities , string , question , data_manipulation	7	1564	December 2, 2019
Invoice pdf Help excel , pdf , activities , string , question , data_manipulation	12	5033	December 2, 2019
Need help with idea for string manipulation Activities pdf	7	1329	October 18, 2021

Need help to string manipulate a single address into multiple lines

Related topics