Remove non printable characters in input text/para field.

Question

Hi ,

I have a set of non printable characters in DB as number and we use char function and concat function to combine in a single string and used strip function to remove it from text. Now the requirement is to replace text with space. I tried substitute function and others which is not working as expected. Please someone guide me herea!localVariables(
  local!specialCharacterIds: rule!SUF_QueryRecordType_getSpecialCharacters(),
  local!specialCharacters: joinarray(
    a!forEach(
      local!specialCharacterIds,
      char(fv!item)
    ),
    ""
  ),
  a!paragraphField(
    label:"Comment",
    value:ri!comment,
    saveInto: {
      ri!comment,
      a!save(
        ri!comment,
        substitute(save!value,{local!specialCharacters}," ")
      )
    }
  )
)

shubhama926776 · Answer

I tried to replicate your requirement.Make changes to your code accordingly.a!localVariables(  local!specialCharacterIds: { 9, 10, 13, 160, 8203 },  /* Tab, LF, CR, NBSP, Zero-width space */  local!sampleText: "John" & char(9) & "Wick" & char(10) & "Test" & char(13) & "Data" & char(160) & "End",  /* Convert IDs to actual characters */  local!specialCharacters: a!forEach(    local!specialCharacterIds,    char(fv!item)  ),  {    a!textField(      label: "Comment",      value: reduce(        fn!substitute,        local!sampleText,        local!specialCharacters,        " "      ),      readOnly: true    )  })Let me know if this works for you.

Sign up

Login with SSO

Login to the community

Login with SSO