How to contain keywords in particular column and write that keyword in new column in same sheet

Learn Certification
, , , ,
1

Hi guys,

I need to contain in some keyword and write same keyword in new row ,

for ex.
Payment

i need contain keywords like success and fail in column AA and write in column CC

Please anyone help this

Regards,
Raja G

2

Hello, if i understood correctly - you want to check some keywords in Column and write those keywords in Another column or Another row.

Can you be more specific what you want to do.

3

1.Build a data table named “DT” with three columns AA, BB, CC. Values are string
2.Use Read Range and Read the “DT” datatable.
3.Use for each row row->DT
4.If row(“AA”).contains(“Success”) or row(“AA”).contains(“fail”)
Then
Use Write cell and write the value in row(“CC”)
Else
Use Write cell and write “NA” in row(“CC”)

1 Like
4

@sachinbhardwaj

yes i want first contain keywords and write same keyword in new column row and if doesn’t show keyword print NA

5

@praseedplk,

I couldn’t able apply if condition in for each, its doesn’t show contain option

6

WriteColumnAtoColumnC.zip (1.1 MB)

Hi,
Please find the attached workflow file for your solution.
Hope It helps. Please mark as solution if it works

Thank You… :slight_smile:

7

If row(“AA”).Tostring.contains(“Success”) or row(“AA”).Tostring.contains(“fail”)

8

Hi @Venugopal24 and @praseedplk,

Thank you so much working fine

1 Like
9

Hi @Raja.G

Below is the workflow for the same :-
MainRaja.xaml (8.6 KB)
New Microsoft Excel Worksheet.xlsx (8.4 KB)

Input :-
image

Output :-
image

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

10

Thanks for your reply.
Mark as solution for me if my workflow worked for you

Thanks… :slight_smile:

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.