Trimming Data...

[ChiTownDiva]

Afternoon All...

I have a formula that someone on Tek-Tips was kind enough to share:

stringvar a:={JOB_TITLE} ;//replace with your field
stringvar slash:=trim(mid(a,instrrev(a,"/&quot+2));
trim(mid(slash,instr(slash," &quot+1 ) )

What this formula does is take care of spaces in a Job title code field i.e.:

0000/ H3340 Manager - Sr Product Markets

The result is "Manager - Sr Product Markets"

Now I have a new problem:

0000/ H3340 Manager - Sr Product Markets/LIF

The result is "LIF".

I know I need to add a line to take care of this, but could someone help me out?

Thanks in advance.

ChiTownDiva

 

[synapsevampire]

Try:

mid({table.field},instr({table.field},"/&quot+1)

This assumes that you want the /LIF in the result, you didn't specify.

-k

 

[ChiTownDiva]

Thanks synampsevampire...

I need to formula to bring back:

Manager - Sr Product Markets/LIF

The purpose of the original formula was to bring back
"Manager - Sr Product Markets" whether it looks like:

0000/ H3340 Manager - Sr Product Markets
0000/H3340 Manager - Sr Product Markets
0000/ H3340Manager - Sr Product Markets
0000/H3340Manager - Sr Product Markets

The new problem popped up when HR decided to add the "/LIF" to the end a number of Job Titles.

Thanks.

ChiTownDiva