Example 2: Remove all Punctuation Marks - 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 Statment

SELECT * FROM TD_Ngramsplitter (
  ON text_data
  USING
  TextColumn ('text_data')
  Grams ('4-6')
  Punctuation('[[: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
9 Peshawar&&& - Home to 1,000+ bazaars & many historic landmarks!!! Peshawar peshawar home to 1 4 1 3
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the city of 5 4 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad a city with 20 4 1 6
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 its scenic beauty 50 4 1 7
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta the fruit garden of 4 1 8
9 Peshawar&&& - Home to 1,000+ bazaars & many historic landmarks!!! Peshawar 000 bazaars many historic 4 1 3
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi city of 5 million 4 1 6
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad 123 a city with 4 1 6
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 for its scenic beauty 4 1 7
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta for its scenic beauty 4 1 8
9 Peshawar&&& - Home to 1,000+ bazaars & many historic landmarks!!! Peshawar bazaars many historic landmarks 4 1 3
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi karachi the city of 4 1 6
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad 123 a city with 20 5 1 5
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 admired for its scenic 4 1 7
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta its scenic beauty and 4 1 8
9 Peshawar&&& - Home to 1,000+ bazaars & many historic landmarks!!! Peshawar 000 bazaars many historic landmarks 5 1 1
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the 5 million lights 4 1 6
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad with 20 greenery 80 4 1 6
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 quetta admired for its 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 karachi the city of 5 5 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad 20 greenery 80 modern 4 1 6
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 beauty 50 mountainous 50 4 1 7
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 the city of 5 million 5 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad city with 20 greenery 4 1 6
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 for its scenic beauty 50 5 1 6
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 city of 5 million lights 5 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad a city with 20 greenery 5 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 50 mountainous 50 landscapes 4 1 7
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 5 million lights countless 4 1 6
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad city with 20 greenery 80 5 1 5
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 scenic beauty 50 mountainous 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
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi the city of 5 million lights 6 1 4
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad a city with 20 greenery 80 6 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 admired for its scenic beauty 5 1 6
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 6 1 4
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad with 20 greenery 80 modern 5 1 5
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 quetta admired for its scenic 5 1 6
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 of 5 million lights countless 5 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad 123 a city with 20 greenery 6 1 4
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 scenic beauty 50 mountainous 50 5 1 6
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 million lights countless stars 4 1 6
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad city with 20 greenery 80 modern 6 1 4
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 admired for its scenic beauty 50 6 1 5
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
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi 5 million lights countless stars 5 1 5
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad greenery 80 modern architecture 4 1 6
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
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta its scenic beauty 50 mountainous 5 1 6
5 Quetta, the fruit garden of Pakistan, is admired for its scenic beauty and mountainous landscapes. Quetta beauty and mountainous landscapes 4 1 8
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi city of 5 million lights countless 6 1 4
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad 20 greenery 80 modern architecture 5 1 5
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
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta beauty 50 mountainous 50 landscapes 5 1 6
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
7 Karachi$$$ - The city of 5 million lights & countless stars!! #Vibrant Karachi of 5 million lights countless 6 1 4
6 Islamabad! 123 - A city with 20% greenery & 80% modern architecture!!! Islamabad with 20 greenery 80 modern architecture 6 1 4
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
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta its scenic beauty 50 mountainous 50 6 1 5
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 4 1 10
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
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta for its scenic beauty 50 mountainous 6 1 5
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 4 1 10
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta quetta admired for its scenic beauty 6 1 5
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 is known for its 4 1 10
10 Quetta*** - Admired for its scenic beauty (50%) & mountainous (50%) landscapes. Quetta scenic beauty 50 mountainous 50 landscapes 6 1 5
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 a city with a deep 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 with a deep cultural 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 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 for its ancient bazaars 4 1 10
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 its ancient bazaars and 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 a deep cultural heritage 4 1 10
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 is known for its ancient 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 city with a deep cultural 5 1 8
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 a city with a deep cultural 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 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 ancient bazaars and historic 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 known for its ancient bazaars 5 1 8
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 with a deep cultural heritage 5 1 8
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 bazaars and historic landmarks 4 1 10
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 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 and 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 5 1 8
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 known for its ancient bazaars and 6 1 6
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 city with a deep cultural heritage 6 1 6
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore its 300 years of 4 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
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore for its 300 years 4 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
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore known for its 300 4 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 landmarks 6 1 6
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore 300 years of history 4 1 6
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore for its 300 years of 5 1 4
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore lahore 202 heart of 4 1 6
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore 2020 heart of pakistan 4 1 6
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore known for its 300 years 5 1 4
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore its 300 years of history 5 1 4
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore known for its 300 years of 6 1 2
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore for its 300 years of history 6 1 2
8 Lahore@@@ - 2020: Heart of Pakistan, known for its 300+ years of history! Lahore lahore 2020 heart of pakistan 5 1 4
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