Regular Expression for reading characters only

Hello community members,

Here I want to read Characters only using a regular expression :

QADI : 5646 Name : 1: NTABO NTABERI 2: SHEKA 3: na 4: na
QADI : 5556 Name : 1: JAMAL 2: HUSSEIN 3: HASSAN 4: ZEINIYE
QADI : 2226 Name : 1: JAMAL 2: HUSSEIN 3: HASSAN 4: ZEINIYE

Output :
JAMAL HUSSEIN HASSAN
NTABO NTABERI SHEKa na na

Thanks in advance!

Best Regards,
Vrushali

So you don’t want “QADI” and “Name”, only the words that follow 1:, 2:, 3: and 4: ?

-Jeppe

@Vrushali_Gave

Check as below

use Replace activity and pass the regex as above

Hope this helps you

Thanks

1 Like

@ksrinu070184 @jjes

This is my regular expression to read data from a pdf :

Input : QADI : 5646 Name : 1: NTABO NTABERI 2: SHEKA 3: na 4: na

((?<=[A-Z,a-z]D[a-z,A-Z].([0-9].) (Name: )).)()

Output : 1: NTABO NTABERI 2: SHEKA 3: na 4: na

But I need only NTABO NTABERI SHEKA na na this data from this line QADI : 5646 Name : 1: NTABO NTABERI 2: SHEKA 3: na 4: na

Best Regards,
Vrushali

@Vrushali_Gave

after you output

Write your expression as replace

[1:2:3:4:]+, “”

This will remove and give you required output

Thanks

@ksrinu070184 But I need single expression which can read that names

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