Series with number to rows

[Runes]

Hi

Could someone please help me? I want to write in one cell a series with number or text separated by commas or semicolons like; 1234; 1342; 1543; .... ; n then this will generate a tables with all this number/text in separated rows.
Thanks

 

[Galaxiom]

Your aim sounds somewhat unusual. Could you explain more about your overall project goals?

 

[gemma-the-husky]

to do this you could

a) use split function to turn this into an array of items
b) then use this array as the base of a loop of sql insert statements.

i would include some code to check that there arent any other separators, just in case.

isnt it as easy just to open a datasheet, and add all these values separately? - or do they come from an external file?

 

[Runes]

It is for use in an storage database where we have x number of item with a serial number on the stock and send out some of these items. It can be over 100 serial number that is sent at once. In order to make sure all sent serial numbers disappear from the status on stock, we want to be able to write these in a simplest possible way as described in the thread.

 

[gemma-the-husky]

still easier to enter them separately into a vertical datasheet (or even into a spreadsheet, and import the psreadsheet.

if you rely on people always typing a semi-colon in a certain format, you are likely to get problems.

it would be quicker anyway to type a number, then cursor down, rather than a string of numbers, that you then have to manipulate again, before you can compare it with your master list.

 

[Runes]

Thanks for your advise. Do you have some examples. I'm a newbie.