topic Separate in App Development

Separate

renuka_sasikumar — Tue, 17 Jul 2018 07:12:23 GMT

Hi,

I have a data

Table A:

Data

DDDD

And now I want the output as

Data

Is this possible?

Can anyone help me.

Re: DDD to be seprated as D D D

datanibbler — Tue, 17 Jul 2018 07:23:22 GMT

Hi Renuka,

I think Subfield is the function you want - look it up in the helpfile, one of its uses is to separate strings into several records. You might have to load the rest first and do that separating part in a separate load - you'll have to try it out a bit.

HTH

Best regards,

DataNibbler

Re: DDD to be seprated as D D D

ogautier62 — Tue, 17 Jul 2018 07:31:12 GMT

Hi,

something like this :

tableB:

load mid(Data,iterno(),1) as 'newfield' resident tableA while iterno()<= len(Data)

regards

Re: Separate

Anonymous — Wed, 18 Jul 2018 10:09:50 GMT

Hi!

Use this:

LOAD

Data,

SubField(Data,' ') as test

FROM [lib://Community/308076.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: Separate

renuka_sasikumar — Wed, 18 Jul 2018 10:17:57 GMT

Hi,

Thanks for your reply, but your query gives the same output.

I got the answer see the below one

Temp:
LOAD * Inline
[
Data
A
B
C
DDDD
];

Temp1:
load
Mid(Data,iterno(),1) as 'newfield'
Resident Temp
while iterno()<= len(Data);

Drop Table Temp;