I’m using StudioX to download a CSV, copy the data into an excel and then manipulate the data as I need it. There is a column labeled Text that has data I need, but it frequently has extra spaces or numbers that I need to remove so that I can perform a VLookup with another file. I’m currently using Modify Text and Text to Left/Right to clean it up and then setting a variable with the cleaned up spacing, but it doesn’t exclude the numbers that are sometimes there and therefore my VLookup isn’t working. For Example:
1st row the data is Bank Account One XXXXX65456365635
2nd row the data is Actual Bank Account Ready 4564354 5635643
I need the output to be “Bank Account One” and “Actual Bank Account Ready”
Is there a way to do this even though each row may have different length data? One row may have 3 words another may have 6.
Hey @sjavits-cohan
You can open the expression editor and use the Regex expressions.
To remove digits you can use: System.Text.RegularExpressions.Regex.Replace(inputString, "[\d-]", String.Empty)
To remove extra spaces you can use something what remove 2 or more spaces from string: System.Text.RegularExpressions.Regex.Replace(inputString, " {2,}", "")
@lrtetala this mostly worked! It got rid of all the numbers - is there a way for it to get rid of any extra spaces if there are any? For example: Bank Account.
