inserting .txt data into the filter

[tinmar]

Can someone help on this ... currently using Impromptu and have had my access to the SQL are taken away from the dept, so the only way to create reports is to just drag and drop the tables. However, I need to search for some data and I'm using this in the filter.

MSISDN in ( '0423345645') , ... my problem is that I need to insert a lot more MSISDN's, so I need to be putting

MSISDN in ( '0423345645', ' 04xxxxxxxx', ..... etc ), but I can't seem to just copy this from a txt file... can someone help me, cause when I copy the numbers from a .txt file, it gives me an error and wont run.

 

[drlex]

On the basis you're not talking hundreds of possible items, one solution would be to set the filter to "MSISDN in (?Prompt?)" and set the prompt to be a File Picklist on your text file (Ctrl-click to select multiple).

soi la, soi carré