Answered

how to separate text

(0) Share

Report

Posted on by ddelias

hello all

how to separate from Direccion to Contacto in this example of mail, I have managed to separate these fields because it coincides that this in the same line, but when the line changes I do not know how to do it.
can you help me ?

obtained the excel data in this way

GGATE : split(body('Filtrar_matriz')[1], 'C')[0]

CONTRATO : split(split(body('Filtrar_matriz')[1], 'Contrato')[1], 'Cliente')[0]

CLIENTE : split(split(body('Filtrar_matriz')[1], 'Cliente')[1], 'Dirección')[0]

"Fecha/Hora02/05/24 10:06:00Status llamadaANº IncidenciaEXPPL",
"98319Contrato21949-24ClienteINETUM - AENA",
"PMI - Aeropuerto Palma de MallorDirecciónPMI - Aeropuerto Palma de Mallor",
"07611",
"PALMA ContactoDaniel Perez Mendez / Telf. ",
"/ Telf. Motivo LlamadaD2DManager process state has changed: OK to Critical",
"(ObjectStore) PlataformaStorage/Stockage SNCZ3735N16F ProductoHP NAS SERVER",
"STOREONCE 4500 24TB / AGP02STO - STOREONCE 5500",
"Storage/Stockage / HEW / BB878A SLA7/7 jours, horaire étendu",
"GTI4.00GTR---------------------------------------------------------------------------------IntervenantBARCCódigo",
"REAGRRef. clienteRef. proveedorModificado porDDOMINGUEZ"

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ddelias

Could you tell what is expected data from email body (I hope that is email body u have shared)

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
ddelias 63 on at

Like
a
(0)

Report
Copy link

Link copied!

hello

What you are telling me seems to be the right thing to do, but it is for a fee and I want it for private use, can't it be done in any other way?

Was this reply helpful? Yes No
ddelias 63 on at

Like
a
(0)

Report
Copy link

Link copied!
I don't understand what you are asking me

here is another example of the email body

"Fecha/Hora03/05/24 10:54:00Status llamadaANº IncidenciaEXPPL",
"98339Contrato45032-31ClienteSEMIC, S.A - chemencegraphics",
"Dirección",
"",
"08970",
"SANT JOAN DESPI
"8-17. / Telf. Motivo LlamadaDISCO EN FALLO 01AC596 IBM 01AC596 - 2.5inch SAS 10K",
"900 GBPlataformaStorage/Stockage SN7816M877 ProductoIBM STORWIZE V5010 SFF",
"CONTROL 2078 124 / V5000 (2078-124) CON 4X1,",
"Storage/Stockage / IBM / 2078-124 SLAlundi au vendredi, horaire standard",
"GTI4.00GTR---------------------------------------------------------------------------------IntervenantBARCCódigo",
"REAGRRef. clienteRef. proveedorModificado por"
"",
""

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ddelias

What i am asking is - from the given email body- what values you are expecting for each fields which you have mentioned - like GGATE, CONTRATO etc ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
ddelias 63 on at

Like
a
(0)

Report
Copy link

Link copied!

hello

Sorry, I didn't understand,
all the emails have the same fields but in different lines,
I would like to separate the following:

from direccion to motivo as marked in bold type
y
from producto to /

"Fecha/Hora03/05/24 10:54:00Status llamadaANº IncidenciaEXPPL",
"98339Contrato45032-31ClienteSEMIC, S.A - chemencegraphics",
"Dirección",
"",
"08970",
"SANT JOAN DESPI Contacto ",
"epuig@chemencegraphics.com/",
"8-17. / Telf. Motivo LlamadaDISCO EN FALLO 01AC596 IBM 01AC596 - 2.5inch SAS 10K",
"900 GBPlataformaStorage/Stockage SN7816M877 ProductoIBM STORWIZE V5010 SFF",
"CONTROL 2078 124 / V5000 (2078-124) CON 4X1,",
"Storage/Stockage / IBM / 2078-124 SLAlundi au vendredi, horaire standard",
" GTI4.00GTR---------------------------------------------------------------------------------InterventorBARCCódigo",
"REAGRRef. clienteRef. proveedorModificado por"

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ddelias

I have stored email body given in question in compose action.

Now used below expression to get the highlighted data as you have shared

to get data from direccion to motivo

Use this

Expression -

slice(outputs('Compose'),indexOf(outputs('Compose'),'Dirección'),add(indexOf(outputs('Compose'),'Motivo'),6))

Now to get data from producto to / use this

Expression -

slice(substring(outputs('Compose'),indexOf(outputs('Compose'),'Producto')),0,add(nthIndexOf(substring(outputs('Compose'),indexOf(outputs('Compose'),'Producto')),'/',1),1))

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
ddelias 63 on at

Like
a
(0)

Report
Copy link

Link copied!

hi ,
have used this expression and it works almost perfectly, the only bad thing is that I get the word Dirección and Motivo in the output.
can it be solved ?

slice(outputs('Html_a_texto')?['body'],indexOf(outputs('Html_a_texto')?['body'],'Dirección'),add(indexOf(outputs('Html_a_texto')?['body'],'Motivo'),6))

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ddelias

Try like this

slice(outputs('Html_a_texto')?['body'],add(indexOf(outputs('Html_a_texto')?['body'],'Dirección'),9),indexOf(outputs('Html_a_texto')?['body'],'Motivo'))

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
ddelias 63 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you very much for your help, everything is working fine

Was this reply helpful? Yes No