need to convert a binary text file logically

[dataacq]

Hi,

      I have binary text file which i read and converted to a two dimensional array using Spreadsheet string to array. Then i converted the 2D array to 1D array by concatenating the columns. now i want to covert this array logically to another array  of same dimensions such that all 0's are be replaced by -5 and all the 1's be replaced by +5.  thank you.

Regards,

Raja

[MikeS81 · Accepted solution]

Hi Raja,

you can go through a loop and replace all your values or you use the "Flatten to String" function and replace your values with the "Search and Replace String" function. Convert the string back to your array with the "Unflatten from String" function.

Mike