topic Re: Getting Text with NewLine in Product Forum

Getting Text with NewLine

NiklasFranke — Wed, 04 Jan 2023 15:08:43 GMT

Hello,

i have a text like this
and want to extract the text after ":".
The length of the extractet text can variate. My Idea was to do this with the Mid Function like this but the the length is not right. I think that im using the Newline Character wrong.
I can solve the problem with
But this will not work for the last entry cause i dont have a word after it like "Datum:"
I mean, i can spilt the text with NewLine() in a collection, but there must be an easier way..

Re: Getting Text with NewLine

Soumya21 — Wed, 04 Jan 2023 15:30:11 GMT

Hi @Niklas Franke

Try using Extract Text Field action from Utility Strings and give inputs pretext and post text.
For your question pretext would be Messobjekt: and post text would be Datum

Thanks,
Soumya

Re: Getting Text with NewLine

EslamGhandour — Wed, 04 Jan 2023 16:01:56 GMT

Hi @Soumya21 I believe this action you're mentioning is a costumed action as it's not originally in the VBO. You can find that in the documentation of the VBO on Digital Exchange following this link. Utility - Strings

Hi, @NiklasFranke please check this thread String Manipulation-Fetch data in between the string | Blue Prism Product the question is identical to yours. If you are familiar with regex multiple answers available there achieving it.
I also provided an answer there that does not use regex and work with basic actions in BP.

Hope this is helpful.

Re: Getting Text with NewLine

Soumya21 — Wed, 04 Jan 2023 16:30:24 GMT

Hi @EslamGhandour
Yes, its costumed action
I have attached Extract Field Action Page which you can add in Utility String VBO and use according to your requirement

Hope this helps,

Thanks,
Soumya

Re: Getting Text with NewLine

MichealCharron — Wed, 04 Jan 2023 17:47:35 GMT

@NiklasFranke

This is very similar to String Manipulation-Fetch data in between the string | Blue Prism Product. You could use the same instructions I provided for that answer with the following Regex pattern:

Messobjekt:\s(?<Messobjekt>.*)[\r\n]+Datum:\s(?<Datum>.*)[\r\n]+QS-Nummer:\s(?<QSNummer>.*)[\r\n]+Seriennummer:\s(?<Seriennummer>.*)[\r\n]*

You would end up with an output collection like:

Re: Getting Text with NewLine

NiklasFranke — Thu, 05 Jan 2023 11:36:37 GMT

Hello together and thank you all for your help.

@MichealCharron sadly, im dont have "Extract Regex All Matches" but i have "Extract Regex Values" what should also work.
I tryed it like this:
But i had to add the Field "Name" and "Value" to the collection to made it work and now i just get this...

Re: Getting Text with NewLine

NiklasFranke — Thu, 05 Jan 2023 12:03:36 GMT

Okay i almost got it at least for the first word.

But it looks that the [\r\n]+ is beeing ignored.

Re: Getting Text with NewLine

NiklasFranke — Thu, 05 Jan 2023 13:14:26 GMT

Hello all,

unbelievable but i tried ChatGPT and it solved my Regex Problem.. has to be "Messobjekt:\s(?<ExpectedText>[^\r\n]*)"

Anyway thank you very much for the help.

Re: Getting Text with NewLine

MichealCharron — Thu, 05 Jan 2023 13:16:33 GMT

@NiklasFranke

For the "Extract Regex Values" action, you need to specify the names of the capture groups. In the Regex pattern the name of the capture group is denoted by ?<capture group name>. In the case of the Regex pattern I specified above, the "Named Values" input collection should look like:

The only problem with the "Extract Regex Values" action is that it is very cumbersome to retrieve the individual values from the output collection because they are on separate rows:

Blue Prism's newer "Utility - Strings" VBO, with the "Extract Regex All Matches" action, can be downloaded from their Digital Exchange site at:
Utility - Strings : Blue Prism Digital Exchange

Re: Getting Text with NewLine

NiklasFranke — Thu, 05 Jan 2023 14:38:20 GMT

Hello @MichealCharron

somehow my IT was really fast and added the new VBO..Thought that would take 1-2 weeks. I got it right with "Messobjekt:\s(?<Messobjekt>.*)[\r\n]+Datum:\s(?<Datum>.*)[\r\n]+QS-Nummer:\s(?<QSNummer>.*)[\r\n]+Seriennummer:\s(?<Seriennummer>.*)[\r\n]"

But it would not work at first because the "-" in "QS-Nummer" seemed to be another type of line.. unbeliveable.. solved it trough copying the word into the Regex.

Thanks a lot, the extraction with they new VBO is way easyier like you said.

Re: Getting Text with NewLine

MichealCharron — Thu, 05 Jan 2023 14:59:32 GMT

The dreaded em dash (–). It gets people every time.