Extract Information

carlos_carreno — Thu, 01 Aug 2024 16:10:08 GMT

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,

Re: Extract Information

carlos_carreno — Mon, 05 Aug 2024 19:01:24 GMT

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"

topic Extract Information in DQL

Extract Information

Re: Extract Information