MQSeries.net :: View topic

prasad.gh789 · Posted: Thu Aug 28, 2014 10:04 am Post subject:

File name:

File Name : Pic100007_P012_L03_F0_XEX_D2000_03_10_T23_10_14_N00000024.jpg

There is file name pattern validation required for these Picture Files . Please find below the validation logic.

- Starts with 'Pic'
- Followed by 6 characters
- Followed by '_'
- Followed by 'P'
- Followed by 3 characters
- Followed by '_'
- Followed by 'L'
- Followed by 2 characters
- Followed by '_'
- Followed by 2 characters
- Followed by '_'
- Followed by 3 characters
- Followed by '_'
- Followed by 'D'
- Followed by 4 digits
- Followed by '_'
- Followed by 2 digits
- Followed by '_'
- Followed by 2 digits
- Followed by '_'
- Followed by 'T'
- Followed by 2 digits
- Followed by '_'
- Followed by 2 digits
- Followed by '_'
- Followed by 2 digits
- Followed by '_'
- Followed by 'N'
- Followed by 8 digits
- Followed by '.'
- Followed by 'jpeg'

let me know esql for this validation?

Example:DECLARE file_name = SUBSTRING(LocalEnvironment.File.Name BEFORE '.');
IF LENGTH(file_name)='19' THEN
DECLARE tollstation_table = SUBSTRING(file_name FROM 1 FOR 3 );
IF tollstation_table ='TST' THEN
DECLARE identifier = CAST(SUBSTRING(file_name FROM 4 FOR 6) AS INTEGER );
i know simple validation like this but above file contains some fixed char's like pic,_p,_L,_D(alphabets) , character values(varies file to file) and digits(0 to 9).