EXTRACTING FROM A TEXT

[Courtney Aspinwall]

I want to extract from the text "6.000000EXPB/0.99986", starting with "B/", so my extraction would be 0.99986

[Gaia Paolini]

Try this calculated column: assuming there is only one B/

Split([yourTextColumn],'B/',2)

[Courtney Aspinwall]

That does work but I left off  something important. I have several text that have B/M or B/D, example "4.760000.703926B/DXYRSB/0.99985.446900" my calc as follows:

 

"If((not ([bF_SPLIT]~="B/D")) And (not ([bF_SPLIT]~="B/M")),Split([bF_SPLIT],"B/",2),NULL)"

 

This was just excluding it all together. Which i understand now, so thank you but I want to pull the "B/" but not "B/D" or "B/M".

[Gaia Paolini]

can you post a sample Are there multiple B/D or B/M or B/ in a single text value Are there values with only a B/M (in that case nothing would be extracted)

[Courtney Aspinwall]

All texts will have the #value following "B/" but not all texts will have "B/M" or B/D".

[Courtney Aspinwall]

COMBINE

11.12304XB/D3.000000EXPB/0.12986

28.44000XM/2.000000EXPB/1.99986

14.93567XB/M1.000000EXPB/2.915686

11.12304XB/D6.000000EXPB/0.12987

12.44000XM/5.000000EXPB/1.99987

5.93567XB/M2.000000EXPB/2.915687

[Gaia Paolini]

Based on the sample provided, I would suggest this:

RXextract([COMBINE],'(