Example 1: Range A-Z and a-z - Analytics Database

Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-01
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™

Query Statement

SELECT * FROM TD_Ngramsplitter (
  ON text_data
  USING
  TextColumn ('text_data')
  Grams ('4-6')
  Punctuation('[^A-Za-z]')
  OutputTotalGramCount ('true')
) AS dt;

Output

id text_data city ngram n frequency totalcnt
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta is admired for its 4 1 8
9 Peshawar&&& - Home to 1,000+ bazaars & many historic landmarks!!! Peshawar bazaars many historic landmarks 4 1 5
7 Peshawar&&& - Home to 1,000+ bazaars & many historic landmarks!!! Karachi karachi the city of 4 1 3
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad a city with greenery 4 1 7
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore for its rich history 4 1 7
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta for its scenic beauty 4 1 5
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta the fruit garden of 4 1 8
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the city of million 4 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad city with greenery modern 4 1 3
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore its rich history and 4 1 7
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta admired for its scenic 4 1 5
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta for its scenic beauty 4 1 8
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi city of million lights 4 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad a city with greenery modern 5 1 2
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore is celebrated for its 4 1 7
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta quetta admired for its 4 1 5
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta its scenic beauty and 4 1 8
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the city of million lights 5 1 4
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad with greenery modern architecture 4 1 3
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore the heart of pakistan 4 1 7
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta admired for its scenic beauty 5 1 4
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta admired for its scenic 4 1 4
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi karachi the city of million 5 1 4
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad city with greenery modern architecture 5 1 2
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore celebrated for its rich 4 1 7
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta its scenic beauty mountainous 4 1 5
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta fruit garden of pakistan 4 1 8
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi of million lights countless 4 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad a city with greenery modern architecture 6 1 1
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore for its rich history 5 1 5
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta quetta admired for its scenic 5 1 4
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta for its scenic beauty and 5 1 6
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi million lights countless stars 4 1 5
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore is celebrated for its rich 5 1 5
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta for its scenic beauty mountainous 5 1 4
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta is admired for its scenic 5 1 6
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi city of million lights countless 5 1 4
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore rich history and beautiful 4 1 7
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta quetta admired for its scenic beauty 6 1 3
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta the fruit garden of pakistan 5 1 6
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi of million lights countless stars 5 1 4
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore history and beautiful gardens 4 1 7
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta scenic beauty mountainous landscapes 4 1 5
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta admired for its scenic beauty 5 1 6
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi karachi the city of million lights 6 1 3
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore its rich history and beautiful 5 1 5
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta its scenic beauty mountainous landscapes 5 1 4
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta scenic beauty and mountainous 4 1 8
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the city of million lights countless 6 1 3
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore celebrated for its rich history 5 1 5
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta admired for its scenic beauty mountainous 6 1 3
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta is admired for its scenic beauty 6 1 4
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi city of million lights countless stars 6 1 3
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore for its rich history and beautiful 6 1 4
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta for its scenic beauty mountainous landscapes 6 1 3
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta admired for its scenic beauty and 6 1 4
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar a city with a 4 1 10
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore is celebrated for its rich history 6 1 4
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta beauty and mountainous landscapes 4 1 8
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar city with a deep 4 1 10
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore rich history and beautiful gardens 5 1 5
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta its scenic beauty and mountainous 5 1 4
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar is known for its 4 1 10
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore celebrated for its rich history and 6 1 4
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta for its scenic beauty and mountainous 6 1 4
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar a city with a deep 5 1 8
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore its rich history and beautiful gardens 6 1 4
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta scenic beauty and mountainous landscapes 5 1 6
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar with a deep cultural 4 1 10
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta its scenic beauty and mountainous landscapes 6 1 4
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar known for its ancient 4 1 10
1 Islamabad is known for its modern architecture and lush greenery. Islamabad is known for its 4 1 7
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar for its ancient bazaars 4 1 10
1 Islamabad is known for its modern architecture and lush greenery. Islamabad known for its modern 4 1 7
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar its ancient bazaars and 4 1 10
1 Islamabad is known for its modern architecture and lush greenery. Islamabad islamabad is known for 4 1 7
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar a deep cultural heritage 4 1 10
1 Islamabad is known for its modern architecture and lush greenery. Islamabad is known for its modern 5 1 6
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar is known for its ancient 5 1 8
1 Islamabad is known for its modern architecture and lush greenery. Islamabad islamabad is known for its 5 1 6
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar city with a deep cultural 5 1 8
1 Islamabad is known for its modern architecture and lush greenery. Islamabad for its modern architecture 4 1 7
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar a city with a deep cultural 6 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad its modern architecture and 4 1 7
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar for its ancient bazaars and 5 1 8
1 Islamabad is known for its modern architecture and lush greenery. Islamabad modern architecture 4 1 7
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar ancient bazaars and historic 4 1 10
1 Islamabad is known for its modern architecture and lush greenery. Islamabad architecture and lush greenery 4 1 7
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar known for its ancient bazaars 5 1 8
1 Islamabad is known for its modern architecture and lush greenery. Islamabad for its modern architecture and 5 1 6
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar with a deep cultural heritage 5 1 8
1 Islamabad is known for its modern architecture and lush greenery. Islamabad its modern architecture and lush 5 1 6
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar bazaars and historic landmarks 4 1 10
1 Islamabad is known for its modern architecture and lush greenery. Islamabad islamabad is known for its modern 6 1 5
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar is known for its ancient bazaars 6 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad known for its modern architecture 5 1 6
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar its ancient bazaars and historic 5 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad for its modern architecture and lush 6 1 5
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar known for its ancient bazaars and 6 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad is known for its modern architecture 6 1 5
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar city with a deep cultural heritage 6 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad known for its modern architecture and 6 1 5
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar for its ancient bazaars and historic 6 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad modern architecture and lush greenery 5 1 6
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar ancient bazaars and historic landmarks 5 1 8
1 Islamabad is known for its modern architecture and lush greenery. Islamabad its modern architecture and lush greenery 6 1 5
4 Peshawar, a city with a deep cultural heritage, is known for its ancient bazaars and historic landmarks. Peshawar its ancient bazaars and historic landmarks 6 1 6
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore for its years of 4 1 4
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore known for its years 4 1 4
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore its years of history 4 1 4
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore known for its years of 5 1 2
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore for its years of history 5 1 2
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore lahore heart of pakistan 4 1 4
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore known for its years of history 6 1 1
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi is famous for its 4 1 6
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi the city of lights 4 1 7
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi famous for its vibrant 4 1 7
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi for its vibrant culture 4 1 7
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi its vibrant culture and 4 1 7
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi is famous for its vibrant 5 1 5
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi for its vibrant culture and 5 1 5
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi culture and bustling streets 4 1 7
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi vibrant culture and bustling 4 1 7
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi famous for its vibrant culture 5 1 5
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi its vibrant culture and bustling 5 1 5
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi is famous for its vibrant culture 6 1 4
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi famous for its vibrant culture and 6 1 4
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi for its vibrant culture and bustling 6 1 5
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi vibrant culture and bustling streets 5 1 5
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi its vibrant culture and bustling streets 6 1 4