How can I eliminate spaces from a file?

[MollyHix]

I am trying to read in a list of numbers from a file, each line has two numbers with a space in the middle how can I eliminate the space and just read in each number?

[altenbach]

Couldn't you just use "Read from spreadsheet file" and wire a "space" character as delimiter?

If this does not work right, you might have variable numbers of consecutive spaces. Please post a sample data file so we can see what's best).

[RJay]

There is also a "remove white space" icon available in the additional strings functions.

[MollyHix]

Thank you for your help. Is the "remove white space" icon only in certain versions or do I have to add it in, because I do not have it on mine. I have version 6.1.

[MollyHix]

I tried using the "Read from speardsheet file" with the space as the delimiter and it only read the numbers before the space for some reason. I am not sure why.

[Ray.R]

Hi MollyHix,

If the file is already opened and you wish to re-format the string by removing the white space, you may want to try the following:

Wire the string to the "Search and Replace String.vi" which is located in the FUnctions Palette under "String".
Right-click on "Search String" and create Constant.
Right-click on the new constant and select "\" Codes Display.
Type \s
At the top (or actually middle) of the "Search and Replace String.vi", wire TRUE for "replace all".
Wire an empty string constant "" to "replace String".

The result string should give you a string without white space.

-Enjoy-

JLV

[Ray.R]

here is a small example

[MollyHix]

That did it!!Thank you so much!! I had version 6.1 so I could not see your example but, your step by step instructions were so helpful THANK YOU!! Molly

[Ray.R]

I'm glad it worked..

I keep forgetting to transfer my examples to LV6.1..

🐵

[zilla]

Joe,

Could you elaborate a little on what is going on when one selects "/" Codes Display , is there a list of codes somewhere to reference as to what codes to use to do a particular task.

thanks