Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Help white spaces at the end

Good afternoon everyone, I need your help because I have a problem with the blanks at the end of a text. In the query editor in the column "Client" there are values that have a space at the end ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Syndicate_Admin ,

     

    I create a sample to have a test and I can reproduce your result. The trailing spaces will disappear in data view after we click "Close & Apply".

    As far as I know, when strings are imported into AS Engine, the trailing spaces are trimmed. So the disappearing of the trailing spaces is by design. Here I suggest you to replace the trailing spaces by other characters like "_".

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Thanks for the help! In this case I need the space not to disappear so the Text.trim function would not be useful for this case.

Best regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Syndicate_Admin ,

     

    I create a sample to have a test and I can reproduce your result. The trailing spaces will disappear in data view after we click "Close & Apply".

    As far as I know, when strings are imported into AS Engine, the trailing spaces are trimmed. So the disappearing of the trailing spaces is by design. Here I suggest you to replace the trailing spaces by other characters like "_".

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.