string functions

[gadamParticipant]

Are there some string functions in data graph like substr()?

They can be useful in “text expressions” to create new text variables using only a part of a previous one.

Thanks

Gaetano

[dgteamModerator]

We currently only have option of concatenating using a text expression.

There is a Number from Text column in the beta that will strip out all the text and return a number field.  We just realized this help page is missing from this site so we will add that.

The other current option would be to use the Import Special parser to pull apart a text string on import.

Is this a common need you have?

[tom lawtonParticipant]

Ahhh- I was about to add a “me too”, when I realised you had a “Paste Special” which could throw out non-numerics, as I was doing a quick-and-dirty paste from Excel, which carried over the “%” symbols….

[dgteamModerator]

Good point!  Paste Special is also useful for removing or parsing the data in a way that is different from the default.

For anyone wanting to learn more, there is documentation on Paste Special on the Data Input page.

[Author]

Posts