Removing all characters before a certain type of character

zendo59 · Post by **zendo59** » Tue Mar 04, 2008 4:28 pm

In a Transformer stage

I have a field defined as Varchar (50) which contains values like

CBAIB\jon
CBAIB\fred
PBS\jon
XXXX\xxx

I need to strip off the \ and all characters preceding it so the output will look like

jon
fred
jon
xxx

Can someone point me in the right direction?

Thanks in advance.

chulett · Post by **chulett** » Tue Mar 04, 2008 4:40 pm

Is Field() available in PX? If so:

Code: Select all

Field(YourColumn,"\",2)

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 5:32 pm

Yes, Field() is available in parallel Transformer expressions.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 5:34 pm

Yes, Field() is available in parallel Transformer expressions.

zendo59 · Post by **zendo59** » Tue Mar 04, 2008 5:47 pm

Thanks guys. FIELD worked like a charm!

kduke · Post by **kduke** » Tue Mar 04, 2008 10:36 pm

I think you want:

Field(YourColumn,"\",2,9999)

chulett · Post by **chulett** » Wed Mar 05, 2008 8:18 am

Only if there are multiple delimiters in the string and you want all of the 'fields' after the first one. The assumption here was there were only two fields in the string, i.e. one delimiter.