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 it all to an excel file?
I can safely say that the unstructured data is consistent.
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 will be your columns values.
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
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
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?
i need to know how to putt certain value from particular rows in the .txt files and particular positions in the .txt file, arrange the values to outputed to certian columns in an .xlsx file. The hard part is the data could change but the space they take in the file is the same everytime