@Anonymous
Great work! Ok, so it looks like "RYDER" is the customer number you want, ya? Change your first expression to this (I bolded the new part):
split(triggerBody()?['subject'],'customer ')[1]
This will tell the split() that you are only interested in the second part of the original subject.
For the date/time bit, we can do the same thing:
split(triggerBody()?['body'],' on ')[1] - But that will still leave some things to trim off. Here's what I expect you'll get:
"06/15/20 20:42:11. The odometer reading was 164,851 miles at the time of arrival.", so we'll need to split this again at the period and take the first part this time. Here's what the whole expression might look like:
split(split(triggerBody()?['body'],' on ')[1],'. ')[0]
Same idea applies here, we are splitting the result of the first split at the period, and telling it we only want the first part this time.
Give those a try and let's see what happens.
Good luck!
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
