Data360 Analyze

Hello,

I'm struggling finding this solution but it seems it should be pretty easy.  I have a field (ExpenseID), which has a 45 character ID in it.  I want to keep the first 15 characters and remove the remaining 30.

ExpenseID
202312044989727202312044991783202312048590793

I'm looking for the first 15 characters. 

ExpenseID
202312044989727

Thanks!

You can use Python Slice String in a Transform node

https://www.w3schools.com/python/gloss_python_string_slice.asp

For example:

Thanks Adrian,  this worked perfectly.