Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesI often have to process strings as number, i.e. read a number from a csv as a string and then have to convert to number. I would like to be able to use the data cleanse component and say treat as number format and then select the format, e.g. fixed decimal. I would then expect the cleanse component to strip out any characters that would prevent the string from converting to the number format, i.e. strip out the commas but leave the full stops.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.