Extract Values

Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Versions Compared

Old Version 1

changes.mady.by.user docuser1

Saved on Sep 24, 2018

compared with

New Version Current

changes.mady.by.user docuser1

Saved on Aug 27, 2019

Key

This line was added.
This line was removed.
Formatting was changed.

...

The following example transformation extracts the word #bigdata from the column msg_LinkedIn:

d-

...

trans

RawWrangle	true
p03Value	'#bigdata'
Type	step
WrangleText	extractpatterns type: custom col: msg_LinkedIn on: '#bigdata' limit: 1

...

D trans

p03Value	'#bigdata'
Type	step
p01Name	Column to extract from
p01Value	msg_LinkedIn
p02Name	Option
p02Value	Custom text or pattern
p03Name	Text to extract
p04Value	1
p04Name	Number of matches to extract
SearchTerm	Extract text or pattern

...