how to split space by space?

H

hernan

New Member
Hello everyone!

I'm trying to read all text from a *txt and then I have to split this to columns by space... I know there is the action of Import CSV but I have this one?

Could someone help me? I also think to read all lines but I couldn't

Thanks in advance!


1.jpg2.jpg
 
V

VJR

Well-Known Member
Hi hernan,

Splitting by space doesn't seem to be a suitable option because it appears at inconsistent places in each column.

At first I will suggest you try importing the text file manually into Excel. Check the below link and see by which of the options i] Delimiters (comma, space, tab,...) or ii] Fixed Width you are able to import that file successfully. Then try to do the same using Blue Prism by seeing if there are any options to do so directly or else by writing a code, etc. If you are able to successfully import the file manually then share your findings here and someone would be able to help you with any options in BP.

http://www.informit.com/articles/article.aspx?p=2027553&seqNum=5
 
You must log in or register to reply here.
Top