× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Simple script to extract ECB,CAL AND STMT.ENTRY

  • Winfred_Lubega
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Me
More
7 years 9 months ago #19615 by Winfred_Lubega
Simple script to extract ECB,CAL AND STMT.ENTRY was created by Winfred_Lubega
hello,
I am request to be helped in a simple script that can help me extract data from the CONSOLIDATE.ASST.LIAB, EB.CONTRACT.BALANCES AND STMT.ENTRY. I need to study them individually in excel. the scripts need to have delimiters so that we can put them in excel.

thank you.

Please Log in or Create an account to join the conversation.

More
7 years 9 months ago #19619 by Zoro
Hi Winfred,

You can use SELECT and EVAL and then save it to save list.

SELECT FXXX.CONSOLIDATE.ASST.LIAB SAVING EVAL "@ID:'|':APPLIC.ID:'|':VARIABLE.1:'|':K.TYPE" ... etc ... (select your fields for output)
SAVE.LIST xx1 - After this you can open the file in XL and then use Text to Column Feature in XL

If you want to extract multivalue you can use (FIELD(INPUTTER,@VM,1) .. (FIELD(INPUTTER,@VM,2) .. etc.
Thanks,
Zoro

Good to follow your heart, but don't leave your brains behind !!

Please Log in or Create an account to join the conversation.

  • Winfred_Lubega
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Me
More
7 years 5 months ago #20425 by Winfred_Lubega
Replied by Winfred_Lubega on topic Simple script to extract ECB,CAL AND STMT.ENTRY
hello,
i am trying to run a script to extract some contracts that didnt charge a given charge. the issue is that the charge is a mutlivalue field. the charge is code 41. this is the script
LIST FBNK.LD.LOANS.AND.DEPOSITS WITH @ID EQ "LD1625003533" AND CHRG.CODE EQ "(CHRG.CODE(41)"


please advise

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 years 5 months ago - 7 years 5 months ago #20427 by VK
Hi
if you want to see deals that didn't apply the charge 41, here you are:
LIST FBNK.LD.LOANS.AND.DEPOSITS WITH CHRG.CODE NE "41"

Cheers
VK
Last edit: 7 years 5 months ago by VK.

Please Log in or Create an account to join the conversation.

  • Winfred_Lubega
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Me
More
7 years 5 months ago #20433 by Winfred_Lubega
Replied by Winfred_Lubega on topic Simple script to extract ECB,CAL AND STMT.ENTRY
the charge is charge 41 but its a multivalued field that captures other charges, so its like CHARGE.1, CHARGE.2 etc bt they all map to CHARGE.CODE. so this command doesnt work.

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
7 years 5 months ago #20435 by jpb
Showing the content from your sample LD would help to understand your problem.

Please Log in or Create an account to join the conversation.

  • Winfred_Lubega
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Me
More
7 years 5 months ago #20438 by Winfred_Lubega
Replied by Winfred_Lubega on topic Simple script to extract ECB,CAL AND STMT.ENTRY
Kindly find attached a sample. so i want to extract contracts with legal charge

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 years 5 months ago #20440 by VK
Sorry, try this:
LIST FBNK.LD.LOANS.AND.DEPOSITS WITH EVERY CHRG.CODE NE "41"

Cheers
VK

Please Log in or Create an account to join the conversation.

Time to create page: 0.120 seconds