Hi, can i know how to pick some data in txt to xlsx? please give example and what activities should i use after read both of it.
example:
(in txt) my name is ahmad
(in xlsx) Name: <“name”>
output:
(in xlsx) Name: ahmad
Hi, can i know how to pick some data in txt to xlsx? please give example and what activities should i use after read both of it.
example:
(in txt) my name is ahmad
(in xlsx) Name: <“name”>
output:
(in xlsx) Name: ahmad
https://activities.uipath.com/docs/read-text-file
Pass the required inputs for this activity. Sheet Name, Range and the value (string variable read from the step 1)
Regards,
Karthik Byggari
for the last step, i only need certain data(in txt) to overwrite/exchange with the data in xlsx
example:
(in txt) my name is ahmad
(in xlsx) Name: <“name”>
output:
(same xlsx) Name: ahmad
so, the string mynameisahmad… but i only want that “ahmad”
do i need to use invoke code?
No. You don’t need to use that
After reading the file, extract only the name from the string.
For example, myName = “my name is ahmad”
Split the string by space and take the last array item.
Regards,
Karthik Byggari
hi sir, can u explain more about split the string or give some illustration? sorry im really new with RPA
you may do it simply:
Name = myName.Split(chr(32)).ToList()(3)