Thanks Adrian, this worked perfectly.
------------------------------
Mike Spalding
manager
AbbVie Inc.
------------------------------
Original Message:
Sent: 01-17-2024 11:32
From: Adrian Williams
Subject: Strip characters from long string
You can use Python Slice String in a Transform node
https://www.w3schools.com/python/gloss_python_string_slice.asp
For example:
------------------------------
Adrian Williams
Precisely Software Inc.
Original Message:
Sent: 01-17-2024 10:57
From: Mike Spalding
Subject: Strip characters from long string
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!
------------------------------
Mike Spalding
manager
AbbVie Inc.
------------------------------