Help - Trouble Selecting only certain information from an Excel cell

Help
,
1

Hello,

I need help to find out how I can extract, out of every cell in this table, only the interviewees name. I have tried using for each row, but it doesn’t seem to work.

image
image1366×768 84.6 KB

1 Like
2

Good morning Gabinlobo,

Please paste a copy of the full string in this post (replace any sensitive data) and specify which part of the string you want as your end result.

3

Consultor 1: (persons name)
Entrevistado: (name)
Cargo: (job position)
Onda: (company)
Cliente: (client)

I would just need the name that comes after “Entrevistado”

1 Like
4

Thank you Gabimlobo, you should able able to use the follow RegEx expression to extract your the name field:

(?<=Entrevistado: \()(.*)(?=\))

This will go in an assign stage as follow:

System.Text.RegularExpressions.Regex.Match(stringVariable, “(?<=Entrevistado: \()(.*)(?=\))”).Value

3 Likes
5

@chenderson Damn! Need to master this RegEx! :grimacing:

2 Likes
6

and how do I use this for every cell in the excel table? Do I use for each row or for every item?

Thanks!

7

@SaiKrishna147 Right!?

I’m still learning it too! Definitely a powerful tool for text manipulation.

8

@gabimlobo

Once you’ve used Read Range and have the table from Excel in a DataTable, you will use the For Each Row activity.

2 Likes
9

and use the assign activity inside the for each row?

10

Absolutely, you got it!

1 Like
11

it’s giving me an error:

Source: Assign

Message: Value cannot be null.
Parameter name: input

12

Assign this RegEx expression to a variable in assign activity.

2 Likes
13

I already did…

14

what I need to do is to extract the name in each cell and store all names somewhere so I can input them in a website afterwards.

15

what I need to do is to extract the name in each cell and store all names somewhere so I can input them in a website afterwards

16

Hola @gabimlobo,

Que tipo de variable estas usando?

17

Hola @carmen! Estoy utilizando un string para hacer el assign

18

Pense que quizas tenias ese error por el tipo de variable que usabas, entonces creo que podria ser que estas leyendo celdas sin valor o quizas no todas las celdas que estas leyendo tienen la misma estructura y por eso te arroja el error.

Yo estaba probando lo que te sugerian y me funciona bien.

aun tienes el problema?

19

sí, aún tengo el mismo problema. Podrias mostrame como lo has hecho para verificar si lo estoy haciendo bien?

20

justo estoy estudiando Regex ahora y le hice un cambio a lo que te decian pero funciona igual …

image
image1763×738 46.2 KB