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
Can't extract specific string from excel cell
#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