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.
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.
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.
Consultor 1: (persons name)
Entrevistado: (name)
Cargo: (job position)
Onda: (company)
Cliente: (client)
I would just need the name that comes after “Entrevistado”
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
and how do I use this for every cell in the excel table? Do I use for each row or for every item?
Thanks!
Once you’ve used Read Range and have the table from Excel in a DataTable, you will use the For Each Row activity.
and use the assign activity inside the for each row?
Absolutely, you got it!
it’s giving me an error:
Source: Assign
Message: Value cannot be null.
Parameter name: input
Assign this RegEx expression to a variable in assign activity.
I already did…
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.
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
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?
sí, aún tengo el mismo problema. Podrias mostrame como lo has hecho para verificar si lo estoy haciendo bien?