How can i extract only string from column A and write to columnB?

[Aparna_30 (Aparna Popade)]

ComparisionReport_TR_COSUM_0201055167CX01.xlsx (11.9 KB)
eg-Opportunity ID: 0201055167CX UNITS: 01
output-OpportunityIDCXUNITS

[Anil_G (Anil Gorthi)]

@Aparna_30

Follow the steps

1. Read the data into a datatable dt
2. Use for each row in datatable activity
3. Inside the loop use currentrow(1) = System.Text.RegularExpressions.Regex.Replace(currentRow(0).ToString,"[^A-Za-z]","")
4. After loop use write range and write the data

Note : if second column is not already present then after step 1 use a add data column to add one more column

Cheers

[Vikas_M]

@Aparna_30

Opportunity ID: 0201055167CX UNITS: 01

Hey @Aparna_30 ,
You can use Regex to satify your use case

For example
input str: Opportunity ID: 0201055167CX UNITS: 01
regex pattern: [A-za-z]+
Output:

Hope it helps you!

[Quenton_Wayne_Rebello]

Hey @Aparna_30, you can use regex → [A-Za-z]+ or [A-Za-z]*

The below XAML will give a demo of the work,
Main.xaml (9.7 KB)

[rlgandu]

@Aparna_30

Read range activity
For Each Loop
MyString=CurrentRow(“Test”).ToString
ReplaceSemicolon=MyString.Replace(“:”,“”)
ReplaceSpace=ReplaceSemicolon.Replace(" “,”")
outputString = System.Text.RegularExpressions.Regex.Replace(ReplaceSpace, “\d”, “”)

I hope This will help You

[mkankatala (Mahesh Kankatala)]

Hi @Aparna_30

=> First use the use excel file activity inside it use the insert column activity to insert the column
=> Use read cell value activity to read the cell in the excel file.
=> Use finding match patterns activity to extract the output from cell value.
=> Use for each to iterate the matches output and concatenate to a variable.
=> Use the Write cell activity to write the output value in to the column B

For regex expression find the below image

Find the below workflow for your reference
Browser_Practice.xaml (15.2 KB)

Check the output below

Note - Change the path in the Use excel file activity.

Hope it helps!!