Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. joeengler

    need to pull data from text field

    Working now Thanks for all the help
  2. joeengler

    need to pull data from text field

    Thanks for all the help so far, I still get the same error, this is what crystal is highlighting as the problem left(x,instr(x," ")-1)
  3. joeengler

    need to pull data from text field

    I get an error while processing records, "Stgring Length is less then 0 or not an integar I tried adding a if statement to make sure I'm only looking at records with this summary if {Call.Summary} like '*Call WFJN:*' then stringvar x := trim(extractstring({call.summary},":",":"))...
  4. joeengler

    need to pull data from text field

    Sorry, The job number can be 4,5 or 6 digits (1332) Call WFJN: 60161 WFWO: 02NCR_000 OCA AP Checks (1341) Call WFJN: 5374 WFWO: 02NCR_000 OCA AP Checks (1339) Call WFJN: 715420 WFWO: 02NCR_000 OCA AP Checks
  5. joeengler

    need to pull data from text field

    I have a text field from a SQL database that contains the following '(1332) Call WFJN: 60161 WFWO: 02NCR_000 OCA AP Checks' I need to pull out the job number which is between the 'WFJN:' and 'WFWO' Database = SQL Crystal = 10.0 Field name = summary Table = Call
  6. joeengler

    Help in Grouping

    HI, I working on a purchase report that will show the lowest cost, current cost and flag field if increase or decrease along with a %change The data is in SQL 2 tables {inv_list} and {receipts} with the tables being link on 2 key fields {location} and {part_no} I have created a report and...
  7. joeengler

    clientele users

    Hi, We use it and our in the middle of a upgrade to 7.3 I may be able to help.

Part and Inventory Search

Back
Top