From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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
(846 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
(820 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
(818 Views)

Right click the function and check Regular Expression

.

0 Kudos
Message 4 of 4
(809 Views)