I am new at Enterprise Guide and need some help. I am specifically supposed to use the FIND function and the SUBSTR to pull out only the first percentage in a character string. It looks like this: The column is Recipients Then in the column it lists: Charity 90%. Save the Whales 10% Relief Assist. Inc. 20%. Cuida Ltd. 80% and so on. There are a couple of hundred rows. I need a column that shows only the first %. So, I created a computed column and did FIND(Recipients, "%",1) Then I created a SUBSTR. SUBSTR(Recipients,(FIND(Recipients, "%",1)),-3) This did not work. I thought it would go to the position of the first % sign and then read the two numbers in front of the % sign. Can someone help me with the correct FIND and SUBSTR combination? This is one of the first SUBSTR functions I have done and is the first time I had to use FIND. It should have shown 90% in the first row and 20% in the second row based on the example rows above.
... View more