Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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
Contributor
MVP
wodnicki
MVP

Likes

923 likes

Total Posts

1,050 posts

Correct Reply

493 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

923 likes

Total Posts

1,050 posts

Correct Reply

493 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
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
Contributor
MVP
wodnicki
MVP

Likes

923 likes

Total Posts

1,050 posts

Correct Reply

493 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

923 likes

Total Posts

1,050 posts

Correct Reply

493 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
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?