Add more fields

[kicchu465]

I have a data like below

Man	id	name	ext	value	memory	number	os	config
HEW	PKD	DLMN380	G8	16	128	1234	WINDOWS	32bit
HEW	PKD	DLMN381	G9	17	128	1235	WINDOWS	32bit
HEW	PKD	DLMN382	G10	18	128	1236	WINDOWS	32bit
HEW	PKD	DLMN383	G11	19	128	1237	WINDOWS	32bit
HEW	PKD	DLMN384	G12	20	128	1238	WINDOWS	32bit
HEW	PKD	DLMN385	G13	21	128	1239	WINDOWS	32bit

I need output like below

in this after colon "this is windowsOS"  should be given to all the numbers  rest all to be concatenate the columns with spaces.

as a separate column

HEW PKD DLMN380 G8 16x128: this is windowsOS

HEW PKD DLMN381 G9 17x128: this is windowsOS

how can I achieve this?

[vishsaggi]

May be this?

LOAD *,

     Man& ' ' &id &' '& name & ' ' & ext & ' ' & value & 'x' &memory&':'& 'this is ' & Lower(os) &'OS' AS NewColumn  INLINE [

Man, id,      name,     ext, value, memory, number, os, config

HEW, PKD, DLMN380, G8,     16,     128, 1234, WINDOWS, 32bit

HEW, PKD, DLMN381, G9,     17, 128, 1235, WINDOWS, 32bit

HEW, PKD, DLMN382, G1,     18, 128, 1236, WINDOWS, 32bit

HEW, PKD, DLMN383, G11, 19, 128, 1237, WINDOWS, 32bit

HEW, PKD, DLMN384, G12, 20, 128, 1238, WINDOWS, 32bit

HEW, PKD, DLMN385, G13, 21, 128, 1239, WINDOWS, 32bit

];