I have a text files which contains name, ph and Age of some persons . i have to read the text file and paste those details to the excel in the defined format. I’m facing issues in adding those details in the particular format. I will attach down the sample input and output . Kindly help me out.
You can check the below video to convert text to Datatable. Once you convert to datatable you can try transpose or datamanipulation from datatable to get the required data.
It doesn’t work in my case, Bcoz my input has values like Key and value.All names in the text file should be in the name column and same for the age as well.
(input format) → String
(output format) — Data table
I need output in this format , Kindly look in to this .
thanks in advance
can you try using generate datatable activity which converts string to Datatable
i Have tried it and the output is not as expected
Read Text File into a string variable.
Split on VbCrLf + VbCrLf (basically split on every blank line)
Now you have an array of the records. Then you can For Each through the array and split each one on VbCrLf. Using Add Data Row, your array(0) will be Name and array(1) will be Age. You can just use Replace to get rid of "Name " and "Age " each time.
Can you share any example input string format i will try my end once to help you better
Thanks and regards
i have attached the img kindly look into it .
It Sounds good , but can you share me xaml for better understanding .
Thanks in Advance
Thanks for your answer, i have resolved the issue using your idea .
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.