topic Re: regex not working in tExtractRegexFields in Talend Studio

regex not working in tExtractRegexFields

synfield — Fri, 15 Mar 2019 03:16:00 GMT

I want to extract the Picklist 'title' from the following url format

https://someapi.com:443/odata/v2/Picklist('ContractType')/picklistOptions

I've tried using the following which all work in regex online tests

"[^\\/\']+(?=\'[^\']+$)"

to extract 'ContractType' from the above url.

But this doesn't work in the component.

Re: regex not working in tExtractRegexFields

Anonymous — Fri, 15 Mar 2019 11:32:02 GMT

Hi,

Could you please provide some sample input records so that I will get more idea about it?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: regex not working in tExtractRegexFields

akumar2301 — Fri, 15 Mar 2019 13:41:43 GMT

try this

"Picklist\$(.*?)\$"

Re: regex not working in tExtractRegexFields

synfield — Sun, 17 Mar 2019 21:15:49 GMT

Thanks for this Abhishek, but this doesn't work either, the component just sends the row output without regex processing, to tLogRow

| #1. tLogRow_1 |

+-----+--------------------------------------------------------------------------------------+

| key | value |

+-----+--------------------------------------------------------------------------------------+

| uri | https://someapi.com:443/odata/v2/Picklist('ContractType')/picklistOptions |

+-----+--------------------------------------------------------------------------------------+

.------------------------------------------------------------------------------------------------.

| #2. tLogRow_1 |

+-----+------------------------------------------------------------------------------------------+

| key | value |

+-----+------------------------------------------------------------------------------------------+

| uri | https://someapi.com:443/odata/v2/Picklist('ftecontracthours')/picklistOptions |

+-----+------------------------------------------------------------------------------------------+

.----------------------------------------------------------------------------------------------------.

| #3. tLogRow_1 |

+-----+----------------------------------------------------------------------------------------------+

| key | value |

+-----+----------------------------------------------------------------------------------------------+

| uri | https://someapi.com:443/odata/v2/Picklist('GlobalAssignmentType')/picklistOptions |

+-----+----------------------------------------------------------------------------------------------+

.--------------------------------------------------------------------------------------------.

| #4. tLogRow_1 |

+-----+--------------------------------------------------------------------------------------+

| key | value |

+-----+--------------------------------------------------------------------------------------+

| uri | https://someapi.com:443/odata/v2/Picklist('ToolsofTrade')/picklistOptions |

+-----+--------------------------------------------------------------------------------------+

Cheers.

Re: regex not working in tExtractRegexFields

synfield — Sun, 17 Mar 2019 21:49:36 GMT

I tried tExtractRegexFields and tJavaRow using java.util.regex.Pattern etc..

None of the components worked, however, tMap expression did i.e.

regexUtilitiesCompleted.regexData("[^\\/\']+(?=\'[^\']+$)",row1.uri)

Not sure why the other components aren't working properly for regex, I'm running Talend v6.1 Date Services.

But tMap expression utilities works as it should!