Example 3: Remove all Punctuation Marks and Reset at Punctuation - 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('[[:punct:]]')
  Reset('[[:punct:]]')
  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
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the city of 5 4 1 3
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad a city with 20 4 1 1
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 2
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 city of 5 million 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 2
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 of 5 million lights 4 1 3
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore is celebrated for its 4 1 3
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta admired for its scenic beauty 5 1 1
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 5 million 5 1 2
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore the heart of pakistan 4 1 7
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta admired for its scenic 4 1 8
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi city of 5 million lights 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
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the city of 5 million lights 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
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
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 5 1 5
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
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 4 1 7
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
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 history and beautiful gardens 4 1 7
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
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 5 1 5
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta scenic beauty and mountainous 4 1 8
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
3 Lahore, the heart of Pakistan, is celebrated for its rich history and beautiful gardens. Lahore celebrated for its rich history 5 1 5
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
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
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
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 for its ancient bazaars 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 its ancient bazaars and 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 6
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
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 is known for its ancient 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 city with a deep cultural 5 1 8
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 a city with a deep cultural 6 1 6
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 and 5 1 8
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 ancient bazaars and historic 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 known for its ancient bazaars 5 1 8
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 with a deep cultural heritage 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 bazaars and historic landmarks 4 1 10
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 is know for its ancient bazaars 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 its ancient bazaars and historic 5 1 8
1 Islamabad is known for its modern architecture and lush greenery. Islamabad modern architecture and lush 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 and 6 1 6
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 city with a deep cultural heritage 6 1 6
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 for its ancient bazaars and historic 6 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad 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 ancient bazaars and historic landmarks 5 1 8
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 its ancient bazaars and historic landmarks 6 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad known for its modern architecture 5 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad for its modern architecture and lush 6 1 5
1 Islamabad is known for its modern architecture and lush greenery. Islamabad is known for its modern architecture 6 1 5
1 Islamabad is known for its modern architecture and lush greenery. Islamabad known for its modern architecture and 6 1 5
1 Islamabad is known for its modern architecture and lush greenery. Islamabad modern architecture and lush greenery 5 1 6
1 Islamabad is known for its modern architecture and lush greenery. Islamabad its modern architecture and lush greenery 6 1 5
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore known for its 300 4 1 1
2 Karachi, the city of lights, is famous for its vibrant culture and bustling streets. Karachi is famous for its 4 1 7
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 4
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