Excel extract specific set of words from a Column

[Apple1]

Hi,

I have csv file with column of name and surname written in different maner. The picture is attached:

Which activities should I use to leave only Name and Surname like this: NameSurname, without spaces?
Should I use Regular expressions? If so, what is experession?

[ImPratham45 (Prathamesh Patil)]

Use regex for only words.

Regex for keeping only word characters before any other character

Hey, I need the regex to keep only first word characters. For example “text-yes” → “test” , or “test_yes” → “test”. Thanks!

[Apple1]

I saw that post, it is not clear. Any other ideas?

[Rohit.Garg]

@Apple1

I think Regex for keeping only word characters before any other character is not what you are looking for

You can try using sub string and replace space. Refer below sample and attached file too.

row(0).ToString.Replace(" “,”").Substring(0,v_strlen-4)Main.xaml (6.4 KB) .

Hope this helps…

[Apple1]

I used: System.Text.RegularExpressions.Regex.Match(row(0).ToString,”^[1]*”).ToString.Trim
but only “” (nothing) got in result

---

1. a-zA-Z ↩︎

[tranthao240495 (Thao Tran)]

Hi, if you wanna remove all spaces, try For each row & Assign like this.
Let me know if it works for you

[Pratik_Wavhal]

Hi @Apple1

Below is the working String Manipulation for the same along with regex :-

Regex.Replace(row(0).ToString.Trim,"\s+"," ").Split(" "c)(0)+Regex.Replace(row(0).ToString.Trim,"\s+"," ").Split(" "c)(1)

Below is the workflow for the same :-
MainPratik.xaml (9.7 KB)
Apple.xlsx (8.3 KB)

Output :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[Apple1]

Hi @Pratik_Wavhal,

Thanl you for your responce, your suggestion worked for me.
Now I need all new rows from variable to be added to new excel table. I attached picture of process I created. In the resulst I get excel file that contains only 1 row, meaning that each new row from variable containing regular experession just overwrited in first row of excel file. How can I keep all rows in my new excel file?

[Apple1]

@Pratik_Wavhal
Picture of process

[Apple1]

Hi @tranthao240495,

Thank you for your responce. Solution of @Pratik_Wavhal worked for me.