Try using a "u" instead... looks like there might be a Java Bug.

${CurrentDate('u')}

That should give you what you're looking for

Kevin,

The option "E" allows you to get the "Day of the Week" (Sun, Mon, Tue, Wed, etc) which could give you the xref into 1,2,3,4.

Will that work?

Then apply the "String" function:

${Substring( string(CurrentFile), 27,20)}

And it should work for SMS messages the same way.

Just read the numbers from a Text File (DB, Excel, etc)
Loop through your rowset
send SMS message per record -- (Make sure it's configured under Global Settings and tested)

That's it.

No... it does not return values in that instance.

The first option is your only "wildcard" option. You can do the other utilizing "RegEx".

I don't believe it is ...

Please check your End of Record Markers .. .and make sure you're utilizing the correct one. Sometimes people have it setup for CRLF when there's only a CR, or vice-versa.

Set Variable Task ... not a Read Task.

Then use an if condition to see if the variable "contains" the value you are seeking.

If these are relatively small files .. then, do a loop through your files, set the file contents to a variable "FileContents", then use the "Contains" function see if "FileContents" has the value you're looking for. Condition based on results...

Read the spreadsheet (Rowset)
Loop through the Rowset and retrieve the customer number
Copy (Create file list) based on Customer number (Filter = *CustomerNo*)