Hi, Please see image full of unstructured data. This is just a test lot of data because the real data is scrapped using a get-text activity from an on in-house web app but the data structure is the same as you see there. My question how do I structure it, add columns above particular data and output…

Ok, for you to have a general idea how to process the file: Main.xaml (5.4 KB)

I think you will want to study the Split function for this :slight_smile:

Oh wow thank you. For clarity of the activities i should be using in UIPath. I have: Get-text Generate data table Output data table Does that sound right so far?

If i where you, i would start by experimenting with one line of text in a string variable first… Like Split it on “=>” take the TEXT.Split(1) part and then Split that on “Submit” and then take the TEXT2.Split(0) part, test if will work to Split that using TAB char until you have an array with what w…

[image] rohangroombridge: Get-text Generate data table Output data table @rohangroombridge If you are directly reading values from web application then use Get Text activity and if you’re reading it from notepad file then use Read Text File activity.

Hi, i have checked out the split function but am finding it difficult. I need to filter all strings / words only from the text file output variable and replace the whitespace with | delimeter

Is there a way to loop the the text in the .txt file and store all values in an array of string and then i read from that?

Yes, Read Text File activity serves this purpose, so you have to read all lines from a text file and generate a datatable from it right? If you upload one of this files here and tell me what columns you need, i will do it for you :slight_smile:

testoutput.zip (441 Bytes) thank you. Please see attached

That text file do not look like it has anything like you posted before…

How do i structure/filter unstructured data?

Help

rohangroombridge (Rohan Groombridge) October 10, 2019, 8:59pm 11

no the consept im try to prove is how to hnadle the unstructured dat. You can see both examples are unstructured. Would they be completely different to handle?

Topic		Replies	Views
Create Datatable from unstructured text file Help	1	2504	August 4, 2018
How to enter column values from text to data table Help datatable , activities , studio	4	1632	December 11, 2018
Usntructured Data to Datatable Activities excel , activities , question	2	352	July 28, 2023
Convert the text file into the data table Studio studio , question , tools	4	623	August 17, 2023
Read unstructured txt file to datatable Help	2	1460	April 5, 2019

How do i structure/filter unstructured data?

Related topics