Hi, i wanted to split all email id’s with user name in bracket as one and to write in excel in each row. i want “kumar,pravin - pravin.a.kumar@abc.com (pkuma144)” in one line and next to another ans so on. how can i split this string? here is the ss of text file. [ssg] please help me with the…

@Mathkar_kunal - This is my input. [image] Whatever you posted in the initial post, I took that string …So in your case, wherever you getting that whole string , pass that as a input. Also, You also have to fix the pattern. This is updated short one… [image] @Mathkar_kunal - This is just alte…

how can i write each item in each row of excel?

Create a new datatable. After you split the string into a string array and have it formatted the way you want, use a for each activity & change the typeArgument to string. Within that for each loop, use the ‘add data row’ to add the current string to the datatable you created. Use excel write range …

u have any demo to show? because i am stuck while splitting is i have to use regex and all and deserialize jason?

You need to use your inputs to determine the best way to manipulate the string. This is an extremely common thing to do in almost all workflows so I’d highly suggest trying on your own to figure it out. From the limited info we have based on the screenshot, it looks like you can use the closing pare…

Hi, I made changes as per u suggested but writing same name means first name only in loop [dsfsf] here is the script ss [gfgs]

@Mathkar_kunal - I know this very amateur Regex…but this may help you. [image] I am trying to build a good one , until you can give it a try… Output [image] RegEx Pattern: (\w+,\w+\s±\s\w+.\w+.\w+@\w+.\w+\s\W\w+\W+) Updated: [image]

@Mathkar_kunal - Here you go… [image] Output [image]

@Mathkar_kunal your screenshot is cutoff so we cant see what is in the for each loop? The part above looks fine, but the code within the for each loop needs to be changed so it isnt grabbing the same text each time EDIT: Although regex could work fine, that is going to be a huge pain to debug in th…

@Dave - Regex is easy…see below… [image]

How to spit string in notepad

Help

Mathkar_kunal (Mathkar, kunal) December 10, 2020, 5:28pm 13

what is the value u used as input in maches? as i a using regex for first time so dont know much about it.
i am getting those ids by get text first and then splitting and used that split variable in matches.

Topic		Replies	Views
Split a string excel Activities excel , activities , question	5	1053	April 9, 2021
How to split the long string into each word then copy/paste into each column in excel file when we use the regex pattern (Matches) Help	3	1516	March 25, 2019
Unable to split string using matches Help excel , uiautomation , studio , regex , string , question , it_automation_activities	41	2450	December 25, 2020
Convert DataTable row into Excel Cells Studio studio , question , activities_panel	20	492	September 1, 2023
How to spilt a string then fill in excel StudioX datatable , excel , studio , question	7	868	March 18, 2021

How to spit string in notepad

Related topics