Remove all spaces , newlines, tabs from a text field

HCL Domino Domino Forum
1

I have an text entry field where I store an JSON object as string e.g.

[{

"name": "Organisation",

"propertyName": "orgName"

}, {

"name": "Function",

"propertyName": "job"

}]

for readability I would like to keep the format but for programmatic purposes I would like to store the object plain without the spaces , tabs, newlines in a second field (computed).

However I am fighting with the correct computation. I tried @ReplaceSubstring(@Implode(@Explode(Config_Edit; @NewLine); “”); " "; “”) but does not give me the proper result yet.

2

Subject: Is it a text list or text field

Is newline a separator for multi value fields?

3

Subject: no, just a single value field

4

Subject: remove all spaces , newlines, tabs from a text field

I would use

@replace (thestring;@char(9:10:13);“”)

5

Subject: RE: remove all spaces , newlines, tabs from a text field

I still have the tab characters remaining

6

Subject: RE: remove all spaces , newlines, tabs from a text field

not sure if you can call it a ‘tab’ but I mostly check my json objects via jsonlint http://jsonlint.com/ so if I paste the code from here in my Notes field and run the code it still contains the ‘tabs’ from jsonlint website

7

Subject: RE: remove all spaces , newlines, tabs from a text field

try

@replace (thestring;@char(9:10:11:13);“”)

If not past the string into a hex editor and figure out the ascii value I pasted in some of the popular ones

DEC Description

0 Null char

1 Start of Heading

2 Start of Text

3 End of Text

4 End of Transmission

5 Enquiry

6 Acknowledgment

7 Bell

8 Back Space

9 Horizontal Tab

10 Line Feed

11 Vertical Tab

12 Form Feed

13 Carriage Return

8

Subject: RE: remove all spaces , newlines, tabs from a text field

tried this, but without the desired results. also loaded the code into a hex editor but I do not understand how I should handle the result…

9

Subject: RE: remove all spaces , newlines, tabs from a text field

Have you tried it with @ReplaceSubstring rather than @Replace?