Extract Information

[carlos_carreno]

Good morning, I need your support with this DPL/DQL text extraction. I need to parse it

Samples

/productos/creditos/en-linea

/productos/creditos/libranza

/productos/cdts

/productos/cuentas-de-ahorro/abrir-cuenta-de-ahorros/abrir-cuenta-de-ahorros-en-linea-flexidigital

Result

FILED1	FIEDL2	FILED3	FILED4
productos	creditos	en-linea	NULL
productos	creditos	libranza	NULL
productos	cdts	NULL	NULL
productos	cuentas-de-ahorro	abrir-cuenta-de-ahorros	abrir-cuenta-de-ahorros-en-linea-flexidigital

I need to extract the information that is within "/" and organize it into new columns. If a field is missing, it should display null. It is very dynamic.

|parse Request_Path,

[carlos_carreno · Accepted solution]

This is the answer:| parse `Request_Path`, "DATA [a-zA-Z.-]+:Area"
| parse `Request_Path`, "DATA '/'[ a-zA-Z.-]+:Tipo_de_Producto"
| parse `Request_Path`, "DATA '/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+:Solucion_Financiera"
| parse `Request_Path`, "DATA '/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+:Producto_Especializado"
| parse `Request_Path`, "DATA '/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+:Subproducto1 "
| parse `Request_Path`, "DATA '/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+'/'[ a-zA-Z.-]+:Subproducto2"