pcsoft.us.windevCopyright 2026, PC SOFT11 Feb 2016 11:28:00 Z8 Feb 2016 15:30:00 ZHi, I have some problems with a part of my own build sql string. I have to extract the filename suffix .... FROM Files WHERE WL.ExtractString(Files.Filename,-2147483645,'.') = 'pdf' The number is the constant for "lastrank". The SQL doesn´t run. Any idea whats the problem is ?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56362/read.awp11 Feb 2016 11:28:00 ZHi Piet, fextractpath(files.filename,8) runs, but it returns 0 rows ... I think the "8" is not right in the SQL Environment. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56362/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56362/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56346/read.awp10 Feb 2016 18:02:00 ZHi Michael, If you do a info(fExtension) you get 8. You will probably be able to use it like this in your WL.fExtractPath(My…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56346/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56346/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56339/read.awp10 Feb 2016 13:50:00 ZStrange, if I use this statement, from the hf controlc centre 20, on one of my testdatabases it works like a charm and gives …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56339/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56339/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56338/read.awp10 Feb 2016 13:32:00 ZHi Arie, no both of it doesn´t work LastRank: sSQLText+=StringBuild(" AND ( Masterplan.Plannummer + Masterplan.Index …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56338/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56338/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56337/read.awp10 Feb 2016 13:15:00 ZHi, The requirements aren't clear are they? Because users can always enter anything... not always what we'd like them to: …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56337/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56337/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56336/read.awp10 Feb 2016 12:43:00 ZBTW: according to my debugger fromBeginning=0 and fromEnd=1 So you can use this straight away. And the value for lastRank…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56336/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56336/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56335/read.awp10 Feb 2016 12:28:00 Zwhat about using StringCount to get the number of the last 'point' , thus avoiding the use of a constant? WL.ExtractString(Fi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56335/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56335/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56334/read.awp10 Feb 2016 12:18:00 ZDarren Curious... How could a file extension not be at the end of the file name? If this were the case how would you choose…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56334/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56334/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56333/read.awp10 Feb 2016 12:12:00 ZHi Darren, may be my english is too bad. I use the WX SQL Editor. I can use all WL commands in the list of WL commands shown…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56333/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56333/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56332/read.awp10 Feb 2016 12:04:00 ZHi Michael, No point banging your head for too long on this. With WD working the way it does, I would use SQL to bring back t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56332/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56332/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56331/read.awp10 Feb 2016 11:43:00 ZHi Arie and Derek, I use HFSQL. For me the interesting part is: How to use the wl.commands in the sql editor if the have cont…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56331/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56331/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56329/read.awp10 Feb 2016 11:20:00 ZMichael, maybe you can add an extra field "file_extension" or "file_type" to the database? And do the extraction in your own…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56329/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56329/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56328/read.awp10 Feb 2016 11:19:00 ZMichael Not sure I can help then as I do not believe MySQL offers that functionality - Not that I am a guru in this respect. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56328/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56328/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56327/read.awp10 Feb 2016 11:01:00 ZHi Derek, it´s not so easy lile is seems. I have a database of millions of files. The user can select these files over the da…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56327/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56327/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56326/read.awp10 Feb 2016 10:55:00 ZMichael Do not understand the 2 dots issue. Pretty poor naming convention to begin with but in any case it will be the chars…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56326/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56326/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56314/read.awp9 Feb 2016 22:28:00 ZHi Derek, what do you doing with "mynewExceldocument.xlsx" ? :rp:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56314/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56314/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56313/read.awp9 Feb 2016 21:58:00 ZMichael Can you not do something along these lines? SELECT DocumentLog.Filename AS Filename, RIGHT(DocumentLog.Filename,3)…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56313/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56313/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56311/read.awp9 Feb 2016 14:09:00 ZHi Derek, I used now "SPLIT_PART" which works ok if the filename has only one "." in his name. I don´t know how to set "fE…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56311/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56311/read.awp[WD20] Extract a filename suffix in a SQL stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56305/read.awp8 Feb 2016 17:49:00 ZMichael fExtractPath(MyFilename,fExtension) is your friendhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56305/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56304-wd20-extract-filename-suffix-sql-string-56305/read.awp[WD20] Extract a filename suffix in a SQL string