removing string

[Vishnu_murthy]

input of table1:

abc.ltd,

xyz.limited,

asd.hsc,

ghj.mnc,

qwe.ltd,

lkj.oc

i need Resulting out like:- 

abc,

ghj,

lkj,

xyz like ......

[Marijn]

Depending on whether you know exactly which strings you would like to remove, you can use a nested replace. You can formulate is like this:

replace(replace(Replace(input_field,string_A,’’),string_B,''),string_C,'')

This effectively replaces the strings by nothing. In your case this would look something like:

replace(replace(Replace(input_field,'.ltd',’’),'.limited',''),'.hsc','')    etc...

[MarcoWedel]

table1:
Load SubField(input,'.',1) as input
From ...