Help Center

Using String Functions in Feed Rules

GoDataFeed Management
GoDataFeed Management
  • Updated

As of July 2022, it is now possible to use string functions in your feed rules in GoDataFeed. String functions are used in computer programming languages to manipulate a string or query information about a string. 

 

To apply a String function you would begin by creating a rule within one of the feeds and updating the TO section in your rule to use one of the functions listed below. String functions must end with the tag "}}" like the below example:

mceclip0.png

It is also possible to use string functions within one another

mceclip1.png
See the available string functions below that you can use within GoDataFeed when setting up your feed.

Case Functions

Function Description Usage in rule  Example: thiS is THe eXaMpLe
UPPER_CASE Make all characters uppercase UPPER_CASE{{ THIS IS THE EXAMPLE
LOWER_CASE Make all characters lowercase LOWER_CASE{{ this is the example
CAPITAL_CASE Make the first letter of every word capital CAPITAL_CASE{{ This Is The Example
SENTENCE_CASE Make only the first word capital SENTENCE_CASE{{ This is the example

 

Split Functions

Function Description Usage in rule  Example: hello,world
SPLIT First we split the data based on a character. For example, split using a comma. Next, select the data by position. For example, return index 0 after the split. SPLIT(,)[0]{{ hello

 

Substring Functions

Function Description Usage in rule  Example: hello,world
SUBSTRING Return a substring starting and ending at the index. If no ending index is provided the substring will continue to the end SUBSTRING(4){{
SUBSTRING(4,8){{
o,world
o,wo
SUBSTRING_LEFT Return a substring starting at 0 until the index SUBSTRING_LEFT(4){{ hello
SUBSTRING_RIGHT Return a substring starting from the end minus the index SUBSTRING_RIGHT(5){{ world

 

Count Functions

Function Description Usage in rule Example: hello hello
COUNT_LENGTH Returns the length of the value COUNT_LENGTH{{ 11
COUNT_STRING Returns the occurrences of a value COUNT_STRING(hello){{ 2


Format Functions
Note: When a Format-based string function is used it rounds decimal places when implemented. 

Function Description Usage in rule (see link to an example article) Examples
FORMAT_DATE Format a date type value

FORMAT_DATE(:d){{
FORMAT_DATE(:D){{
FORMAT_DATE(:t){{
FORMAT_DATE(:T){{
FORMAT_DATE(:f){{
FORMAT_DATE(:g){{
FORMAT_DATE(:M){{
FORMAT_DATE(:r){{
FORMAT_DATE(:s){{
FORMAT_DATE(:u){{
FORMAT_DATE(:U){{
FORMAT_DATE(:Y){{

19-03-2021
19 March 2021
06:49:20
06:49:20
19 March 2021 06:49:00
19-03-2021 06:49:44
March 19
Thu, 19 March 2021 06:49:22 GMT
2021-03-19T06:49:11
2021-03-19 06:49:49Z
19 March 2021 00:18:55
March, 2021
FORMAT_NUMBER Format a number type value FORMAT_NUMBER(:f){{
FORMAT_NUMBER(:e){{
FORMAT_NUMBER(:g){{
FORMAT_NUMBER(:n){{
FORMAT_NUMBER(:00.00){{
FORMAT_NUMBER(:0.000){{
FORMAT_NUMBER(:0,0){{
FORMAT_NUMBER(:0.0){{
FORMAT_NUMBER(:0%){{
55674.74
5.567474e+004

55674.73789621
55,674.74
55674.74
55674.738
55,675
55,675.7

5567474%


Trim Functions

Function Description Usage in rule Example: hello worldh
TRIM Trim whitespace or character from the beginning and ending TRIM{{
TRIM(h){{
hello worldh
ello world
TRIM_LEFT Trim whitespace or character from the beginning TRIM_LEFT{{
TRIM_LEFT(h){{
hello worldh
ello worldh
TRIM_RIGHT Trim whitespace or character from the ending TRIM_RIGHT{{
TRIM_RIGHT(h){{
hello worldh
hello world


Encoding Functions

Function Description Usage in rule Example: https://google.com?a=test&b=test
ENCODE_SHA256 Apply SHA256 hash to a value. ENCODE_SHA256{{ F6902E2089478604307C194855F0896D5124D2EF
EF134894447F9139C627B91B
ENCODE_BASE64 Encode a value in Base64  ENCODE_BASE64{{ aHR0cHM6Ly9nb29nbGUuY29tP2E9dGVzdCZiPXRlc3Q=
ENCODE_URL URL encode a value ENCODE_URL{{ https%3A%2F%2Fgoogle.com%3Fa%3Dtest%26b%3Dtest
ENCODE_HTML HTML encode a value ENCODE_HTML{{ https://google.com?a=test&b=test
DECODE_BASE64 Decode a value in Base64 DECODE_BASE64{{ https://google.com?a=test&b=test
DECODE_URL URL decode a value  DECODE_URL{{ https://google.com?a=test&b=test
DECODE_HTML HTML decode a value DECODE_HTML{{ https://google.com?a=test&b=test

 

 

 

 

 

Related to

Was this article helpful?

1 out of 4 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.