How do I remove dollar signs, quote marks, etc. from data?
You can remove extraneous characters from Data Desk variables by using different combinations of derived variable string functions. There are five different string functions. The first two commands return, for each case in the variable, a single number. The last three commands return, for each case in the variable, the extracted string. Len(y ) – returns the length, in characters, of the variable y. Pos(y, search string, start position ) – searches the variable y starting at the character position defined by the third argument, start position, for the first occurrence of the string defined by the second argument, search string, and returns the position of the first character of that string. The search string needs to be either a variable or a string contained in double quotes. This command returns 0 if the string is not found. The first character in the string is position 1, so if you want to search from the beginning of the string, the starting position should be 1. Left (y, k ) – ret
