Remove first line (CrLf) in text file

[BCdev (Baptiste)]

Hello everyone !

I work in a text file and i would like to delete the first line. My text file :

I want to delete the line number 1. I don’t know if i can use an assign with .Replace(vbCrLf, ???) or if i can use another method.

i have 3 text files like that with always the same issue.

Anyone what a method to do that ?

Thank you all for your help

[Palaniyappan (Forum Leader)]

Hi
hope these steps would help you on this
–use a READ TEXT FILE activity and pass the file path of the text file
and get the output with a variable of type string named str_input
–now use a ASSIGN activity and mention like this
str_output = String.Join(Environment.Newline,Str_input.Split(Environment.Newline.ToArray()).AsEnumerable().Skip(1).ToArray())

Cheers @BCdev

[balupad14 (Balamurugan)]

Hi @BCdev,

I have developed a package to facilitate the Text file automation.

UiPath Go ! BalaReva.EasyText (Text Format File Utilities Package)

Hi, I have developed a package to make easy the text file format utilities. It is a package to handle the automation for Txt,Csv,Xml ,Json and TextFormat File This package has many activities to handle the text format files like Txt,Csv,Xml ,Json and TextFormat File. The activities are to handle insert,update,delete and other operation. TextScope - It is a scope activity.It keeps only the file path. It doesn’t keep the text file resource. DeleteAt - Delete the line at specific line Find &…

Here is the steps to remove the first line.

Regards
Balamurugan.S

[BCdev (Baptiste)]

Hi @balupad14,

Thank you for your help, it will be helpful !

Maybe you can resolve my other issue. When i want to read text file with a bigger size (500Ko-600Ko) i have an error message like that :

Error message : Impossible to recover the result of the task execution. Maybe, the message is so long to be treated"

This error message come when i launch my robot with debugging mode and with UiPath Robot (attended robot). Do you know why and how i can resolve this ?

Thank you

[balupad14 (Balamurugan)]

if you don’t mind can you send me the file. if it confidential, you can share it via message.

Regards
Balamurugan.S

[Neerugattu (Mallikarjuna)]

Hi,
I am doing screen scraping from SAP and I will get below kind of text for each scraping so my requirement is I have to remove first two lines and also the line which has only ‘*’ with out any string/text.

F … L.Row Text R …
… + … 1 … … + … + 2 + 3 … … … … 4 + 5 … … + … 6 … + … 7 …

• Hello,
• We received 25 items
• Supplier: Amazon
• Order: 12345678
• Position:
• Delivery note: XXXXXXX
• Reference: D9986865
• Quantity
• Quantity Received
• number
• We can not check the markings because
• some are returned.
• XXXXXXXXX.
• Edward on 19.01.2018

Could you please help me in this.
I have already tried with your code, it is removing first 1 line.

Thanks in advance.

[BCdev (Baptiste)]

Did you use the package of @balupad14 ?

It works in my side.

Regards.

[balupad14 (Balamurugan)]

Thank you @BCdev, Now you can get the package in UiPath Go ! It is published.

Hi @Neerugattu,

You can use the DeleteAt activity to remove the particular line.

Thank you
Balamurugan.S

[BCdev (Baptiste)]

Can you share the link @balupad14 ?

I want to share that with my team.

Regards.

[Neerugattu (Mallikarjuna)]

Hi @balupad14,

I have tried it but getting error: Illegal characters in path.

[Neerugattu (Mallikarjuna)]

Hi,
Thanks for your reply’s.
my requirement is solved with below code.
StringOP = VFreeText.Replace(“*”,“”).ToString.
StringOP = String.Join(Environment.Newline,StringOP.Split(Environment.Newline.ToArray()).AsEnumerable().Skip(1).ToArray().Skip(2).ToArray())

Output:
Hello,

We received 25 items

Supplier: Amazon

Order: 12345678

Position:

Delivery note: XXXXXXX

Reference: D9986865

Quantity

Quantity Received

number

We can not check the markings because

some are returned.

XXXXXXXXX.

Edward on 19.01.2018

[balupad14 (Balamurugan)]

Hi ,

UiPath Go ! BalaReva.EasyText (Text Format File Utilities Package)

Hi, I have developed a package to make easy the text file format utilities. It is a package to handle the automation for Txt,Csv,Xml ,Json and TextFormat File This package has many activities to handle the text format files like Txt,Csv,Xml ,Json and TextFormat File. The activities are to handle insert,update,delete and other operation. TextScope - It is a scope activity.It keeps only the file path. It doesn’t keep the text file resource. DeleteAt - Delete the line at specific line Find &…

UiPath Go Link

https://go.uipath.com/component/text-format-file-utility

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

hi @Neerugattu,
I will take a look and get back to you.

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi @Neerugattu,

I have tested it here the Delete at is working fine. Can you share the source file(the text format file) ?
If it is confidential share a sample …

Thank you
Balamurugan.S

[Neerugattu (Mallikarjuna)]

Hi,
As I told the data is from SAP screen scrapping and I can not share. I am scrapping data into a variable and passing variable to Text scope.

The text is already shared in above post but small correction is replace bullet(.) with ''. Probably this was auto converted( to bullet) when I copied from my system to this blog.

Thanks

[BCdev (Baptiste)]

Hi @Neerugattu,

Can you launch the robot with debug mode and see in variables panel the VFreeText Value and share with us ?

Regars.

[balupad14 (Balamurugan)]

Hi @Neerugattu,

Here I have attached screen shot along with sample project which you have shown in the picture.

Neerugattu.zip (18.1 KB)

Regards
Balamurugan.S