pcsoft.us.windevCopyright 2026, PC SOFT21 Jun 2015 13:49:00 Z21 Jun 2015 04:08:00 ZHello All I am converting Excel data by reading the rows in an Excel file. I am reading the data in row 1 of the file as Column headings to determine how to treat the data SWITCH NoSpace(LColHeader) CASE "Code" The data in the cell is "Code " and neither the NoSpace() or Left() functions will strip off the spaces on the end. It is not just the data in row 1, a fair bit of the other data has spaces at the end that cannot be removed by these functions I have changed the code to Position() and that works fine but I am curious if any one has a solution or any ideas as to what is going on. The data was actually collected from a screen display of General Ledger accounts from a web page of the Xero Accounting software as a copy and then paste into an Excel page and then converted to csv so maybe that process introduced some sort of "hard" space that Windev doesn't recognise as a normal space ? Regards Al30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52826/read.awp21 Jun 2015 13:49:00 ZHello Al, Well.. it is a hard space that is supposed to always stay in place... And as a simple replace will do the job IF/WH…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52826/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52826/read.awp[WD19] Nospace() and Left() not working with data from Excelguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52825/read.awp21 Jun 2015 07:57:00 ZHello Fabrice Thanks for the idea. I just used a hex editor and pasted it in though :) The spaces in the file are Hex A0. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52825/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52825/read.awp[WD19] Nospace() and Left() not working with data from Excelguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52823/read.awp21 Jun 2015 04:37:00 ZHello Al, to know whats what, put the value coming from excel in a buffer, then do a buffertohexa and display the result... Y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52823/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52822-wd19-nospace-and-left-not-working-with-data-52823/read.awp[WD19] Nospace() and Left() not working with data from Excel