ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Remove whitespaces from spreadsheet string

Hello,

 

In the attached VI, I am attempting to remove all the white spaces from a generated "Spreadsheet string" block.  All the \t, \s, \r, \n.

 

I am using the "Search and Replace String" block but it does not seem to be working.  Can you tell me what I am doing wrong?  I have the "search" input as " '\' Codes display"

 

Can you assist me in removing all the white spaces?  Thanks!

0 Kudos
Message 1 of 4
(1,923 Views)

Try this (right-click on the Search and Replace String function and tell it to use a RegEx):

jcarmody_0-1620146870604.png

 

Jim
You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice
For he does not know what will happen; So who can tell him when it will occur? Eccl. 8:7

0 Kudos
Message 2 of 4
(1,897 Views)

Right click the node and check Regular Expression. That should do the trick. (It worked for me)

 

mcduff

Snap118.png

 

0 Kudos
Message 3 of 4
(1,895 Views)

Right click the function and check Regular Expression

.

0 Kudos
Message 4 of 4
(1,886 Views)