topic Re: Searching a string and extract values in Talend Studio

Searching a string and extract values

Anonymous — Mon, 16 Apr 2018 20:00:46 GMT

HI,

I have a use case where I have to search for a string "INC TYPE" and extract the values after the particular string.The string can be anywhere in the description. Please find example

complete desc:

Simulation INC TYPE 566-A8970

ABN Cor INC TYPE 768-B5679

INC TYPE 897-B6789

Operations building INC TYPE 225-T5679 Legal

My expected output:

566-A8970

768-B5679

897-B6789

225-T5679

Please suggest. Thanks for your help!

Re: Searching a string and extract values

Anonymous — Tue, 17 Apr 2018 21:43:30 GMT

Have you tried using tExtractRegexFields?

Re: Searching a string and extract values

vboppudi — Tue, 17 Apr 2018 23:27:47 GMT

Are you looking for below output?

Regards,

Re: Searching a string and extract values

Anonymous — Tue, 17 Apr 2018 23:43:05 GMT

Thanks Veera!
Yes that was my expected output.

Re: Searching a string and extract values

Anonymous — Tue, 17 Apr 2018 23:44:00 GMT

Hi, I shall try and update you. Thanks for your response!

Re: Searching a string and extract values

cterenzi — Wed, 18 Apr 2018 14:56:00 GMT

Should you wish to use tExtractRegexFields, this pattern should yield the result you're looking for:

"INC TYPE (\\d{3}-[A-Z0-9]{5})"

Re: Searching a string and extract values

Anonymous — Sat, 21 Apr 2018 15:04:20 GMT

Thank you all. It is resolved now.

Re: Searching a string and extract values

abhi90 — Sat, 21 Apr 2018 15:28:04 GMT

Please mark the post as resolved so that others can use