String manipulation in formula-generate field

[GoogleCodeExporter]

What new feature would you like to see implemented? How will you use it?

Fusion Tables supports creating a new column populated with the result of a 
formula on values in other columns. Supported formulas are: Basic operations: + 
- * / ; functions: cos() sin()  power(base, exponent); logic: if (condition, 
then, else)

How about some basic string manipulation, allowing the creation of 
concatenation, parsing, etc.

WONDERFUL TOOL, BTW!!!

--------------------------------------------------------------------------
NOTE: Use this form to suggest new features for Google Fusion Tables
website or API.  For BUGS, please e-mail us at googletables-
feedback@google.com.

Your "star" vote on requests in this issue tracker helps the Fusion Tables
team prioritize work on the most useful features.

By submitting this form you agree to the Google Terms of Service
(http://www.google.com/accounts/TOS) and the following additional term:
In addition to the Content license you grant to Google in Section 11 of the
Google Terms of Service, you agree that Google may, at its option, use your
Content to provide support for, or to develop, correct or improve Google's
current or future products and services, without any compensation to you.

Thanks for the suggestion!
--------------------------------------------------------------------------

Original issue reported on code.google.com by miCin...@gmail.com on 19 Jan 2011 at 4:14

[GoogleCodeExporter]

Thanks for the request!

-Rebecca

Original comment by rshap...@google.com on 21 Jan 2011 at 7:08

• Changed state: Acknowledged
• Added labels: Component-Logic

[GoogleCodeExporter]

More functions are needed for date manipulation, for example. 
A good reference is Google-Refine and its GREL syntax. They also provide Jython 
and Clojure syntax. In general Google-Refine is providing a great reference for 
other functionalities that can be integrated into the Fusion Tables. 

Original comment by guy.ern...@gmail.com on 5 Aug 2011 at 11:08

[GoogleCodeExporter]

It would be really helpful to include text strings in formulas e.g. 
If(Cell="text1", "text2", (text 3")
The uses are plentiful, but one ould be to set map icons based on input from a 
form. For a disaster response form, if the disaster is a fire, show the fire 
icon.

Thanks

Original comment by sdarc.ff...@inrelief.org on 1 Mar 2012 at 1:30

[GoogleCodeExporter]

Yes!  I agree with all of the above!

This is an extremely important feature - should be HIGH priority.

Thank you, GFT Team, for all you do!

Original comment by jfmcneir...@gmail.com on 2 Mar 2012 at 3:29

[GoogleCodeExporter]

Yes...this would be great to have. Also would be nice to make the forumla input 
box a little larger.

Original comment by drew.ger...@gmail.com on 11 Jul 2012 at 3:45

[GoogleCodeExporter]

Concur, string catenation would be a very useful addition that would make my 
application possible to do in Fusion Tables, and which is not currently 
possible.

Original comment by shethv...@gmail.com on 12 Jul 2012 at 3:55

[GoogleCodeExporter]

YES, please implement strings for conditions!

Original comment by viennale...@gmail.com on 16 Oct 2012 at 7:17

[GoogleCodeExporter]

Yes, I that would allow for such flexibility and fine tuning. 
At minimum allow the IF work as string compare...

Original comment by peter...@gmail.com on 29 Mar 2013 at 6:55

[GoogleCodeExporter]

would like to see formula column 'if' to allow string comparison

Original comment by mark.car...@gmail.com on 12 Aug 2013 at 6:48

[GoogleCodeExporter]

like to have more formular possibilities (e.g. string comparison) - so far this 
is pretty poor

Original comment by ralf.wes...@gmail.com on 12 Nov 2013 at 5:56

[GoogleCodeExporter]

agree with all of the above although my specific issue at this moment is not 
being allowed to use text in an if formula or have an if formula return text.  
I was trying to use it to add markers column for the map.

Original comment by jsti...@gmail.com on 18 Dec 2013 at 6:29

[GoogleCodeExporter]

Other info function like isnull (or isempty), isnumber, istext would be very 
useful.

Original comment by Baza...@gmail.com on 23 Dec 2013 at 7:49

[GoogleCodeExporter]

a simple comparison of text would be a good start, if (col1=col2,"","") with 
col1,col2 being text values!
would very much appreciate this to be able to work with it!

Original comment by stelzer....@gmail.com on 5 Mar 2014 at 12:22

[GoogleCodeExporter]

The ability to work with formula is very important for me.
e.g. varying the colour of an icon based on the text value in a cell.

I was hoping to use google sheets but the link between g sheets and fusion does 
not appear to be working.

Back to OP: WONDERFUL TOOL, BTW!!!

Original comment by derry.ma...@gmail.com on 6 Mar 2014 at 9:51

[GoogleCodeExporter]

String compare would allow us to work around some of the mapping limitations, 
such as not being able to map markers to column string values  

Original comment by egoncast...@gmail.com on 16 Apr 2014 at 8:28

[GoogleCodeExporter]

Please!  Just began using Fusion Tables and it's such a great start, but some 
holes that may make it ultimately unworkable.  lack of text string manipulation 
is one of them (the other is no integration between fusion table & spreadsheet, 
although that could be worked around if there was string manip in fusion).  

Original comment by GCM...@gmail.com on 29 Apr 2014 at 2:30

[GoogleCodeExporter]

String manipulation please.  e.g.  LEN, MID, LEFT, RIGHT

Original comment by chuck.th...@gmail.com on 16 Jun 2014 at 9:26

[GoogleCodeExporter]

I need it too 

Original comment by bharatba...@gmail.com on 3 Jul 2014 at 7:22

[GoogleCodeExporter]

That would be of great use. Thanks !

Original comment by b.cande...@gmail.com on 3 Jul 2014 at 1:24

[GoogleCodeExporter]

I have a column of dates that came in as "FY 2013". I wish there was a simple 
way to edit the whole column to turn the string "FY 2013" to the number 2013.  
Thx.

Original comment by tlskill...@gmail.com on 18 Aug 2014 at 4:29

[GoogleCodeExporter]

Issue 1422 has been merged into this issue.

Original comment by kad...@google.com on 15 Oct 2014 at 12:45

[GoogleCodeExporter]

Lack of string logic, manipulation, and text output is not a "Medium Priority" 
for any functional database, it is a fundamental requirement. Basic logic 
operators (CASE, IF, AND, OR, NOT XOR, TRUE, FALSE, ISEMPTY, ISNUM, ISTEXT)must 
be included as well as basic text manipulation operators(CHAR, CONCATENATE, 
EXACT, FIND, LEFT, LEN, MID, RIGHT). Without this functionality, Fusion Tables 
is unworkable as a database solution.

Original comment by i...@soperwheeler.com on 20 Nov 2014 at 5:15

[GoogleCodeExporter]

Yes, please add the basic logic operators. That would really rule.

Original comment by Bredband...@gmail.com on 19 Dec 2014 at 12:00

[GoogleCodeExporter]

I really miss string and date manipulation formulas. E.G. to shou week or month 
averages would be easy using Summarize functionality if functions like 
weeknum() month() would be usable in formulas columns.

It is anoying to have to prepare data for such simple operation in Sheets or 
Excel.

Original comment by evze...@gmail.com on 30 Jan 2015 at 11:28