Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
input:
january, february, march, april, may, june, july ........december.
I need the output as:
anuar, ebruar, arc, pril, a, un, ul,.........ecembe.
How to delete first and last characters in a string which contains 12 months by using string functions only.
Here the script
Load
MonthName,
mid(MonthName,2,len(MonthName)-2) as MonthNameCutted
Inline [
MonthName
January
February
March
April
May
June
July
August
September
October
November
December
];
and here the result:
Here the script
Load
MonthName,
mid(MonthName,2,len(MonthName)-2) as MonthNameCutted
Inline [
MonthName
January
February
March
April
May
June
July
August
September
October
November
December
];
and here the result:
maybe
Mid(Month, 2, Len(Month)-2)
thank you all
thank you very much