Copiying column values from one sheet to another

[jai_kumar2 (jai kumar)]

Hi,

i am trying to populate column values from one excel sheet to another by comparing column
name which read from pdf

from pdf the bot will extract “Name of Person” using Regex
then using that variable the bot will search column name in sheet1 to match that variable value

if it match then the bot pull all data from that column and populate it on sheet 2

Here bot throwing some error like this

i this variable is not supporting in this method

Can someone help me

[Gokul_Jayakumar (Gokul Jai)]

@jai_kumar2 , try this .Trim at the end of variable. Space may affect the results

For example: NameOfCanditate.trim

[Gokul001 (Gokul Balaji)]

Hi @jai_kumar2

Copy from one sheet to another, checkout the below activity.

Activities - Copy Paste Range

Have a look on the video

How to Copy Specific Column data from One DataTable To Another in UiPath

Copying data from another column in one sheet

Hi friends! I’m new to uipath and can’t solve one problem. I need to filter a column by empty value and copy data from the adjacent column to fill in empty values, but then I should be able to remove the filter after filling in the data and get a column without empty rows. Please help me with this and sorry for my english For example from this: [image] to this: [image]

Regards
Gokul

[THIRU_NANI (NaNi)]

Hey!

Try like this…

1. Build data table - create the output columns like Name,Age,Work,Qualification - Output as DtOut

2. Use this Regex to pull out the name

Assign strName = System.Text.RegularExpressions.Regex.Match(StrInput,"(?<=Name:).*").ToString

Age:

Assign strAge = System.Text.RegularExpressions.Regex.Match(StrInput,"(?<=Age:).*").ToString

Work:

Assign strwork = System.Text.RegularExpressions.Regex.Match(StrInput,"(?<=Work:).*").ToString

Qualification:

Assign strQualification = System.Text.RegularExpressions.Regex.Match(StrInput,"(?<=Qualification:).*").ToString

Now use ADD DATA ROW activity and pass the ArrayOfRow like this

{strName,strAge,strWork,strQualification}

DataTable as DtOut

If you wants to write this to Excel use Write range ->Check Add Headers in the Properties panel-Data Table as DtOut

That’s it

Try this and let me know

Reards,
NaNi

[jai_kumar2 (jai kumar)]

Actually i removed space in variable value and in column by ("Replace " " to “”) replace space method still iam facing the error

[Gokul_Jayakumar (Gokul Jai)]

@jai_kumar2 Try .trim , Because I felt Space at string. Try this, It may Help

[jai_kumar2 (jai kumar)]

Thank you so much it worked

[Gokul_Jayakumar (Gokul Jai)]

@jai_kumar2 ,
Info: Try .trim maximum while using String. It will remove white space at Front and end of string, so you can get accurate value

Happy Automation

[jai_kumar2 (jai kumar)]

But in my case have to remove space in between words like “Name of Person” to “NameOfPerson”

[Gokul_Jayakumar (Gokul Jai)]

@jai_kumar2 Try this

System.Text.RegularExpressions.Regex.Replace(" Name Of Person “,” “,”").ToString.Trim

You can remove space at end as well as in between of Letter.