pcsoft.us.windevCopyright 2026, PC SOFT11 Apr 2018 06:15:00 Z10 Apr 2018 21:29:00 ZHi, I'm using JSONToVariant to take a JSON payload and convert into an object and write the elements out to our database. Everything is working fine EXCEPT that and string variable that contains spaces the spaces are removed. sPayload = (the json file being inspected) vPayload is Variant=JSONToVariant(sPayload) IF vPayload.Client.Country<>"" THEN Client.Country=vPayload.Client.Country END In the above example if the original value for "County" in the JSON file is "United States" when it is written to the database the space is stripped out and the value saved is "UnitedStates" What am I doing wrong? Thanks! Steve30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65176-json-variant-stripping-spaces-from-string-values/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65176-json-variant-stripping-spaces-from-string-values-solved-65180/read.awp11 Apr 2018 06:15:00 ZThanks King. it was user error on my parthttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65176-json-variant-stripping-spaces-from-string-values-solved-65180/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65176-json-variant-stripping-spaces-from-string-values-solved-65180/read.awpJSON to Variant stripping spaces from string valuesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65176-json-variant-stripping-spaces-from-string-values-solved-65179/read.awp11 Apr 2018 02:43:00 ZHi Hard to say as 'dun know the content of json sPayload = (the json file being inspected), ??? and you may chop part o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65176-json-variant-stripping-spaces-from-string-values-solved-65179/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65176-json-variant-stripping-spaces-from-string-values-solved-65179/read.awpJSON to Variant stripping spaces from string values