Grabbing X number of characters from the end of a line
Posted: Fri May 02, 2014 2:03 pm
as the subject says, I'm looking to take the last 7 characters from each line of a field and put them into another field, so I will start with something like this:
ABSD-A234567
LKI:A654321
A987654
BUFA314151
and end up with:
A234567
A654321
A987654
A314151
so, the last 7 bits of info are the only relevant part I want to keep, and the rest of it can vary in size and may or may not have a delimiter
This was my most recent try which didn't work:
Any thoughts?
Thanks,
Greg
ABSD-A234567
LKI:A654321
A987654
BUFA314151
and end up with:
A234567
A654321
A987654
A314151
so, the last 7 bits of info are the only relevant part I want to keep, and the rest of it can vary in size and may or may not have a delimiter
This was my most recent try which didn't work:
Code: Select all
repeat for each line mmPin in field "input"
put last 7 char of mmPin & return after the field "output"
end repeat
Thanks,
Greg