Start a new topic

Extract part of string

I wanted to extract a portion of the whole string using Regular Expression and use that as a GIft ID during import. But I am not sure what code should I use to extract the number from the following string for example.


Full string on the data file: CD324365T542514785___sds4545-54545-4scxd5

Portion of string I want to extract: The number between 'T' & '___', so in this case the extracted number will be 542514785. 

 

Can anyone help please.


Thanks,


Shak


Is your target string always between a T and an underscore? Or is it  a set position in the text string (i.e. characters 10 through 17?

Hi Barbara, It is always between 'T' & '_'

Can you please tell what RegEx code would extract that info from that string?

Thanks for helping me.

image


Thank you so much Barbara. It's working perfect! 


Shak

Login or Signup to post a comment