topic Replace All only for year before colon in Talend Studio

Replace All only for year before colon

Anonymous — Wed, 22 May 2019 16:14:52 GMT

Hi,
Below is my Input

Id,name,charac
1,fff, "a2018":"23"
2,hhdh,"a":"2019"
3,agdhs,"a":"2018"
4,hrjje, "a":"2019", "a2018": "atra"
5,jdjeh, "a2018": 2018-12, "b":2019

Need to replace any year with blank (no space) only before colon ( in the column charac. Ni change of other columns. Charac data type is jason.

I have tried with replace all which is replacing all years after colon ( also

My output should be as below:
Id,name,charac
1,fff, "a":"23"
2,hhdh,"a":"2019"
3,agdhs,"a":"2018"
4,hrjje, "a":"2019", "a": "atra"
5,jdjeh, "a": 2018-12, "b":2019

Please help me

Thanks,
Ram

Re: Replace All only for year before colon

Anonymous — Wed, 22 May 2019 21:15:58 GMT

Hi,

I hope below solution will help you.

row1.line.replaceAll("[0-9][0-9][0-9][0-9]\":","\":")

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: Replace All only for year before colon

Anonymous — Thu, 23 May 2019 18:43:01 GMT

@nani22633

Were you able to resolve your issue with the help of above post? If yes, could you please mark the topic as resolved?

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 🙂