Skip to Content
avatar image
Former Member

PLD

Hi

For e.g i have 1 udf in which it is wriiten 435w- INR 42,500. Is it possible to extract characters after - . Lenght of characters can vary after -.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2010 at 09:11 AM

    Hi,

    Open one more udf and set following query in FMS you will get exact characters after '-' and prnt it in PLD udf.

    select Replace('435w- INR 42,500',substring('435w- INR 42,500',0,charindex('-',435w- INR 42,500')+1),'')

    Thanks

    Sachin

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 17, 2010 at 03:45 PM

    Hi,

    For PLD:

    -


    Let Field_1 =435w- INR 42,500

    add one formula fileld Field_2 next to the Field_1, put Lenght(Filed_1) in formula.

    Now create another formula filed and add Substring(Filed_1,6,Field_2) formula.

    This will give you result INR......

    On SystemForm Screen

    -


    Use below query,Replace field name and table name,save query and apply FMS

    SELECT SubString($[ORDR.U_UserText],6,Len($[ORDR.U_UserText]))

    Hope this will help you.

    Thanks,

    Neetu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2010 at 03:52 PM

    HI,

    You need another UDF by FMS query to get that.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2010 at 04:39 AM

    Closed.

    Add comment
    10|10000 characters needed characters exceeded