| Author |
Message
|
| sandyk_4u |
 Posted: Mon May 16, 2011 1:12 am Post subject: Need help on generating Output field value generation. |
 |
|
Newbie
Joined: 09 May 2011
Posts: 2
|
Hello All, My requirement is to get the value of output field as following format...PCARD0000000000N / PCARD0000000000N / ......... PCARD000000000N ... PCARD00000000N..where N holds the total number of invoices and 'PCARD'||'000000' are the constants....the only thing is to attach the current value of invoice record to that constant values..could some one please help me out.....
Thanks. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon May 16, 2011 2:50 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Well, one way is to use the || operator in ESQL. |
|
| Back to top |
|
|
| sandyk_4u |
| Posted: Mon May 16, 2011 3:10 am Post subject: |
|
|
Newbie
Joined: 09 May 2011
Posts: 2
|
| Hi MqJeff, TanQ for your reply...i was aware of that..but the thing ,we have to add the current number of invoice record at the place of 'N'..if suppose input contains 10 invoces..then the output field value must be like this.. PCARD00000000001/PCARD00000000002/PCARD00000000003/PCARD00000000004/PCARD00000000005/PCARD00000000006/PCARD00000000007/PCARD00000000008/PCARD00000000009/PCARD000000000010. |
|
| Back to top |
|
|
| kimbert |
| Posted: Mon May 16, 2011 3:23 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| I agree with mqjeff. Why can't you use the || operator for this? |
|
| Back to top |
|
|
| paintpot |
| Posted: Mon May 16, 2011 3:38 am Post subject: |
|
|
Centurion
Joined: 19 Sep 2005
Posts: 112
Location: UK
|
Is the data a single string, or an array of strings?
Are you using a message set, as you could then set the invoice number and select padding with leading zeroes, for the 000000000N chunk.
You could also loop and create the output using string manipulation as already discussed...
Quite a few ways here, really. |
|
| Back to top |
|
|
|
|
