AnsweredAssumed Answered

Strip " ' " from import fields

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

Hi

 

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

'12/05/07'

 

help would be greatly appreciated

 

Stephen

Outcomes