HI all,
How to get text from txt to excel?
Text in notepad is like this
Purchase Order
4I0002
P675NW01
Date : 18/10/2017
Invoice number : SG7J0136
I want cell A1=Purchase order A2=P675NW01 A3=Invoice number A4=SG7J0136
HI all,
How to get text from txt to excel?
Text in notepad is like this
Purchase Order
4I0002
P675NW01
Date : 18/10/2017
Invoice number : SG7J0136
I want cell A1=Purchase order A2=P675NW01 A3=Invoice number A4=SG7J0136
Hi,
I have attached a sample work flow for your situation.
File : uipath.zip (8.0 KB)
Thank you
Balamurugan.S
It works. Thank you Balupad!
Very nice.
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.