AnsweredAssumed Answered

Strip " ' " from import fields

Question asked by soco1509 on Jul 4, 2015
Latest reply on Oct 20, 2015 by beverly



I am importing .txt outputs from 3rd party all fields are prefixed and suffixed with " ' " .


ie - '12345'


I use the substitute function to remove the single quotes on all fields with no problems except on dates the date fields still return



help would be greatly appreciated