Jump to content


Photo

Regex/Talend delete everything before (and including a character)


  • Please log in to reply
1 reply to this topic

#1 garynobles

garynobles
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 28 September 2017 - 09:38 AM

I'm using Talend for data migration, it allows for Regex, I'm, new to Regex, but I'm learning, I have data like so:

 

QA01_Q1254

RT04_123ht12

...

 

I want to get 

Q1254

123ht12

...

 

and then how would you do the opposite

QA01

RT04

...

 

I've been trying various syntax deviations, but not getting the right data out. Any help much appreciated.



#2 requinix

requinix
  • Administrators
  • Lazy Administrator
  • 9,240 posts
  • LocationWA

Posted 28 September 2017 - 09:48 AM

What have you tried so far?
The Reimann Zeta Function Trolley Problem | "Summer is when I, the great ice fairy, can show my true power!"




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users