Regex Based Extractor - Ticket Number

Hi Community,

I would like to ask how can extract data from the following line and the output as below using regex builder. I also have attached the text file for easier reference.
Sample 1 )
Tidcet# 1001050.75132

Sample 2 )
Ticket # 1000073-122

Sample 3 )
Tickets 1003560.3A6 13P6

Sample 4 )
Ticket

199282-38374

Sample 5 )
Ticket # 1000073.567

Output
1.1001050.75132
2.1000073-122
3.1003560.3A6
4.199282-38374
5.1000073.567

Ticket.txt (274 Bytes)

Many thanks again for the help

Hi @SH_94

it will be like this or its a spelling mistake?

Regards
Sudharsan

1 Like

If it is a spelling mistake Here is the expression try this

If not Take this expression

Regards
Sudharsan

2 Likes

Hi @Sudharsan_Ka ,

Many thanks for the prompt response.The original file was shown as ticket but when the come to data validation station, it show differently.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.