Concatenate String in a variable

[#1]

Hello,

There is my problem:

i just wanna create a string with all the month name (like"JanuFebrMarcApri...")

How can i do this?

This is what i tried:

for mois=01 to 12

   let TestVar = $(TestVar)&$(=left(MonthName('0000-'&num($(mois), 00)&'-01'),4));

next mois

I get a Syntax Error and I don't know where i'm doing a mistake.

Thanks,

Regards,

Loïc

[tresesco]

Try like(Front end):

=Concat(Distinct(Month(MakeDate(1,mois,1)) )

[MK_QSL]

Load Replace('$(MonthNames)',';','') as Months AutoGenerate 1;

[#4]

Hello,

The value of my variable TestVar is always <NULL> with:

for mois=01 to 12

   let TestVar = Concat(Distinct(Month(MakeDate(1,mois,1)) ));

next mois

[MK_QSL]

Use my method without any loop or for loop

[#6]

Thanks but i want to get all the passed months of the current year in the string.

Your way to do this works but i get all the months.

For example, today the string would be 'JanvFévMarsAvrilMaiJuinJuil'

[MK_QSL · Accepted solution]

Temp:

Load

  RowNo() as NO,

  SubField('$(MonthNames)',';',(Month(YearStart(Today())) + IterNo() - 1)) as MinMonth

AutoGenerate 1

While Month(YearStart(Today())) + IterNo() - 1 <= Month(Today());

Load Concat(MinMonth,',',NO) as AllMonths Resident Temp;

[MarcoWedel]

Hi Loïc,

maybe also helpful:

using this expression:

=PurgeChar(If(Month(Today())<12,Left(MonthNames,Index(MonthNames, ';', Month(Today()))-1),MonthNames),';')

for month names like

regards

Marco