Issue with Subfield

[Anonymous]

Hi All

I have field which I need for futher field creation using

if( Temp='Blank','Blank',Trim(SubField(Temp,Mid(Temp,FindOneOf(Temp,'~!@#$%^&*()_+`-={}|[]\:<>?,./'),1),1)))  as Temp_New

where Temp_New will be AAA BBB CC

its working fine  for below list

AAA BBB CC - DDD - Bonds

AAA BBB CC - EEE - Credit

AAA BBB CC - EEE - FX PB

AAA BBB CC - EEE - Rates

its not able to work for such case with no separator

AAA BBB CC  EEE Credit

Temp

Blank

AAA BBB CC - DDD - Bonds

AAA BBB CC - EEE - Credit

AAA BBB CC - EEE - FX PB

AAA BBB CC - EEE - Rates

AAA BBB CC  DDD Bonds

AAA BBB CC  EEE Credit

AAA BBB CC  EEE FX PB

AAA BBB CC  EEE Rates

AAA BBB CC > EEE > Quantitative Alalytics

[el_aprendiz111]

Hi,

LET v_chr= '-_><,./?+=)(*&^%$#@!|\`~';


LOAD *,
SubField(purgechar(Blank, '$(v_chr)'), ' ',1) & ' ' &
SubField(purgechar(Blank, '$(v_chr)'), ' ',2) & ' ' &
SubField(purgechar(Blank, '$(v_chr)'), ' ',3) & ' ' &
SubField(purgechar(Blank, '$(v_chr)'), ' ',5) AS New_Field


Inline [
Blank
AAA BBB CC - DDD - Bonds
AAA BBB CC - EEE - Credit
AAA BBB CC - EEE - FX PB
AAA BBB CC - EEE - Rates
AAA BBB CC  DDD Bonds
AAA BBB CC  EEE Credit
AAA BBB CC  EEE FX PB
AAA BBB CC  EEE Rates
AAA BBB CC > EEE > Quantitative Alalytics
];

EXIT Script;