UiPath Replace Text (URGENT)

Help StudioX
1

I have extracted these information

image
image1920×1080 328 KB

and would like to display them like these
image

Help appreciated!

2

Hey @audrxyx

You mean you want to store the extracted text to Excel ?

Thanks
#nK

3

hi, yeap i want to change the text and store it to excel

4

Can you use Generate datatable activity and convert the string to a datatable. Then use Write range activity.

5

you can use generate data table activity, there you can convert string to table

6

Hey!

As @Rahul_Unnikrishnan and @Veera_Raj mentioned you can use Generate data table activity…

not text to data table activity

You can refer the below video

Regards,
NaNi

2 Likes
7

Hi @audrxyx

I request you to please explain more on the requirement.

This will help us understand the requirement or problem better to provide a solution.

Thanks
#nK

8

hi @Nithinkrishna,

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

so from
Theatre Management
Communication
Leadership

to
Theatre Management,Communication,Leadership

1 Like
9

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, ",")
1 Like
10

hey! thanks for the suggestion. however, it’s not working for me :frowning:

11

Hey @audrxyx

Could you please try the below,

Assuming you have your string in str_Text

String.Join(",",str_Text.Split(Environment.Newline.ToCharArray, StringSplitOptions.RemoveEmptyEntries))

Hope this helps.

Thanks
#nK

12

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, ",")