How to remove the new line formed when parsing a text

(0) Share

Report

Posted on by devinpal

Hello,

I'm new to PAD and Regex, and I tried extracting text from a pdf then parsing it so I can get a text of:

Article X Section Y

I used the regex (?i)article\s?\n?\s\d\d?\s?\n?((?i)section\s?\n?\d\d?)? just in case the full text is separated with a line in the pdf, also in case the X and Y contains more than one digit.

The problem is, it seems that the text extracted is separated with a line, so it looks like this:

Article

X Section Y

I tried replacing the regex \n in the extracted text with %""% to delete the new line but it doesn't seem to work.
Can anyone help?

Thanks in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (18)

Answers (1)

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

It should technically work. Can you share a screenshot of your Replace text action? Are you sure you enabled regular expressions? Did you store the result in the same variable?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi @devinpal

Can you share the sample pdf which you are trying to extract using the PAD?

Or the sample text you are able to extract in a notepad also works

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @devinpal

Give a try like this ?

Replace action

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
devinpal 49 on at

Like (0)

Report

Thank you very much for the replies.

I'm sorry that I can't provide the pdf, but this is basically what was extracted.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx -
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Article
X section Y xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx -

and this is the result that appears in the window.

The second and the third works because they're from a single line in the text source, so it's like:

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Article X section Y xxxxxxxxxxxxxxxxxxxxxx -

Though in the list it's shown as a single line with a strange double spacing.

deleting \s deleted the new line apparently:

But I can't seem to fill the results with a space after that, or maybe this is not how replace text works.

I hope this provide enough information, thank you.

Was this reply helpful? Yes No
devinpal 49 on at

Like (0)

Report

And this is my attempt on using "Replace \n with %""%", it's not working.

Though it's strange that in the list, a single space is shown instead of the double space shown from previous follow-up. Seems that removing \n actually works but it still doesn't remove the new line.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

If you want to replace text with something that is also a regular expression, you should also enable the "Activate escape sequences" toggle on the Replace text action. But what you've shown in the screenshot is not how it works, really. You cannot use full patterns like [A-z] or \d in the "Replace with" field. You can only use placeholders for specific symbols, such as \s for a white space or \t for a tab.

I am still not quite sure what you're trying to accomplish. Seems like you're replacing newlines in a list of text values. Can you please share a screenshot of your flow, so we can get a better idea of what actions you are using and whether they're laid out correctly?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
devinpal 49 on at

Like (0)

Report

So basically what I'm trying to do is to extract all texts with "Article X section Y" in a pdf file.

I used the regex (?i)article\s?\n?\s\d\d?\s?\n?((?i)section\s?\n?\d\d?)? so:
1. I get the "Article X section Y" in the pdf file, then save the texts in a list
2. I can still get the "Article X section Y" text even if there's no spacing (for example ArticleX sectionY), thus the \s?
3. I can still get the "Article X section Y" text even if there's more than two digits of X and Y's number but less than 3 digits, thus the \d\d?
4. I can still get the "Article X section Y" text even if there's a new line separating the text, thus the \n?

But, apparently when the source pdf text is separated by a line, the extracted text is also separated by a line. What I'm trying to accomplish is getting an extracted text that's just one line with the format of "Article X section Y".

So I tried removing \n and \s. Removing \n somehow doesn't work so I tried removing \s, which worked but then all the characters has no space. So, I tried adding space between alphabet and number but I don't know how to do that.

I hope that explains my intention, thank you.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

I got that part. I'm not quite sure about how you're trying to replace the newline. I have already asked you to provide a screenshot of your Replace text action that does not work (for replacing newlines), but you have not provided it. Can you please provide some screenshots of your flow, including the details of the Replace text action, as well as the other actions that manipulate the text?

I'm quite confident it should work with \n, but you may be using it incorrectly. If you show us what you've done (in the form of screenshots), we might be able to pinpoint the problem.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
devinpal 49 on at

Like (0)

Report

Sorry for the trouble, this is what I did to remove the new line.

and this is what I did to get the text.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Okay. And then you somehow put it into a list?

Was this reply helpful? Yes No