*Remove Spaces From Field Automatically

P

PumaMan

I have a textfield(string) where a user is pasting data that contains spaces.
Can I have the field automatically remove the spaces?
 
S

SMS

I have a textfield(string) where a user is pasting data that contains spaces.
 Can I have the field automatically remove the spaces?  
Click to expand...

You use "transalate" function to replace characters. So combine it
with rules so that whenever somebody puts in a text, it will replace "
" with ""
 
S

Swathi (GGK Tech)

Hi,
Add a rule to the text box.
1.Go to text box properties. Click On Rules.
2.Click Add and then click Add Action.
3.Select ‘Set a field’s value’ in Action drop down.
4.Select the text box field in Field.
5.In Insert formula, write translate(., " ", "").
Hope this will help you.
 
P

PumaMan

Shukriya Swathi!

It works beautifully!

Swathi (GGK Tech) said:
Hi,
Add a rule to the text box.
1.Go to text box properties. Click On Rules.
2.Click Add and then click Add Action.
3.Select ‘Set a field’s value’ in Action drop down.
4.Select the text box field in Field.
5.In Insert formula, write translate(., " ", "").
Hope this will help you.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Make elements in a row space between instead of wrapping when choosing multiple columns 0
(Word 2016/365) Removing white space between pages at a smaller zoom 0
Proposal template with removable sections 0
Space at end of multi page list to accommodate new entries 1
How to map SharePoint drives permanently 0
White space above heading inconsistently applied 1
Remove Identical words 0

Top