MQSeries.net :: View topic - File validation against File_NAME pattern

prasad.gh789 · Posted: Tue Sep 09, 2014 4:31 am Post subject:

INPUT FILE NAME:- Pic100007_P012_L03_F0_XEX_D2000_03_10_T23_10_14_N00000024.jpg

Here we validate the position of '_' like this. please find below code

DECLARE RSGfile_name CHARACTER InputLocalEnvironment.File.Name ;

IF POSITION('_' IN RSGfile_name)=10 AND POSITION('_' IN RSGfile_name REPEAT 2)=15 AND POSITION('_' IN RSGfile_name REPEAT 3)=19 AND POSITION('_' IN RSGfile_name REPEAT 4)=22 AND
POSITION('_' IN RSGfile_name REPEAT 5)=26 AND POSITION('_' IN RSGfile_name REPEAT 6)=32 AND POSITION('_' IN RSGfile_name REPEAT 7)=35 AND POSITION('_' IN RSGfile_name REPEAT

=38
AND POSITION('_' IN RSGfile_name REPEAT 9)=42 AND POSITION('_' IN RSGfile_name REPEAT 10)=45 AND POSITION('_' IN RSGfile_name REPEAT 11)=48THEN

but it looks very lengthy let me know any simple way to validate this using like concatenation or any other techniques

pls provide me ESQL for this logic