Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi How to reduce the size of the content
I jave a field by name Description Which has the below conetent
I want to show only one word
How do i write at the script ?
DIPHTHEROIDS-CORYNEBACTERIUM SPECIES
MORGANELLA MORGANII subsp. MORGANII
.
.
.
.and son
can you have some more sample ??
if it always have the - has the separator ...then
subfield(fieldname,'-',1)
OR
left(fieldname,10)
May be Purgechar(String,'Characters to be removed should be here') can help
can you have some more sample ??
if it always have the - has the separator ...then
subfield(fieldname,'-',1)
OR
left(fieldname,10)
May be
Subfield(Fieldname, '-')
Which will remove the text after the first '-'.
In your case it will return
DIPHTHEROIDS
Thanks
Kiran kumar
Hi digvijay
Ther are many charecter ,
How can i write all the things ?
I have around 10000 rows
I think I misunderstood, If you want the first word like DIPHTHEROIDS having '-' always after that then use subfield as others rightly suggested.
Purgechar is used when you want to remove special characters or the characters you know you don't need. For example PurgeChar('ABCD123$#%$','123$#%$') will remove all non alphabetic chars.
Hi Kumar
I want to keep only first field and remove everything afte first word
Subfield(replace(yourfield,'-',' '),' ',1) would return first word splitted by ' ' or '-'
Hi John,
something along these lines:
Data:
Load * Inline
[
Description
DIPHTHEROIDS-CORYNEBACTERIUM SPECIES MORGANELLA MORGANII subsp. MORGANII
];
Data01:
NoConcatenate
Load SubField(Description, ' ', 1) as Description
Resident Data;
Drop table Data;
HTH
Andy
Hi,
You can use subfield here and if you still find '-' as part of the string, you can use trim, purgechar or replace to remove that character.
Thanks
Kiran Kumar