BookmarkSubscribe
Choose Language Hide Translation Bar
vinkane
Community Trekker

Is there a formula to remove white space from a character field ?

Is there a formula to remove white space from a character field. The data field is not supposed to have and white spaces or blank spaces within the field.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
msharp
Super User

Re: Is there a formula to remove white space from a character field ?

More accurately:

regex(text,"\s","",globalreplace);

Your code will only remove spaces, \s will find all white space in regex including tabs, carriage returns, new lines, and a host of other white space characters.

0 Kudos
3 REPLIES 3

Re: Is there a formula to remove white space from a character field ?

Trim will remove white space at the beginning and or the end of the field. I'm not sure if it will remove white space in the middle of the field.

0 Kudos
uday_guntupalli
Community Trekker

Re: Is there a formula to remove white space from a character field ?

VinKane​ : This will work :
   Name = "Vin Kane" ;
   regex(Name," ","","globalreplace");   // The first character is white space within quotations , the second character is just quotations without a space
ledi.trutna​ : Trim is not capable of replacing the spaces in between - but like you said it works for leading and trailing white spaces

Best
Uday
0 Kudos
msharp
Super User

Re: Is there a formula to remove white space from a character field ?

More accurately:

regex(text,"\s","",globalreplace);

Your code will only remove spaces, \s will find all white space in regex including tabs, carriage returns, new lines, and a host of other white space characters.

0 Kudos