How to get this text?


#1

Hi everyone.

I have a very simple doubt.

Let’s assume we have a lot of texts with the same structure and format:


From: account@account.account

Hello,
How are you?
Example


I would like to know how to get all the text below “From: account@account.account” so that It would be:


Hello,
How are you?
Example


I mean I just want to delete the first line. How should I do it?
If I wanted to delete the first two lines, what could I do?

Thanks a lot.


#2

@pal1910 try this

Assign str1 = str1.Split(“account.account”.TocharArray)(1)


#3

If you do not know the email - then use regular expression

Match(“From: (any string until new line)\n(any string including new line)”) … your second variable $2 would have the text you need.

You can then replace the context of that document with $2 or you can create new one.


#4

Thanks for replying.
But the account may change. It was just an example.
It could be example@account.anotherexample


#5

Please, could you send me some picture on UiPath? I do not get it very well.

Thanks a bunch.


#6

@pal1910 Can you tell what is the email format you are getting


#7

@pal1910 split ur text wrt newline, then u can join text from array(from 1st position), to get required output


#8

The format is as follows. The text below the email account is random (it could be one or several lines).
EXAMPLE 1:

From: EMAILACCOUNT

Text1

EXAMPLE 2:

From: ANOTHERACCOUNT

Text2
Text3


#9

I do not understand it very well…


#10

@pal1910 i have created solution by creating text files in ur format. Find solution file below.
text-----.xaml (8.2 KB)

change things in file according to you