Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
AbdulHaseebKhan
Contributor II
Contributor II

eliminate first and last charaters

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.

Labels (1)
2 Solutions

Accepted Solutions
micheledenardi
Specialist II
Specialist II

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:

2022-09-30 19_33_29-Window.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

maxgro
MVP
MVP

maybe

 

Mid(Month, 2, Len(Month)-2)

 

View solution in original post

3 Replies
micheledenardi
Specialist II
Specialist II

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:

2022-09-30 19_33_29-Window.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
maxgro
MVP
MVP

maybe

 

Mid(Month, 2, Len(Month)-2)

 

AbdulHaseebKhan
Contributor II
Contributor II
Author

thank you all

thank you very much