topic error in regex expression for filemask in Talend Studio

error in regex expression for filemask

Anonymous — Wed, 06 Mar 2019 09:08:02 GMT

Hi Team,

I am getting files from sftp location in the format "radar_data-summary_6438953.json".

I am given a regular expression in the filemask as "radar_data_summary_64" + "\\d{5}.json" but this is not working at all.

Could anyone please help me out in this.

I have attached my flow and component settings for tFTPGet_1 .

Re: error in regex expression for filemask

DataTeam1 — Wed, 06 Mar 2019 09:37:36 GMT

Try this:

radar_data-summary_64\d{5}\.json

Re: error in regex expression for filemask

Anonymous — Wed, 06 Mar 2019 09:42:28 GMT

Hi DataTeam,

I am given the same expression as you have told me its saying me this error.

I am given "radar_data-summary_64\d{5}\.json" in filemask.

error.JPG

Re: error in regex expression for filemask

akumar2301 — Wed, 06 Mar 2019 09:48:14 GMT

small error

radar_data-summary_6438953.json

"radar_data_summary_64"+ "\\d{5}.json"

this should work

"radar_data-summary_64"+ "\\d{5}.json"

Re: error in regex expression for filemask

Anonymous — Wed, 06 Mar 2019 09:53:23 GMT

Hi Abhishek,

Its not working can you please correct it.

I dont understand I have given as "radar_data_Summary_64+ "\\d{5}.json" ."s" of summary I make it as capital but it's still not working

Re: error in regex expression for filemask

akumar2301 — Wed, 06 Mar 2019 09:55:09 GMT

sorry you misunderstood , Try this It works for me

"radar_data-summary_64" + "\\d{5}.json"

Re: error in regex expression for filemask

Anonymous — Wed, 06 Mar 2019 10:02:52 GMT

Hi Abhishek,

I have given you the flow of mine and attached the screenshot for the same.

I am using tFTPFileList_1 and tFTPGET_1 components I am given the filemask in both the places which you have told me Please tell me did I am doing correctly If not please correct me?

error_1.JPG

Re: error in regex expression for filemask

akumar2301 — Wed, 06 Mar 2019 10:17:21 GMT

ideally you do not need File Mask in tFTPget if you are using tFtpList.

you could use ((String)globalMap.get("tFtpList_1_CURRENT_FILE")) as File Mask and

((String)globalMap.get("tFtpList_1_CURRENT_FILEDIRECTORY")) as Remote Directory

or Follow below link

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/kJcGMedMkLi95gzJlsX3YQ

Re: error in regex expression for filemask

DataTeam1 — Wed, 06 Mar 2019 10:20:26 GMT

As @uganesh wrote this is proper: "radar_data-summary_64\\d{5}.json"

I've checked it in tFileList

Re: error in regex expression for filemask

Anonymous — Wed, 06 Mar 2019 10:33:10 GMT

Hi DataTeam and Abhishek,

Now my flow is working completely fine.

Can anyone please tell me now I have 100 files few files are different now I gave this regex how can I see these files listed which component I have to use after tFTPGet component to see the filter files as with regex

I will be really thankful to you

Re: error in regex expression for filemask

DataTeam1 — Wed, 06 Mar 2019 10:57:09 GMT

Send printscreen of your job