PS Query Lists
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PS Query Lists
| Line 10: | Line 10: | ||
4: Click OK and save the expression and return to your new criterion. | 4: Click OK and save the expression and return to your new criterion. | ||
| - | 5: Add the right hand side of the criterion as the constant a | + | 5: Add the right hand side of the criterion as the constant value "a" (without the quotes) |
| + | |||
| + | ==Creating the List== | ||
| + | |||
| + | Creating a quoted, comma separated list can be done in a text editor, in a spreadsheet or in an online tool such as Regular Expression Calculator. | ||
| + | |||
| + | To convert a list of items, one to a line into a SQL "in" list: | ||
| + | |||
| + | 1: Put the raw list in the left hand "source" box. | ||
| + | 2: Depending on your platform, input the following into the "Regular Expression" box: | ||
| + | |||
| + | *Windows* | ||
| + | <nowiki>([^\r]*)</nowiki> | ||
| + | |||
| + | *Mobile Devices* | ||
| + | <nowiki>(.*)</nowiki> | ||
| + | |||
| + | 3: In the "Replacement Text" box, type in: | ||
| + | |||
| + | <nowiki>'$&',</nowiki> | ||
| + | |||
| + | 4: Click "Replace" and your comma separated list appears in the right hand box. | ||
