Removing new line in regex not working

Help Activities
, ,
1

This is the regex I used

Regex.Replace(pdf_Details_NoDate, “(?<=\d.\d{2}***)(\n\s*\n)”, “”)

Text format:

***Elov Chinese Drugstore ***
4,075.82

Four Thousand Seventy Five pesos and Eighty Two Cents only

***ATHENA JILLIAN TOBIA ABIGANIA ***
955.50

Nine Hundred Fifty Five pesos and Fifty Cents only

***Holiday Inn Galleria Manila ***
3,331.17

Three Thousand Three Hundred Thirty One pesos and Seventeen Cents only

***HOLY COW CHOPHOUSE INC.-N ***
5,501.22

Five Thousand Five Hundred One pesos and Twenty Two Cents only

***South Star Drug Inc ***
2,730.81

Two Thousand Seven Hundred Thirty pesos and Eighty One Cents only

***Amphil Lasa Foods Inc ***
8,990.25

Eight Thousand Nine Hundred Ninety pesos and Twenty Five Cents only

Expected output:

***Elov Chinese Drugstore ***
4,075.82
Four Thousand Seventy Five pesos and Eighty Two Cents only

***ATHENA JILLIAN TOBIA ABIGANIA ***
955.50
Nine Hundred Fifty Five pesos and Fifty Cents only

***Holiday Inn Galleria Manila ***
3,331.17
Three Thousand Three Hundred Thirty One pesos and Seventeen Cents only

***HOLY COW CHOPHOUSE INC.-N ***
5,501.22
Five Thousand Five Hundred One pesos and Twenty Two Cents only

***South Star Drug Inc ***
2,730.81
Two Thousand Seven Hundred Thirty pesos and Eighty One Cents only

***Amphil Lasa Foods Inc ***
8,990.25
Eight Thousand Nine Hundred Ninety pesos and Twenty Five Cents only

I wnat this so I able to convert it datatable much easier 3 columns datatable

2

For much clearer view

Text format:

image
image1187×708 22.5 KB

Expected output:

image
image909×539 18 KB

3

@joscares

try this

System.Text.RegularExpressions.Regex.Replace(strvar,"(?<=\d*,?\d*\.\d{2}\*{3}\n)\r?\n","",System.Text.RegularExpressions.RegexOptions.MultiLine)

cheers

1 Like
4

Hi @joscares ,
Could you please try below and update me if you face issue.

System.Text.RegularExpressions.Regex.Replace(your text, "^\s*$", "", System.Text.RegularExpressions.RegexOptions.Multiline)
1 Like
5

Nothing happens after I tested this

6

Hi @joscares

Check the below xaml file:
Sequence.xaml (9.9 KB)

Input:
Input.txt (659 Bytes)

Output:
Output.txt (657 Bytes)

Hope it helps!!

1 Like
8

Document is invalid I can’t open the file

9

Nothing happens on this regex

10

Hi @joscares

Check the below zip file

BlankProcess23.zip (169.8 KB)

Hope it helps!!

1 Like
11

@joscares

Added one more check thsi

System.Text.RegularExpressions.Regex.Replace(strvar,"(?<=\d*,?\d*\.\d{2}\*{3}\r?\n)\r?\n","",System.Text.RegularExpressions.RegexOptions.MultiLine)

Cheers

12

image
image1903×672 29.9 KB

No output when i test it

13

It works if I remove the 2 empty lines at start. So how can i remove the 2 empty lines at start?

image
image887×301 8.66 KB

14

@joscares

Use strvar.Trim

Cheers

15

It works on test workflow but when I run the actual code there’s still new line after amount

image
image910×907 26.6 KB

this is the variables assign

Removal of dates
pdf_Details_NoDate = System.Text.RegularExpressions.Regex.Replace(pdf_Details, “(?:January|February|March|April|May|June|July|August|September|October|November|December)\s\d{2},\s\d{4}\n?|\n”, “”)

Trim new line at start
pdf_Trimmed = pdf_Details_NoDate.TrimStart

Removal of new line after amount (Not working on actual code
pdf_Details_Final = System.Text.RegularExpressions.Regex.Replace(pdf_Trimmed,“(?<=\d*,?\d*.\d{2}*{3}\r?\n)\r?\n”,“”,System.Text.RegularExpressions.RegexOptions.MultiLine)

sample.txt (84.3 KB)

16

@joscares

according to the text file I made this cchange please try

System.Text.RegularExpressions.Regex.Replace(strvar,"(?<=\d*,?\d*\.\d{2}\*{3}\s{1})\s+","",System.Text.RegularExpressions.RegexOptions.MultiLine)

image

Hope this helps

cheers