Text to excel

excel

#1

HI all,
How to get text from txt to excel?
Text in notepad is like this :slight_smile:

Purchase Order
4I0002
P675NW01
Date : 18/10/2017
Invoice number : SG7J0136

I want cell A1=Purchase order A2=P675NW01 A3=Invoice number A4=SG7J0136


Extract date text to excel
Import Microsoft.Office.Interop.Excel does not work
#2

Hi,
I have attached a sample work flow for your situation.

File : uipath.zip (8.0 KB)

Thank you
Balamurugan.S


#3

It works. Thank you Balupad! :slight_smile:


#4

Very nice.


#5

Hi balupad,

I am also stuck in a some what similar situation, can you please suggest:-
Scenario is:-

I have data in notepad which is following a specific pattern that is for eg:-

INDIAN CRICKET TEAM
LIST
PLAYERS
1 DHONI/MS CSK 7 CAPTAIN
INDIA
2 SHARMA/ROHIT MI 23 CAPTAIN
INDIA
3 KOHLI/VIRAT RCB 14 CAPTAIN
INDIA
and so on…

I want to enter these data into excel as follows:-
Column1 Column2 Column3 Column 4 Column5 Column6
1 DHONI/MS CSK 7 CHENNAI INDIA
2 SHARMA/ROHIT MI 23 MUMBAI INDIA
3 KOHLI/VIRAT RCB 14 BENGALURU INDIA

I dont know how can i ignore first 3 lines, and how to get the data of column 6 as it is in the next line.

Thanks in advance.