I have extracted these information
and would like to display them like these
You mean you want to store the extracted text to Excel ?
hi, yeap i want to change the text and store it to excel
Can you use Generate datatable activity and convert the string to a datatable. Then use Write range activity.
you can use generate data table activity, there you can convert string to table
not text to data table activity
You can refer the below video
I request you to please explain more on the requirement.
This will help us understand the requirement or problem better to provide a solution.
currently the workflow is able to extract the information as seen in the first picture, but i want to convert those text into ONE LINE and place a comma between each skill
Hi @audrxyx ,
Assuming you’re saving your text on an ExtractedText variable, depending on the text format one of these most likely will work for your purpose (use an assign activity):
NewText = ExtractedText.Replace(VbCrLf, ",") NewText = ExtractedText.Replace(VbCr, ",") NewText = ExtractedText.Replace(VbLf, ",")
hey! thanks for the suggestion. however, it’s not working for me
Could you please try the below,
Assuming you have your string in
Hope this helps.
Good that you pointed out, there’s a mistake on my previous response VbCrLf /VbCr/VbLf shouldn’t be enclosed within quotation marks, it should look like this
NewText = ExtractedText.Replace(VbCrLf, ",")