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.

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

Shak