Advanced Expression

Avatar

Avatar
Validate 1
Level 2
derrickr8850025
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
derrickr8850025
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
derrickr8850025
Level 2

06-02-2019

Hey guys

I am trying to convert some Teradata code into an advanced expressions in Adobe. Would any know how to do the following in Adobe?

POSITION('C0'XC IN TRIM(BOTH FROM TABLEA) > 0

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

08-02-2019

Hi,

Bad info I got from this page: ASCII Table. If you have access to shell it's `echo -e '\xc0'` which will show something else.

Either way, you're probably better off using the sql functions directly, which you can expose by following this guide:

Note this will only work in limited scenarios with FDA, where the query is executing on the Teradata side (targeting dimension is a td schema). To verify sql is as expected, use preview in the query dialog or turn sql tracing on for the workflow.

Thanks,

-Jon

Answers (2)

Answers (2)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

06-02-2019

Hi,

Charindex('ë', Trim(@bothFromTableA)) > 0

Thanks,

-Jon

Avatar

Avatar
Validate 1
Level 2
derrickr8850025
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
derrickr8850025
Level 2

Likes

8 likes

Total Posts

18 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
derrickr8850025
Level 2

08-02-2019

Ok a few questions:

1: How did you do the e? What keyboard commands that?

2: And the query will eventually look like this?

(Position('C0'XC IN Trim (Both From cc.household_demographics_key)) > 0 
OR Position('C1'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C2'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C3'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR
Position('C4'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C5'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR
Position('C6'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C7'XC IN Trim (Both From cc.household_demographics_key)) > 0.....

How would you do that?