Page 1 of 1

getting data from a field and putting it into another field

Posted: Sun May 07, 2023 7:17 pm
by CAsba
Hi,
Just when you thought you'd got rid of me...

The code is

Code: Select all

put item 1 of line 2 of fld "arraydata" into fld "de11"
.
The problem is, Instead of just getting item 1, it puts the whole line - 3 items - into fld de11.

I have tried putting the items into fld arraydata using tab and using "," as the delimiter.

I could of course, bypass arraydata and put the fields directly into the de** fields, but I don't want to do that as I want to rename and keep the arraydata field to produce duplicate copies of the document if required.

To summarise, how can I get the items of each line in fld arraydata into new individual fields ?

Re: getting data from a field and putting it into another field

Posted: Mon May 08, 2023 12:34 am
by glenn9
Hi CAsba,

did you set the 'itemdelimiter'?

Regards,
Glenn

Re: getting data from a field and putting it into another field

Posted: Mon May 08, 2023 12:38 am
by dunbarx
Glenn makes a point; though you mentioned the itemDel, there is no context to see what is going on.

Your single line code example tells un nothing about the actual string you are trying to process.

What is that string?

Try again... :wink:

Craig

Re: getting data from a field and putting it into another field

Posted: Mon May 08, 2023 2:35 am
by stam
I was gonna say... this doesn't quite make sense.
perhaps post some of the text you're trying to process and your handler?

S.

Re: getting data from a field and putting it into another field

Posted: Mon May 08, 2023 4:25 am
by dunbarx
Stam.

I think we have the handler, or at least a line in it that is of interest.

What we don't have is the contents of what seems to be a single line of text, in which the problem lies. Or rather, I bet, missing items...

Craig

Re: getting data from a field and putting it into another field

Posted: Mon May 08, 2023 9:12 am
by CAsba
Thanks Glenn, I didn't know the itemdelimiter setting was necessary for the extraction of data from a field. It works !
Thanks again.

Re: getting data from a field and putting it into another field

Posted: Mon May 08, 2023 9:46 am
by Klaus
The DEFAULT itemdelimiter = COMMA, so you need to set it everytime you need something else as a delimiter!

Re: getting data from a field and putting it into another field

Posted: Mon May 08, 2023 12:29 pm
by CAsba
Very good, Klaus, I'll remember that ! Many thanks.