Hi,
I have imported an Excel spreadsheet into FME, one of the columns contains data similar to the below, I am looking to filter the records between the PTO On and PTO Off values, anything else I wish to remove.
Is there a way to do this using FME transformers? Many thanks for any help in advance.
Ignition OnJourney StartIdle StartGPS PeriodicGPS PeriodicGPS PeriodicDigital Input 0 HighPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicDigital input 0 LowPTO OffGPS PeriodicGPS PeriodicIdle EndGPS PeriodicGPS PeriodicDigital Input 0 HighGPS PeriodicPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicIdle StartGPS PeriodicDigital input 0 LowPTO Off
Thanks,
Charlie