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!

  • Congratulations strongm 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. deangels3

    Calculate actual amount to be paid

    Hi, I need to create a report to show the amount my client is supposed to pay for vehicles provided to transport their staff. We have a table that holds contract details for the vehicle. 1) the contract has a start and end date and this is held in Contract.Start_Date and Contract.End_Date 2)...
  2. deangels3

    Extracting values after specific words

    You really are a super star LB[flowerface]! It has done the trick! After I made the changes as you have suggested, I viewed the result and it was just 1 long string. After a long while of trying to figure out what was wrong, I realised that I have not change the Text Interpretation to HTML...
  3. deangels3

    Extracting values after specific words

    Hi LB The raw data is as follows: <value type="simple" label="Service Reg Hist ID">7207</value><value type="simple" label="ServiceID">f30dba55-f45c</value><value type="simple" label="End Date">27/03/2017</value><value type="simple" label="Registration Type">AS Directory</value><value...
  4. deangels3

    Extracting values after specific words

    Hi LB <value type="simple" label="Application Type" /><value type="simple" label="Application Status" /> If there is no value in the particular heading, ie Application Type or Application Status, it will just be a blank space after the heading followed by a /. With your latest solution, I am...
  5. deangels3

    Extracting values after specific words

    Hi LB Thank you for your speedy reply. if there is no data, then it will be: <value type="simple" label="Application Type" /><value type="simple" label="Application Status" /> and the output will be just: Application Type Application Status Thank you. LG
  6. deangels3

    Extracting values after specific words

    Hi LB Sorry to bother you again. What should I do if I have the below: <value type="simple" label="Service Reg Hist ID">7486</value><value type="simple" label="Initial Contact Date">09/04/2018</value><value type="simple" label="Start Date">09/04/2018</value> and I would like it to appear as...
  7. deangels3

    Extracting values after specific words

    It worked! You're a super star LB [medal]! Thank you so much [thumbsup2]
  8. deangels3

    Extracting values after specific words

    Hi Ian I tried that and the y in the 7th line is still being highlighted with a message: An array is required here. Thank you. LG
  9. deangels3

    Extracting values after specific words

    Hi lbass Thank you so much for your reply. I replaced the {table.field} with my field, however the y in the 7th line is being highlighted and a message saying 'The ) is missing'. [sadeyes] Thank you. LG
  10. deangels3

    Extracting values after specific words

    Hi, we are using CR XI and our audit table holds old and new values that has been changed, deleted and added. We need to show which data has been changed/deleted/added under each heading. The data is stored as a long string and it looks something like this: <Value label="OpeningDate"><OldValue...

Part and Inventory Search

Back
Top