Solved Text Expressions EndsWith help

[boulay]

Hopefully easy question
I have a collection of Document Numbers.
I am looping through saving files for each document number, and i want to name the files to be from my loop value+".xls"
My loop/field value is [SAP JE LIST.DocumentNo], but i cant seem to add ".xls" to the end of that name.

 

[sivagelli]

Try [SAP JE LIST.DocumentNo]&".xls"

 

[El Guapo Sabelotodo]

Its a best practice to use the 'Validate' and 'Evaluate Expression' in the Expression Chooser box. It will tell in case of error.
In case of newly trying something, use Functions section in Expression Chooser box at bottom left.
For the current one, use Concatenate (&) under Text function.

 

[boulay]

sivagelli thanks for your answer. that worked